ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   getting specific info from a word document into excel (https://www.excelbanter.com/excel-discussion-misc-queries/1302-getting-specific-info-word-document-into-excel.html)

smintey

getting specific info from a word document into excel
 
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

When you drag to select in Word, press and hold the ALT key.

Carlos

"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

Carlos thanks that is great. However when holding alt it saves my "copy" as a
large block. Is there any way of then getting this info into individual cells
in excel? pleeeease help!!!!
Thanks
Steve

"CarlosAntenna" wrote:

When you drag to select in Word, press and hold the ALT key.

Carlos

"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

When I did it, the numbers went into individual cells.
Could it be because I'm using Office 2002?
Anyone?

Carlos

"smintey" wrote in message
...
Carlos thanks that is great. However when holding alt it saves my "copy"

as a
large block. Is there any way of then getting this info into individual

cells
in excel? pleeeease help!!!!
Thanks
Steve

"CarlosAntenna" wrote:

When you drag to select in Word, press and hold the ALT key.

Carlos

"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 05:58 AM.

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