|
Importing large text into Excel
I'm trying to open several large text file of 172800 lines for processing in Excel, however excel only allows 65536 lines in the worksheet. Text Import Wizard also present the same problem. Also, the max line I can start importing in Text Import Wizard is 32767 making it impossible for me to import the whole 172800 lines in the file.
My intention is to import the large text into several worksheet i.e. 172800 distributed nicely into 3 worksheets but I do not know how.
I've 1400 or 11GB or such .txt files to open into excel so manual spliting the .txt files are not an option.
Would appreciate if any Excel guru can help me with this.
|
Linear Mode
