ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   COPY WORD DATA TO EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/140364-copy-word-data-excel.html)

gunga

COPY WORD DATA TO EXCEL
 
Can anyone help me to copy Word data to Excel in a format that I am able to
do Excel calculations with.

Thanks



Kate G.

COPY WORD DATA TO EXCEL
 
What format is your Word data in?

Can you use the Word function to convert text to a table? If so then copy
and paste is easy.

Before anyone can help you -- knowing how your Word data is formatted would
be necessary.

Kathryn Groves
MOUS - Office 2000



gunga

COPY WORD DATA TO EXCEL
 

Thanks Kate.

Its formatted as a Rich Text File.


"Kate G." wrote:

What format is your Word data in?

Can you use the Word function to convert text to a table? If so then copy
and paste is easy.

Before anyone can help you -- knowing how your Word data is formatted would
be necessary.

Kathryn Groves
MOUS - Office 2000




Kate G.

COPY WORD DATA TO EXCEL
 
No -- format is not rich text file -- that is how the file is saved.

When I say format, I mean do you have tabbed columns of number/text or is
your data in a table or did you use the space bar to put white space between
columns... if you have columns at all.

Whether it is a txt file or a doc isn't what we need to know -- how is your
actual data entered into Microsoft Word?

Kathryn Groves


"gunga" wrote in message
...

Thanks Kate.

Its formatted as a Rich Text File.


"Kate G." wrote:

What format is your Word data in?

Can you use the Word function to convert text to a table? If so then
copy
and paste is easy.

Before anyone can help you -- knowing how your Word data is formatted
would
be necessary.

Kathryn Groves
MOUS - Office 2000







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

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