Import text file data into excel

Hello,

I have a text file with data that I would like to import into excel and make it look like database entries. The idea is that once the text file data is cleaned and properly sorted in excel, it then will be imported into Access.

I have cleaning by trying IF statements and then applying filters manually but I require a better solution.

Any help is appreciated.


Arvin