As some of you may know, excel cuts files off at about 65000 lines. The file that im opening is a .csv or a comma delimited file, with about 1.5 million lines. Now I've googled and people have said to use MATLAB or similiar software to open it, but our familiarity with EXCEL pretty much makes us have to us it for this analysis. Is there a way to cleverly split the files into 65000 line chunks? Any help is appreciated.
Basically we need to do table lookups, means, and some inventory cost analysis. We also have some simulation software connected to excel which makes us have to use excel.
Basically we need to do table lookups, means, and some inventory cost analysis. We also have some simulation software connected to excel which makes us have to use excel.
Facebook
Twitter