Im having much difficulty here. I wrote a macro for my Excel workbook that can read in a *.txt file and extract the proper data out of it. I need to expand this macro to be able to read in an ASCII format file. It contains the same data as the *.txt file, however, the carriage return issue is becoming a pest.

As you know when you read in an ASCII file, Excel thinks the entire file is a single line of data. The carriage returns arent recognized. I tried doing a 'split' on the single line of data using Chr(10) and later using Chr(13) and it didnt work.

Bottom line. Does anyone know how to convert an ASCII file to a Windows *.txt file so when i read in the file it actually reads in as multiple lines of data? i would like to keep all this in code and not have to read in the data into cells then perform on the those cells.