Pulling Year from a text string

R

Rod Cooley

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
--
 
J

JE McGimpsey

One way:


A1: 960158963415
B1: =LEFT(A1,2) <--- Year
C1: =MID(A1,3,2) <--- Month

If you want the results to be numbers rather than text:

B1: =--LEFT(A1,2)
C1: =--MID(A1,3,2)
 
Top