Pulling Year from a text string

  • Thread starter Thread starter Rod Cooley
  • Start date Start date
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
--
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Special string convertion to date and time 4
How do I calculate age using a 12 digit social security number in MS Excel? 0
Access 2 Digit year in Access Text Box 3
How do I change date format m/d/yyyy to mmddyyyy toremove the dash 1
Help obtaining value of defined names when concatenating text with formula 3
Text Extraction (parsing) 3
Hello happy new year to all, Text box input for year of purchase 0
Pulling partial information from a cell 2

Back
Top