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

This is a repost of a question that I asked yesterday. I am afraid
that it was not propigated due to anonymous email information that I
had inserted in my newsreader program. I have corrected that error

There must be ways to tell if the data is Company, Contact, or Name. The
rest is simple

--
Regards
KC Cheung
Ho Chi Minh City
"Loren Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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
>
> This is a repost of a question that I asked yesterday. I am afraid
> that it was not propigated due to anonymous email information that I
> had inserted in my newsreader program. I have corrected that error