For the year:

=LEFT(A1,2)

For the month:

=MID(A1,3,2)

HTH,
Elkar


"Rod Cooley" wrote:

I'm trying to pull a 2 digit year from a text sting. This is how it looks.
I'm trying to extract the 2 digits from the left for the year, then the next
2 digits for the month. Is there a way of doing this?

960158963415
011158694632
001056956225
040138693254


Thanks
--