in a helper column use the TRIM function, e.g.

=TRIM(A1)

"__1234" will become "1234" (leading spaces removed)

Good Luck


--
swatsp0p


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