Removing Spaces from string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

katmando - 16 May 2006 13:24 GMT

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

Signature

katmando

Reply to this Message

Ardus Petus - 16 May 2006 13:30 GMT

=SUBSTITUTE(A1," ","")

HTH
--
AP

"katmando" <katmando.27wgvn_1147782303.6926@excelforum-nospam.com> a écrit
dans le message de news:
katmando.27wgvn_1147782303.6926@excelforum-nospam.com...

> I want to be able to remove spaces from a string, that may have
> muiltiple words to create a string with no spaces.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Beege - 16 May 2006 13:31 GMT

kat

Search/Replace

Select column

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

Beege

> I want to be able to remove spaces from a string, that may have
> muiltiple words to create a string with no spaces.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Dave Peterson - 16 May 2006 13:34 GMT

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

is one way

> I want to be able to remove spaces from a string, that may have
> muiltiple words to create a string with no spaces.
[quoted text clipped - 10 lines]
> katmando's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29803
> View this thread: http://www.excelforum.com/showthread.php?threadid=542452

Signature

Dave Peterson

Reply to this Message

katmando - 16 May 2006 14:16 GMT

Thanks. the substitute was the one i needed

cheer

Reply to this Message