Column mailing list needs to be converted to rows

[Loren Smith]

I have been handed a list that I need to convert and I am stumped.

The worksheet contains three columns of addresses. The addresses are
generally in one of three formats:

Company
Contact
Street number and name
City State
Zip

or

Name
Street number and name
City State
Zip

or

The repeat of the above with two lines for street information.

As far as I can tell so far, these four are the only the different
formats.

Some of the addresses have a comma between the city and state.

One final complication, some addresses use the 5 digit zip, some use
the zip+4 with a dash.

Is there a way to convert these columns into approptiate rows so this
can be used as a mail merge?

Loren

 

[Sunday88310]

Good Evening "Loren"
I am sure that their are many ways to do this in Excel./
Me, I find that I would convert this to an ACCESS Data Base, Is ther any
special reason's why you maintain the addresses (client information) in
Excel? Access wizard can help you move the information, and create a mailing
list as well. Back up your information in another location, before
converting to ACCESS to check the integerty of the transfer. :>}

 

[Loren Smith]

Good Evening "Loren"
I am sure that their are many ways to do this in Excel./
Me, I find that I would convert this to an ACCESS Data Base, Is ther any
special reason's why you maintain the addresses (client information) in
Excel? Access wizard can help you move the information, and create a mailing
list as well. Back up your information in another location, before
converting to ACCESS to check the integerty of the transfer. :>}

I hadn't thought of using Access. I don't maintain this list. I was
just asked to fix the problem. I also know that my friend doesn't
know Access. Actually, my involvement with Access isn't all that
extensive, but this does sound like a promising route. I will have to
give it a try.

Thank you.