In A3 put....
=MID(A1,2,2)

In A4 put....
=RIGHT(A1,2)

Vaya con Dios,
Chuck, CABGx3


"David" wrote:

Can you create a formula to spit a cells contents.

EX. in A1 = W3056
I would like A3= 30
and A4 = 56

Is this possible