One possibility is to add a column (perhaps temporarily) and enter the
formula =Left(A1,4), where A1 contains the first item to convert, then
you copy down the formula as far as needed.
Then you can hide the original or you can Copy - Paste Special Values
your new results over the originals and then delete the temporary
column.
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=492215