| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
Hi everyone,
I would like to process a text file with more than 65536 lines. Is there any possiblity to do that with Excel ? Either to do it in many iterations (like import lines 1 to 65536, then 65537 to 131072, and so on) or to import it once and split lines 1 to 65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc... Thanks for any feedback & have a great weekend! Joel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading in text file that is more than 65536 rows | Excel Programming | |||
| Can I go beyond 65536 lines in a file? | Excel Discussion (Misc queries) | |||
| Importing Text File with more than 65536 rows | Excel Programming | |||
| Importing a large text file (65536) | Excel Programming | |||
| export a text file which more than 65536 rows into excel | Excel Programming | |||
Threaded Mode
