Take a look at DataText To columns, and use a comma delimiter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bbc1" wrote in message
...
I have address's that have been imported from a delimited text file in the
following format.
9,Hall,Street,Billytown,6666
I would like to extract it into colums
ie Column 1 9
Column 2 Hall Street
Column 3 Billytown 6666