Remove Space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several rows of information where I need to remove the space between words in the cell. e.g

Cell A1 content is - COW JUMPS OVER THE MOON

I need to remove spaces between the words so that the cell content reads - COWJUMPSOVERTHEMOO

Is there any way I could do this for a range of cells by use of a formula without going through the pain of doing this in each individual cell.
 
try
=Substitute(A1," ","")

either that, or select the range, press CTRL-H, enter a space in "find" and
leave "replace with" blank.

Then replace all.


Prasad Gopinath said:
I have several rows of information where I need to remove the space
Click to expand...
between words in the cell. e.g
Cell A1 content is - COW JUMPS OVER THE MOON.

I need to remove spaces between the words so that the cell content reads - COWJUMPSOVERTHEMOON

Is there any way I could do this for a range of cells by use of a formula
Click to expand...
without going through the pain of doing this in each individual cell.
 
Back
Top