go to
data
text to columns
delimited
;
destination (in the next column say .........B2?)
take a copy of the wrkbk before you start and have a go........
--
bill k
------------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...nfo&userid=821
View this thread:
http://www.excelforum.com/showthread...hreadid=468545