![]() |
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 |
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 |
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 |
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 08:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com