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. :}
--
William<"M"
Using 2007


"Loren Smith" wrote:

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