F1, or record the macro, or use a fancy pants
text import.
I use an unholy combination of C#, Python, Excel and sed to munge data around (don't ask, it's one of those things where the progenitor of the thing that makes the report files did that thing where the output looks pretty on screen but is actually about as machine-readable as a punch in the face) these days.