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

As usual, work from a blank sheet. Obviously, you might need to change the path and filename for the text file's variable values.

Please Login or Register  to view this content.