Address List Conversion Column to Rows


T

ThrowAwaySmith

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
 
Ad

Advertisements

L

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

Sorry about the anonymous name and contact info. I forgot to reset it
from posting to other groups. This post is correct.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top