Change Word labels into Excel List

L

Liana H

I have Word address labels that were typed up by hand (a mail merge was *not*
used to create these labels.) Is there a way to convert these labels into an
Excel spreadsheet? Simply copying and pasting the data is not working out
well, since the labels were hand-typed, and each line of the label is going
into the Excel spreadsheet in a weird way. Basically, I am looking for the
quickest, easiest way to do this - I am trying to get my company's holiday
cards together!
 
Joined
Mar 31, 2009
Messages
3
Reaction score
0
List not sorted into tables

I have an address list that isn't sorted into a table:

James Abel Lora Black Phyllis Campbell

1350 South 900W 230 E. 13th St. 105 Marshall Dr.

North Vernon, IN 47265 Seymour, IN 47274 Crothersville, IN 47229

Instead they are typed in with a tab between the first name in the column and the second name in the column, etc. There is a paragraph character at the end of each line. Some addresses have three lines (name, address, city/state/zip), and others have 4 lines (name, address, PO Box, city/state/zip). I can't figure out how to convert this to a list with rows in excel so that we can easily decide which people to send information to. This list comes to us once a month and we have to sort it and send out a mailing. Help us to streamline this process...

THANKS!!
Nate
 
Joined
Mar 31, 2009
Messages
3
Reaction score
0
see attachment for details...
 

Attachments

  • jc april b-days 2009(2).doc
    32 KB · Views: 1,952

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