A mailing list in Excel

A

agr790

Currently my excel sheet has a column for Name, a column for Street1, a
column for Street2, and the city state and zip are in the same column.
The postal service verification service needs everything in different
columns. Example: John Smith 123 Main Street Small Town Tennessee 123456.
John has to be in column 1, Smith in column2 123 Main Street in column 3,
Small Town column 4, etc. Any ideas?
 
S

Sheeloo

Looks like there are only spaces between words...

If you choose the name column and choose Data|Text to columns and choose
SPACE as delimiter then name will be separated into first and last (assuming
there is no middle name)

Similarly you can split city, state and zip

You will need to play around a bit to get what you want. Without looking at
sample data it is tough to provide a complete solution...
 

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

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Duplicate detection (looking for code) 9
Automated Glossary of Terms in a Document 4
Word VBA - Automatic change content of a cell in table using dropdown list 5
Calculate the median value before a specified list 0
Macro to Create Name Ranges for variable lengths of Data 9
Complex problem probably easy answer 2
Pulling the town out of an address 5

Top