in reply to a stubborn excel file
Have a look at Parse Excel Spreadsheets To Single before *potentially* reinventing the wheel.