Posted to microsoft.public.excel.programming

Srikanth[_7_] Srikanth[_7_] is offline

external usenet poster

Posts: 2

reading a data file

Hello,

I am trying to read a text file with data(+headers) with the following
format.

X
12.1
23.
43
54
..
..
..
Y
5
76
87
34
23
..
..
X
..
..
..
Y
..
..
..

I want to rearrange it into two columns X and Y. How do I do that. I
want to write en excel macro. Please help. Thanks

Srikanth

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
reading from another file and pasting to current file, "combobox"	Darius	New Users to Excel	1	September 26th 05 07:13 AM
Reading a text file ?	WTG	Excel Worksheet Functions	2	February 22nd 05 01:29 AM
reading contents of a file	Christopher Brooks[_3_]	Excel Programming	2	June 14th 04 09:06 PM
Reading from ini file	Tammy[_4_]	Excel Programming	4	February 8th 04 10:11 AM
Reading from file	Asif[_3_]	Excel Programming	4	November 16th 03 05:28 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us