Change Word labels into Excel List

[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!

 

[Suzanne S. Barnhill]

See http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm for
instructions for converting them to a Word table, which you can then paste
into Excel.

 

[Liana H]

Perfect!! Exactly what I was looking for. thank you so much!

 

[Suzanne S. Barnhill]

You're very welcome.

 

[untern8]

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

 

[untern8]

see attachment for details...