|
|
A LOT easier formula is:
=SUBSTITUTE(A1," ","")
--
Regards,
Dave
<!--
"JenBasch" wrote:
I am trying to figure out how to remove a space between two words in one
cell.
ex: dog house ---- doghouse
Once I figure that out I want it to look through a lot of cells and if
they have a space take it out (above) and if not leave it the way it
is.
Thanks for any help available,
Jen
--
JenBasch
------------------------------------------------------------------------
JenBasch's Profile: http://www.excelforum.com/member.php...o&userid=27369
View this thread: http://www.excelforum.com/showthread...hreadid=468842
|