I would think that using File|Open and parsing the input record would be
quicker, but it sounds like you have a solution.

GARY wrote:

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
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 needed)

--

Dave Peterson