Why not import the file again and specify fixed-width in the Import
Wizard?

Alternatively, you can use

=LEFT(A1,8)

to get the first 8 characters from A1, and

=MID(A1,9,8)

to get the next 8 characters, and

=MID(A1,17,8)

to get the next 8 characters, etc.

Hope this helps.

Pete

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???