Open txt file with more than 256 columns (how to tranpose in rows)?

[uriel78]

I've a *.txt file with data organized in about 1000 columns.
Is there a way to open this txt file in excel transposing each column in a
row ??

 

[Dave Peterson]

I searched google and found a post by Bernie Deitrick:

http://google.co.uk/[email protected]

It may give you some ideas.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm