Breaking notepad file with 1000000 lines to smaller excel files

D

Dharnik Shah

Hi,

I have a noepad file with approximately 720000 lines in it. Is there any
funcion in excel whereby on opening the file the data gets equally divided in
between 12 files or worksheet each containing 60000 rows/lines.

Please provide a formula or utility as I am not aware about programming.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Notepad or .txt file to excel 3
"manual page breaks error" 5
Excel File Size 9
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Filter Notepad file into Excel 1
["\r\n" new line command in CSV file] 1
"/r/n" CSV file In Excel 0
Text to Columns with Line Breaks. 3

Top