What if the space appears to be at the front?? I copied some data, and i
have to go cell-by-cell and delete out the first space (but there doesnt seem
to be a space) to make a formula work that is referring to that cell??

Thanks! Veronica

"pinmaster" wrote:


Hi, have a look at the TRIM function.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493960