First 8 characters can be extracted by =LEFT(A1) and filling down.

9 through 16 can be extracted by =MID(A1,9,5) and filling down.

Dave
--
Brevity is the soul of wit.


"Ryan" wrote:

I have imported a text file that has no delimeters. I would like to count
the first 8 characters and have excell make that field 1, then count
characters 9 thru 16 and make that field 2, ect.... Can anyone help???