I am about to import a large text file (9MB) into excel and have encountered a problem. The file is too big to load in, > 65000 lines available. As I would be wanting to separate the data across a number of sheets, would there be a way to "post" each line to a specific sheet based on the first few characters of each line of data. And thus allow the whole sheet to load?
Or is there something else that could assist me with this challenge?
As always I'm ever grateful for any suggestions.
Or is there something else that could assist me with this challenge?
As always I'm ever grateful for any suggestions.