Select the column & then go to Data | Text to columns | check fixed
width | next | create break line between the text & number | next |
finish


On Sep 19, 3:13*am, dwake wrote:
I have a colum of serial no's and I want to segregate the prefix from the
last five digits. *Each serial no. contains a three digit prefix followed by
a five number sequence, these numbers are not sequential in my spread sheet.

e.q. *
* * * * * * A * * * * * * * * * B * * * * * * * * *C
1 * * ABC12345 * * * * *ABC * * * * * * 12345
2 * * ABD12356
3 * * ABR12312

Is there anything I can do to automatically fill in the B and C columns
without having to invidually pull out. *Is there a way to tell excell to look
at column A, input the first three digits into column B and the last five
digits into column C? *Any help would be appreciated.