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

=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

kat

Search/Replace

Select column

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

Beege

"katmando" wrote in
message ...

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

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

is one way

katmando wrote:

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

--

Dave Peterson

Thanks. the substitute was the one i needed

cheers


--
katmando
------------------------------------------------------------------------
katmando's Profile: http://www.excelforum.com/member.php...o&userid=29803
View this thread: http://www.excelforum.com/showthread...hreadid=542452