Removing Spaces from string

K

katmando

I want to be able to remove spaces from a string, that may have
muiltiple words to create a string with no spaces.
For example "sin city" to become "sincity"

The strings will be of a random length and may contain more than 2
words such as "master & commander"

Thanks
 
B

Beege

kat

Search/Replace

Select column

Use " " for search (space)
Use "" for replace (no space)

Beege
 
D

Dave Peterson

Select the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all

is one way
 
Top