software

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 quot;sin cityquot; to become quot;sincityquot;

The strings will be of a random length and may contain more than 2
words such as quot;master amp; commanderquot;

Thanks--
katmando
------------------------------------------------------------------------
katmando's Profile: www.excelforum.com/member.php...oamp;userid=29803
View this thread: www.excelforum.com/showthread...hreadid=542452=SUBSTITUTE(A1,quot; quot;,quot;quot;)

HTH
--
AP

quot;katmandoquot; gt; a écrit
dans le message de news:
...
gt;
gt; I want to be able to remove spaces from a string, that may have
gt; muiltiple words to create a string with no spaces.
gt; For example quot;sin cityquot; to become quot;sincityquot;
gt;
gt; The strings will be of a random length and may contain more than 2
gt; words such as quot;master amp; commanderquot;
gt;
gt; Thanks
gt;
gt;
gt; --
gt; katmando
gt; ------------------------------------------------------------------------
gt; katmando's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29803
gt; View this thread: www.excelforum.com/showthread...hreadid=542452
gt;
kat

Search/Replace

Select column

Use quot; quot; for search (space)
Use quot;quot; for replace (no space)

Beege

quot;katmandoquot; gt; wrote in
message ...
gt;
gt; I want to be able to remove spaces from a string, that may have
gt; muiltiple words to create a string with no spaces.
gt; For example quot;sin cityquot; to become quot;sincityquot;
gt;
gt; The strings will be of a random length and may contain more than 2
gt; words such as quot;master amp; commanderquot;
gt;
gt; Thanks
gt;
gt;
gt; --
gt; katmando
gt; ------------------------------------------------------------------------
gt; katmando's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29803
gt; View this thread: www.excelforum.com/showthread...hreadid=542452
gt;
Select the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all

is one way

katmando wrote:
gt;
gt; I want to be able to remove spaces from a string, that may have
gt; muiltiple words to create a string with no spaces.
gt; For example quot;sin cityquot; to become quot;sincityquot;
gt;
gt; The strings will be of a random length and may contain more than 2
gt; words such as quot;master amp; commanderquot;
gt;
gt; Thanks
gt;
gt; --
gt; katmando
gt; ------------------------------------------------------------------------
gt; katmando's Profile: www.excelforum.com/member.php...oamp;userid=29803
gt; View this thread: www.excelforum.com/showthread...hreadid=542452

--

Dave Peterson


Thanks. the substitute was the one i needed

cheers--
katmando
------------------------------------------------------------------------
katmando's Profile: www.excelforum.com/member.php...oamp;userid=29803
View this thread: www.excelforum.com/showthread...hreadid=542452