Link to home
Start Free TrialLog in
Avatar of MilesLogan
MilesLoganFlag for United States of America

asked on

How to separate one Excel file into multiple files.

Hi EE

I have an Excel file with 100,000 line items with two columns .
Does anyone know how I can separate that into 10 files with 10,000 line items each ?
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The simplest way would be to leave the original file intact and "Save As" 10 times with different names.
e.g. 0000-1000.xls   1001-2000.xls   2001-3000 ..... etc.

Then edit the 10 files one by one, deleting the relevant 9,000 lines in each file.
Avatar of MilesLogan

ASKER

Subodh thank you so much !! exactly what I was looking for ..
You're welcome! Glad it worked as desired.