| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Breaking notepad file with 1000000 lines to smaller excel files
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Breaking notepad file with 1000000 lines to smaller excel files
Chip Pearson has two free downloads for doing this, available he
http://www.cpearson.com/excel/ImportBigFiles.aspx Hope this helps. Pete On Aug 20, 9:43*am, Dharnik Shah <Dharnik wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help converting notepad/txt file to Excel | Excel Discussion (Misc queries) | |||
| breaking links between excel files when one file already deleted? | Excel Worksheet Functions | |||
| Export notepad file to Excel | Excel Discussion (Misc queries) | |||
| Filter Notepad file into Excel | Excel Worksheet Functions | |||
| Excel 2000 worksheets save incorrectly as notepad files. | Excel Discussion (Misc queries) | |||
Hybrid Mode
