ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Getting specific data from a word document into an excel sheet (https://www.excelbanter.com/excel-worksheet-functions/7484-getting-specific-data-word-document-into-excel-sheet.html)

smintey

Getting specific data from a word document into an excel sheet
 
I am trying to import a table of data from another programme into excel to
create a chart. The table that i am importing is not in table format and is
just a word document which looks like a table. Most of the data in the
document is words and symbols but I need to highlight the two collumns of
numbers only and somehow get them into individual cells in excel. I am having
real difficulty doing this as when I try to highlight the collumn and drag
down it highlights the whole document as per normal word behaviour. If anyone
has any ideas on solving my problem using any aspect of office they will be
hugely appreciated!!

Thanks everyone
Steve
Microsoft Office Word 2003

CarlosAntenna

see the answer in excel.worksheet.functions

"smintey" wrote in message
...
I am trying to import a table of data from another programme into excel to
create a chart. The table that i am importing is not in table format and

is
just a word document which looks like a table. Most of the data in the
document is words and symbols but I need to highlight the two collumns of
numbers only and somehow get them into individual cells in excel. I am

having
real difficulty doing this as when I try to highlight the collumn and drag
down it highlights the whole document as per normal word behaviour. If

anyone
has any ideas on solving my problem using any aspect of office they will

be
hugely appreciated!!

Thanks everyone
Steve
Microsoft Office Word 2003




CarlosAntenna

see the answer in excel.misc

"smintey" wrote in message
...
I am trying to import a table of data from another programme into excel to
create a chart. The table that i am importing is not in table format and

is
just a word document which looks like a table. Most of the data in the
document is words and symbols but I need to highlight the two collumns of
numbers only and somehow get them into individual cells in excel. I am

having
real difficulty doing this as when I try to highlight the collumn and drag
down it highlights the whole document as per normal word behaviour. If

anyone
has any ideas on solving my problem using any aspect of office they will

be
hugely appreciated!!

Thanks everyone
Steve
Microsoft Office Word 2003




smintey

I dont understand sorry. where is the answer?

"CarlosAntenna" wrote:

see the answer in excel.worksheet.functions

"smintey" wrote in message
...
I am trying to import a table of data from another programme into excel to
create a chart. The table that i am importing is not in table format and

is
just a word document which looks like a table. Most of the data in the
document is words and symbols but I need to highlight the two collumns of
numbers only and somehow get them into individual cells in excel. I am

having
real difficulty doing this as when I try to highlight the collumn and drag
down it highlights the whole document as per normal word behaviour. If

anyone
has any ideas on solving my problem using any aspect of office they will

be
hugely appreciated!!

Thanks everyone
Steve
Microsoft Office Word 2003






All times are GMT +1. The time now is 07:17 AM.

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