Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I select specific information from an imported table
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 |
#2
|
|||
|
|||
Hi Steve,
Hold the Alt key while you drag. If you're very careful or very lucky, you won't trigger the Research pane, whose shortcut is Alt+Click (stupid move, Microsoft!) and you'll be able to select a rectangular region of text. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org On Mon, 6 Dec 2004 04:01:03 -0800, "smintey" wrote: 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 |
#3
|
|||
|
|||
Replied to duplicate question. In the word.drawing.graphics
newsgroup, I think. Cindy Meister |
#4
|
|||
|
|||
Hi Jay
Thanks that is great and it worked first time!!! However I now need to paste the selected data into excel. Copying it like you suggested leaves it as a big block of coppied material and I was wondering if there was any way of pasting it into individual cells in excel? Pleeeeeeeeease help!!! Thanks again Jay Steve "Jay Freedman" wrote: Hi Steve, Hold the Alt key while you drag. If you're very careful or very lucky, you won't trigger the Research pane, whose shortcut is Alt+Click (stupid move, Microsoft!) and you'll be able to select a rectangular region of text. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org On Mon, 6 Dec 2004 04:01:03 -0800, "smintey" wrote: 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 |
#5
|
|||
|
|||
In this case you might be better off using Table | Convert Text to Table,
separating text at tabs (assuming you have just one tab between text columns). Once the text is in a table, it should be easy to copy and paste into Excel. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "smintey" wrote in message ... Hi Jay Thanks that is great and it worked first time!!! However I now need to paste the selected data into excel. Copying it like you suggested leaves it as a big block of coppied material and I was wondering if there was any way of pasting it into individual cells in excel? Pleeeeeeeeease help!!! Thanks again Jay Steve "Jay Freedman" wrote: Hi Steve, Hold the Alt key while you drag. If you're very careful or very lucky, you won't trigger the Research pane, whose shortcut is Alt+Click (stupid move, Microsoft!) and you'll be able to select a rectangular region of text. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org On Mon, 6 Dec 2004 04:01:03 -0800, "smintey" wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select specific data from an imported document | Microsoft Word Help | |||
Row height problem with table in table | Tables | |||
table caption numbering | Tables | |||
Repeating Table headings with "Continued" | Tables | |||
Getting the format of a table | Tables |