I think you're over thinking things and saying you want to alter the text file before giving it to Excel.

Personally, if the text file is copying into Excel now, I'd paste it into a sheet, run a macro with a loop or two to move the cell contents to the desired locations then delete the original.

Not seeing the actual text file or an Excel sheet with the text file already copied in, suggesting anything more would just be guessing.