If your list is in Col_A, beginning in Cell A1:
B1: =LEFT(A1,10)
Copy that formula down as far as you need.
If you want to convert those formulas to values:
Select the Col_B formulas
EditCopy
EditPaste SpecialValues
Does that help?
Regards,
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=492220