Our system requires that you add a '19' or '20' in front of every ID number. I want to strip out the 19 or 20, but not all ID numbers are the same length and some are missing the 19 or 20. ID numbers should be 4-5 digits in length.
Ex
2010011
199237
07011
2009001
I try using the Right Function, but it doesn't work well with numbers > 5 digits long . It either adds a 0 or 9.
Right (,5)
Results
10011
99237 - (9237 is correct ID No.)
07011
09001
Any suggestions?