ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Get data from Word into Excel (https://www.excelbanter.com/excel-discussion-misc-queries/177601-get-data-word-into-excel.html)

Moprem

Get data from Word into Excel
 
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?
--
Thanks

David Biddulph[_2_]

Get data from Word into Excel
 
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.
--
David Biddulph

"Moprem" wrote in message
...
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?
--
Thanks




Gord Dibben

Get data from Word into Excel
 
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

On Fri, 22 Feb 2008 13:02:00 -0800, Moprem
wrote:

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?




All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com