=CONCATENATE(" ",A1)
Then I'd copy and paste the values over the top of the original column
Regards
Special-K
--
Special-K
------------------------------------------------------------------------
Special-K's Profile:
http://www.excelforum.com/member.php...fo&userid=7470
View this thread:
http://www.excelforum.com/showthread...hreadid=562437