Export .txt file into specific pre-made fields in excel.?

[phil_norm]

I work for an environmental company and we do emission testing. We specifically use the analysis software CEMsoft and ProRATA. After each test/run we get a text file (.txt) that we print out which then has to put into a specific pre-made excel data file.

I am wondering if there is a way to export the data from the .txt file and into the specific fields within the excel sheet. Can I encode the .txt or excel file to do it for me? Trying to eliminate the need to manually put in the data from the printed out sheet.

[mrice]

Probably yes - suggest that you post a copy of the text file and an example of what you want the Excel version t look like.