In a helper column to the right use,
=TRIM(A1)
where A:A is your values. Copy down the list. Then Paste Special
Values over the old text. Delete the helper column.
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=513733