Reply
 
Thread Tools Display Modes
  #1   Report Post  
smintey
 
Posts: n/a
Default 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   Report Post  
Jay Freedman
 
Posts: n/a
Default

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   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Replied to duplicate question. In the word.drawing.graphics
newsgroup, I think.

Cindy Meister

  #4   Report Post  
smintey
 
Posts: n/a
Default

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   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I select specific data from an imported document smintey Microsoft Word Help 1 December 6th 04 01:28 PM
Row height problem with table in table Stephanie T. Tables 0 November 23rd 04 03:35 PM
table caption numbering scottkinsey Tables 1 November 11th 04 11:47 AM
Repeating Table headings with "Continued" scottkinsey Tables 4 November 10th 04 06:04 PM
Getting the format of a table Kind writer/user/programmer Tables 0 October 29th 04 02:52 AM


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

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"