How to import raw .txt data into Excel

I have files of raw testing data in .txt form that I need to import into Excel spreadsheets.    The .txt files are formatted as follows:    X47312804237ACDBBADCADBCDBDCCBDAACCDACBA   (The lette...