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!

--------------------
(Ms-Exl-Learner)
--------------------



"Vic" wrote:

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.