Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
convert word labels into excel spreadsheet 1
- Thread starter fish2
- Start date
-
1
- #2
fish2,
The first question is: how did you create the labels? If you did it as a result of a mail merge, then you can sort the original mail merge source.
If you typed them straight into labels, then you can convert the table to text based on a specific character (usually paragraph marks). Then make sure the document results in the appropriate number of columns and the items are within the correct columns. Then copy and paste the items into an Excel spreadsheet as needed, or sort them by column in Word.
Hope this helps.
The first question is: how did you create the labels? If you did it as a result of a mail merge, then you can sort the original mail merge source.
If you typed them straight into labels, then you can convert the table to text based on a specific character (usually paragraph marks). Then make sure the document results in the appropriate number of columns and the items are within the correct columns. Then copy and paste the items into an Excel spreadsheet as needed, or sort them by column in Word.
Hope this helps.
- Thread starter
- #3
- Status
