software

I am trying to remove all the spaces from a cell so that I can create a
single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
like quot;HOTDOG.quot;

The only function I know that comes close to this is TRIM, but that
still leaves single spaces in between.

Thanks for the help people.--
killertofu
------------------------------------------------------------------------
killertofu's Profile: www.excelforum.com/member.php...oamp;userid=31024
View this thread: www.excelforum.com/showthread...hreadid=514520Hi

Select the range with entries, you want to clean from all spaces. From menu,
activate Replace dialog. Replace all spaces (quot; quot;) wit nothing.Arvi Laanemetsquot;killertofuquot; gt; wrote
in message ...
gt;
gt; I am trying to remove all the spaces from a cell so that I can create a
gt; single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
gt; like quot;HOTDOG.quot;
gt;
gt; The only function I know that comes close to this is TRIM, but that
gt; still leaves single spaces in between.
gt;
gt; Thanks for the help people.
gt;
gt;
gt; --
gt; killertofu
gt; ------------------------------------------------------------------------
gt; killertofu's Profile:
www.excelforum.com/member.php...oamp;userid=31024
gt; View this thread: www.excelforum.com/showthread...hreadid=514520
gt;

Perhaps this will work for you:

For text in A1

B1: =SUBSTITUTE(A1,quot; quot;,quot;quot;)

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=514520have a look at SUBSTITUTE

--
Don Guillett
SalesAid Software

quot;killertofuquot; gt; wrote
in message ...
gt;
gt; I am trying to remove all the spaces from a cell so that I can create a
gt; single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
gt; like quot;HOTDOG.quot;
gt;
gt; The only function I know that comes close to this is TRIM, but that
gt; still leaves single spaces in between.
gt;
gt; Thanks for the help people.
gt;
gt;
gt; --
gt; killertofu
gt; ------------------------------------------------------------------------
gt; killertofu's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31024
gt; View this thread: www.excelforum.com/showthread...hreadid=514520
gt;
=substitute(a1,quot; quot;,quot;quot;)

is one way.

killertofu wrote:
gt;
gt; I am trying to remove all the spaces from a cell so that I can create a
gt; single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
gt; like quot;HOTDOG.quot;
gt;
gt; The only function I know that comes close to this is TRIM, but that
gt; still leaves single spaces in between.
gt;
gt; Thanks for the help people.
gt;
gt; --
gt; killertofu
gt; ------------------------------------------------------------------------
gt; killertofu's Profile: www.excelforum.com/member.php...oamp;userid=31024
gt; View this thread: www.excelforum.com/showthread...hreadid=514520

--

Dave Peterson

Hi!

Try this:

=SUBSTITUTE(A1,quot; quot;,quot;quot;)

Or, you could use Editgt;Replace and do this in-place and not have to use a
helper cell/column.

Select the cell(s) in question
Goto Editgt;Replace
Find what: enter a space by hitting the spacebar
Replace with: nothing, leave this blank
Replace all

Biff

quot;killertofuquot; gt; wrote
in message ...
gt;
gt; I am trying to remove all the spaces from a cell so that I can create a
gt; single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
gt; like quot;HOTDOG.quot;
gt;
gt; The only function I know that comes close to this is TRIM, but that
gt; still leaves single spaces in between.
gt;
gt; Thanks for the help people.
gt;
gt;
gt; --
gt; killertofu
gt; ------------------------------------------------------------------------
gt; killertofu's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31024
gt; View this thread: www.excelforum.com/showthread...hreadid=514520
gt;
=SUBSTITUTE(A1)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;killertofuquot; gt; wrote
in message ...
gt;
gt; I am trying to remove all the spaces from a cell so that I can create a
gt; single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
gt; like quot;HOTDOG.quot;
gt;
gt; The only function I know that comes close to this is TRIM, but that
gt; still leaves single spaces in between.
gt;
gt; Thanks for the help people.
gt;
gt;
gt; --
gt; killertofu
gt; ------------------------------------------------------------------------
gt; killertofu's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31024
gt; View this thread: www.excelforum.com/showthread...hreadid=514520
gt;
Would have helped if I included all the damn arguments (Last one is
optional).

=substitute(text,old_text,new_text,instance_num)

=SUBSTITUTE(A1,quot; quot;,quot;quot;)

Regards
Ken..............quot;Ken Wrightquot; gt; wrote in message
...
gt; =SUBSTITUTE(A1)
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------*------------------------------*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------*------------------------------*----------------
gt;
gt;
gt; quot;killertofuquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; I am trying to remove all the spaces from a cell so that I can create a
gt;gt; single word. For example, in A1, I have quot;HOT DOGquot; then in A2, I would
gt;gt; like quot;HOTDOG.quot;
gt;gt;
gt;gt; The only function I know that comes close to this is TRIM, but that
gt;gt; still leaves single spaces in between.
gt;gt;
gt;gt; Thanks for the help people.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; killertofu
gt;gt; ------------------------------------------------------------------------
gt;gt; killertofu's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=31024
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=514520
gt;gt;
gt;
gt;

SUBSTITUTE was exactly what I was lookin' for. Thanks people.--
killertofu
------------------------------------------------------------------------
killertofu's Profile: www.excelforum.com/member.php...oamp;userid=31024
View this thread: www.excelforum.com/showthread...hreadid=514520