Hi
you may have a look at the following macro
http://support.microsoft.com/default...;EN-US;q120596

though written for Excel 95 the changes for Excel97+ are indicated

--
Regards
Frank Kabel
Frankfurt, Germany

Matthew wrote:
I have a 100,000+ character linear text file that I would like
convert
to a worksheet.
Each record will be 178 characters long. I feel certain that a
visual
basic module would do the
job, but it is beyond my capabilities at this point. Thanks in
advance for any ideas.

Matthew Saxon