Thread
:
Removing Spaces from string
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
Removing Spaces from string
=SUBSTITUTE(A1," ","")
HTH
--
AP
"katmando" a écrit
dans le message de news:
...
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
--
katmando
------------------------------------------------------------------------
katmando's Profile:
http://www.excelforum.com/member.php...o&userid=29803
View this thread:
http://www.excelforum.com/showthread...hreadid=542452
Reply With Quote