Data Selection

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
Eric

Data Selection

Post 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.
Marek Mänd

Re: Data Selection

Post 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!
Post Reply