Page 1 of 1

Data Selection

Posted: Tue Jul 09, 2002 1:08 pm
by Eric
Hi,
I am trying to figure out how to grab text data then export
to excel so I can graph.

Currently, my data comes out something like:
f
123 456 678 945
293 998 899 999

and so on. There seems to be a macro called table,
table cell and table row. Does anybody know how
I could use this to bookmark my f data then maybe
put in a carriage return. Then I would be able
to export to excel.

Help.

Thanks.

Re: Data Selection

Posted: Mon Jul 22, 2002 8:01 am
by Marek Mänd
Just Copy all that table data to a text file.

On The Excel2k side
menu Data-Get External Data-Import Text File.

Then choose the file containing the data from disk.
And make sure you mark the delimiter there as SPACE.
Voila!