Hi to Everybody,
Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. I'm New to VBA coding so having difficulty in making this work... and I don't Know what to do.
In the Excel file I need to import my text file in like this
To this in EXCEL divided by Columns
Attached a sample txt file to be processed.
Appreciate any help with this... many thanks in advance.
Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. I'm New to VBA coding so having difficulty in making this work... and I don't Know what to do.
In the Excel file I need to import my text file in like this
To this in EXCEL divided by Columns
Attached a sample txt file to be processed.
Appreciate any help with this... many thanks in advance.
Attachments
Last edited: