Get data from Word into Excel

M

Moprem

I have a table in Word containing a database for making address labels. I was
told this is better done in excel but I do not want to retype all the data.
Is there a way to import it?
 
D

David Biddulph

Copy from Word, paste to Excel, then rearrange as necessary to get each
record to be a row in Excel, and each field in the record to be a column.
 
G

Gord Dibben

Someone told you backwards.

Excel is poorly suited to create labels.

It is easier to make labels in Word from the data in Excel.

But, to copy data from Word to Excel, just copy and paste.

See help in Excel on "copy a word table into excel"


Gord Dibben MS Excel MVP
 

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

Similar Threads

Copying data while matching it to it's label 2
Convert Excel to Word 2
Combining Rows on a label 1
Split column contents (de-concantenate) 7
Merge and/or export data on excel spreadsheet 1
How to format data in excel into a booklet, word or publisher? 1
saving data in excel from word doc. 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top