Hi ckc!

its easy to do. just select cell A1
press Ctrl+H, it will open find and replace window.
in Find what: just press space bar
and leave Replace with: empty. and at last press replace.
where are the spaces...

you can also use a formula to do this
=substitute(A1," ","")


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=533357