All,

I am using a concatenate formula to combine the name of a test with a numeric counter to create an individualized data point to use in more easily recalling previous values. Because the data will not be entered in a consistent order, I need to be able to extract the number from the individual data point, subtract one and re-add the test name into that value to recall the value from that data point. Example: Jump4 > extract "4" > subtract 1 "3" > Re-add "Jump" to create Jump3 > Recall Jump3 value. That information is only to understand what I am trying to do, my issue is with the extraction formula only currently.

I have a formula that works how I need it to, but am running into a problem because one of the tests has numbers at the front of it. Can anyone find a workaround?
Formula: copy to clipboard 
=RIGHT([@[Test ID]],LEN([@[Test ID]])-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},[@[Test ID]]&"0123456789"))+1)