Dear members, I have random data (student number) like this: A120140045, A120160042; A120090122; A120120001, ...etc. Three characters from middle data (character 5th to 7th) indicate the year registration. So, based on the data, 140 is 2014; 150 is 2015; 090 is 2009; 120 is 2012; ...etc. I want get this "year" information from the data with easiest formula without having to add next year in formula (my data start from year 2000). To my knowledge, I can use IF and MID function but I don't know how to combine the function to get suitable formula automatically.
Here example my old formula that I use (still manually and long):
Thank you...
Here example my old formula that I use (still manually and long):
Code:
=IF(MID(A1;5;3)="000";2000;IF(MID(A1;5;3)="010";2001;...etc
Thank you...