My suggestion was to take the time to do it once with the macro recorder turned
on. Then use that macro to import the next million text files.

I gotta believe that importing the file with the macro recorder turned on would
be quicker than creating the 107 formulas.

GARY wrote:

Creating column-breaks to parse the 1,274-character rows into 107
fields then formatting the resulting fields ONE TIME would be very
tedious. Doing it EVERY TIME I open the files would be horrible!
That's why I took the time to write the formulas. Now, the formulas
are readily available to divide the contents of the cells in Col A and
to format the resulting fields.

--

Dave Peterson