Create an Excel spreadsheet from Word labels

[Guest]

I have a Word document where someone who didn't know the value of mail merge
keyed in all 200 labels by hand. They each have 2 lines per label and 30
labels per page. I would like to "reverse merge" and import the data from
these labesl into an excel spreadsheet. Haven't been successful without
major cleanup. Any ideas?

 

[Guest]

I'd save it as a text file and open into Excel.
Then do an "autosort" and delete the duplicated lines.
You may have to PARSE the data that's left to get what you want.

HTH,
Barb Reinhardt