Split 10 alphanumerics into 3 cells

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

What is the formula to split 10 alphanumerics into 3 cells?
I have A2 = 1067035C03
I need B2 = 1067, C2 = 035, D2 = C03
Thank you.
 
Vic,

Just noticed you'll lose the leading zero in C2 so custom format that cell
as 000 to get it back
 
Try this...

Use this formula in B2
=TRIM(LEFT(A1,4))

Use this formula in C2
=TRIM(MID(A1,5,3))

Use this formula in D2
=RIGHT(A1,3)

If this post helps, Click Yes!
 
mike:

when you configure the text to columns, all you have to do is select the text
radio button instead of the general button, for the specific column on step 3 of
the wizard, and it should do this for you.
 
Back
Top