Need VBA to Convert 1 Column with a ton of data into several rows and columns

I am in desperate need of help. I am very new to VBA and have been trying my hardest to figure this out but not had much luck.

What I am trying to do is import almost 1200 invoice I had previously created in microsoft word and convert these invoices into a .csv format so I can import these invoices into our new invoicing program. I have managed to convert all the files into a .txt document and import them into an excel file.

now comes the tricky part...

when the .txt files imported into excel, it imported all 1200 .txt files into one column in excel. I have attached a picture of how the import looks in excel

The second attachment shows how I need the information seperated (which is all the information contained in each of the 1200 invoices)

I am pretty sure I need to write some sort of VBA code to have something like this work without doing it manually but I am going insane trying to figure out how to do this. Any help anyone could offer is greatly appreciated.

Thanks in advance



imported inv.jpg

Book2.xlsx