#1
|
|||
|
|||
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25)
i have text file about 37,418 kb i want split this into 25 equal worksheets in the same workbook |
#2
|
||||
|
||||
So far as Excel is concerned, the file size is irrelevant. What matters is the number of lines. Unless the number of lines exceeds 1,048,576, there is no need to split it across multiple sheets; indeed it is generally better not to split the data - splitting makes it harder to process later.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to merge two cells from sheet1 to one cell in sheet2 in next sheet | KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |
How to split block of text into paragraphs. | codex | Word | 2 | 09-04-2011 05:15 AM |
Checking ref # status based on sheet2 ref #. | aligahk06 | Excel | 1 | 04-26-2010 11:22 PM |
Linking text between worksheets | AndrewsGram | Excel | 1 | 03-09-2010 01:26 PM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |