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