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

Depending on what your criteria is you can use text functions (LEFT, MID, or
RIGHT), and then copy and paste special selecting values to remove the
formulas.

For example:
A3: =MID(A1,2,2)
A5: =RIGHT(A1,2)

"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

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