assuming you only have one space per cell to eliminate, use this formula
in another cell (say B1):

B1=LEFT(A1,(FIND(" ",A1)-1))&MID(A1,FIND(" ",A1)+1,LEN(A1)-(FIND("
",A1)))

of course, adjust the cell reference to meet your needs.

A1=dog house returns: doghouse in B1

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468842