Fixed-Width Invoice Data to Excel

I have a set of invoice files delivered in a fixed-width plain-text format. Every field is lined up neatly, and the separators between columns are dashes. What I need is a clean .xlsx file that shows, for each invoice, only two columns:

• Invoice Number
• Date

Everything else in the source can be ignored. As long as the spreadsheet lists one invoice per row with those two fields correctly parsed, the job is done.

Use whichever tooling you prefer—Python (pandas), Power Query, Excel VBA, or any other method—so long as the result is accurate and the layout in Excel is tidy. If you automate the task, please include the script or macro so I can reuse it on future batches.

I’ll send over a sample file as soon as we start. Let me know if anything in the text layout needs clarifying, and thanks in advance for making this conversion hassle-free.