How do I remove single spaces between words in spreadsheet?

[spacecadet]

I have a column in my spreadsheet. I need to remove all the single spaces between the words in every cell of the column.

For example:
Tooth paste
Pop corn

Need to appear as:
Toothpaste
Popcorn

There are about 6000 lines so I can't do it one by one. The space is in between the two words and there are only two words per cell. Is there an easy way to do this? HELP! Thanks.

[NBVC]

In a free adjacent column you can enter a formula like

=Substitute(A1," ","") where A1 houses first string to trim and copy the formula down 6000+/- rows.

Then select that entire new column and copy it.

Go to the top cell in the original column and select Paste Special from the Edit menu and select Values. Click Ok.

Now you can delete the helper column.

[Ron Coderre]

Try this....

Select the range of cells to be impacted

From the Excel Main Menu:
<edit><replace>
Find what: (enter a space here)
Replace with: (leave this blank)
Click [Replace All]

Does that help?

[spacecadet]

Thanks... I had tried find & replace earlier but guess I was in too much of a rush and it didn't work. Retried it and that worked. Thanks.