Skip to Content
0
Former Member
Jun 03, 2011 at 04:32 PM

Stripping out Digits in ID Number

24 Views

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?