I recieve info from clients in outlook.
The info is client addresses and phone.
I would like to build a little function that when I drop the information
into an excel worksheet, that it would process the information to extract
the
NAME ADDRESS1 ADDRESS2 CITY ST ZIP PHONE PHONE2


the info may come like
name
address1
city, st zip

name
addr1
add2
city, st zip

It my have 0-2 phones on the line after the city, st zip

I am not sure if it would be best to paste into the formula bar (and all
take 1 cell), or to paste into a cell, and then it would be 3-7 cells.
Any idea how to handle this?
How could I tell if there is 1 or 2 address lines?

Would it be best to just do something like:
NAME = A1
ADDRESS =A2
ADDRESS2 =if(search(",",A3)0,"",A3)
City
=if(search(",",A3)0,left(A3,search(","A3)),left(A 4,search(",",A4)))
St =??
ZIP =??
phone1 =if(search(",",A3)0,A5,A6) 'how would I format it as a phone?
Phone2 =if(search(",",A3)0,A7,A8)

Thanks
Bruce