I have a list of addresses I want to sort. It was exported from a
website, so it came into Excel this way:

Company Name1
Address1
City, State, Zip1
Phone1

Company Name2
Address2
City, State, Zip2
Phone2

And so on...

My goal is to get this list into colums where column A is Name, column
B is Address, column C is CityStateZip and ColumnD is Phone. This way
I can do a mail merge, or import it into Access.

I hope my example makes sense. Thanks for your help.

Steve


--
steve_g
------------------------------------------------------------------------
steve_g's Profile: http://www.excelforum.com/member.php...o&userid=24410
View this thread: http://www.excelforum.com/showthread...hreadid=380116