Hi all

I have a whole heap of addresses such as the following.

Lagoon Garage
20 Bears Lagoon RD VIC 3517
ph: (03) 5437 9248*Motor Engineers & Repairers

Landson Auto
20 Landson RD VIC 3157
ph: (03) 5437 9248 Motor Engineers & Repairers

All the words are in one Cell in COL A and there is a line between each
address.

How do i sort of move the address and phone no so that they are in COL
B and COL C so that i end up with a list.

I do not want to do this manually

Any help would be appreciated

Thanks
Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=515151