When I get to the last set do I use right?

"Ryan" wrote:

I am trying to move the data from one worksheet to another. The source
worksheet is called "Demo File". What would my formula be? Thank you very
much for your help so far.

"Pete_UK" wrote:

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