Remove spaces between numbers in Excel

Remove spaces between numbers in Excel

  May 10, 2011    Mark Lopez

---

Suppose you have an excel files that contain thousand of data of numbers with
spaces between them.If you will remove those spaces it takes lots of time to
finish it.

In Excel, the Substitute function will ease your work to remove those spaces
because one of its function is to  replaces a set of characters with another.

The syntax for the Substitute function is:

Substitute( text, old_text, new_text, nth_appearance )

Here is the syntax of Substitute function that will remove spaces between those numbers.

         =Substitute(A1," ","")

You can see in the picture above that Substitute function removes
all spaces of cell A2.In my work experience, Substitute function is very useful.