Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open txt file with more than 256 columns (how to tranpose in rows)?
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 ?? |
#2
|
|||
|
|||
I searched google and found a post by Bernie Deitrick:
http://google.co.uk/groups?threadm=O...GP10.phx .gbl 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 uriel78 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why Excel file doesn't open by double click. | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How can I open a large Excel file with more than 65536 rows? | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) |