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