HI

MallyCat is right using Excel to split the data in the sheet is best, but if
you need to use VBA checkout the split function which splits text into a zero
based array which you can then work with.

Regards


--
Tony Green


"Mallycat" wrote:


Provided the address is always separated by a comma, just use the
Data\Text to Columns feature in Excel, selecting a delimited souce with
comma as the delimiter


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=560966