Importing text-files
I opened the text file as a delimited file (so Col A contains cells
1,274 characters long).
In B1 thru DD1, I wrote formulas (referring to A1) to divide the data
in each row into separate fields (with the desired formatting).
I then copied and pasted those formulas down to the last row containing
data.
It took some time but the results are exactly what I wanted.
|