Report year from a Text String.

Question

Hi, novice user here,&nbsp;I am not a power user and do not know all the functions available. I am sure this is a very basic function but do not know where to start.&nbsp;Is there a function within excel to report a year or part of number from a production number :&nbsp;006.1999.140.00007 (the year ref. is in red within the string) the full text string is in one cell:001.2000.054.00015&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BT-300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.06&nbsp; Normal-1&nbsp;&nbsp;&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp; 6%&nbsp;&nbsp;&nbsp;The year is always reported as the second part of the string ie. TYPE.YEAR.MACHINE.NUMBER. The other information is irrelevant at this time i just require the year to be reported.&nbsp;&nbsp;Any help would be greatly appreciated.&nbsp;Regards,Lee

hansvogelaar · Answer

LEEBOOTH&nbsp;
Let's say you have such a value in D2.
In another cell, for example E2, enter the formula
&nbsp;
=MID(D2, FIND(".", D2)+1, 4)
&nbsp;
This can be filled or copied down if required.

leebooth · Answer

Thank you Hans. Worked a treat! 🙂

Forum Discussion

Report year from a Text String.

Share

Resources