You didn't mention how the lines were formatted. If there are not too many sheets, you could manually use the text to columns option to split.

Otherwise, please post a small segment of the text file to allow for some experimentation.

__________________
Martin

Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.