Have a look at
datatext to columnsdelimited;
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
I have a large list of about 1,200 names and addresses in one cell
with each name+address being separated by a semi-colon. I want to
pull out each name and address and place it in a separate row. I
would really appreciate help with this.