Try using function TRIM. It removes all extra spaces at the beginning
and at the end of cells, as well as between symbols, if spaces are more
than one.


--
dminkov
------------------------------------------------------------------------
dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757
View this thread: http://www.excelforum.com/showthread...hreadid=490089