Remove Space

[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.

 

[Dave R.]

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.

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 - COWJUMPSOVERTHEMOON

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.

 

[Guest]

Thank you. It worked real well.