Split 10 alphanumerics into 3 cells

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.
 
M

Mike H

Vic,

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

Ms-Exl-Learner

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!
 
G

Gary Keramidas

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.
 
Top