Software

Ask something
Question Locked

Microsoft Word Labels convert to Excel Spreadsheet?

0 helpful
4 replies

by ecraft4 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have an unusual situation. I have a huge mailing list (about 2000 names) that appear to have been typed individually in label format in Microsoft Word 2003. Is there a way to export this data into an excel spreadsheet in a logical format? I've tried several ways and the only thing I can do is paste it directly into excel, which doesn't separate any of the fields. Unfortunately I'm having someone manually cut and paste or re-type everything, but looking for an easier, more efficient (and with less mistakes) way to do this. I appreciate any suggestions! Thanks.

4 replies

by larryd4

You could save the word file down to a base text file. Then open it again in Word and either manually enter commas to make it comma delimited or if you can figure it out do a find and replace to add the commas.

by ic-it

Open the file in Word.
Do a Saveas and save as a txt file. A wizard will open and allow you to determine the format.
open Excel.
Open the txt file and another wizard will start, allowing you to set the format.

This discussion is closed to new replies.