Remove all spaces in a cell...
 

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

Hi

Select the range with entries, you want to clean from all spaces. From menu,
activate Replace dialog. Replace all spaces (" ") wit nothing.


Arvi Laanemets


"killertofu" wrote
in message ...

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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:
http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

Perhaps this will work for you:

For text in A1

B1: =SUBSTITUTE(A1," ","")

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

have a look at SUBSTITUTE

--
Don Guillett
SalesAid Software

"killertofu" wrote
in message ...

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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:
http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

=substitute(a1," ","")

is one way.

killertofu wrote:

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520

--

Dave Peterson

Remove all spaces in a cell...
 

Hi!

Try this:

=SUBSTITUTE(A1," ","")

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

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

Biff

"killertofu" wrote
in message ...

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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:
http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

=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 :-)
------------------------------*------------------------------*----------------


"killertofu" wrote
in message ...

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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:
http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

Would have helped if I included all the damn arguments (Last one is
optional).

=substitute(text,old_text,new_text,instance_num)

=SUBSTITUTE(A1," ","")

Regards
Ken..............


"Ken Wright" wrote in message
...
=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 :-)
------------------------------*------------------------------*----------------


"killertofu"
wrote in message
...

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 "HOT DOG" then in A2, I would
like "HOTDOG."

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:
http://www.excelforum.com/member.php...o&userid=31024
View this thread:
http://www.excelforum.com/showthread...hreadid=514520

Remove all spaces in a cell...
 

SUBSTITUTE was exactly what I was lookin' for. Thanks people.


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=514520