Removing Spaces from string

[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

[Beege]

kat

Search/Replace

Select column

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

Beege

"katmando" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ardus Petus]

=SUBSTITUTE(A1," ","")

HTH
--
AP

"katmando" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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]

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

[katmando]

Thanks. the substitute was the one i needed

cheers