Extract Number from right side of a cell value, ignore number on left side

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:

Please Login or Register  to view this content.

Here is how the data is organized with an example of what will eventually be calculated in the third column

Originally Posted by FDibbins

What is the highest that last number might go to?

I would surmise 20 at the most

Correct, yes

Originally Posted by FDibbins

Apologies for the delay, RL interrupted

Try this, copied down

I don't think the formula carried over to your post

Originally Posted by FDibbins

Apologies for the delay, RL interrupted

Try this, copied down

I wanted to follow up to see if you still had the formula worked out for this question?

Try:

Please Login or Register  to view this content.

Originally Posted by JeteMc

Since the question only concerns extracting the number at the end of the text string I propose the following:
1) add a space in the concatenate formula so that instead of Jump1 it produces Jump 1
2) Use the following formula to extract the number:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Worked perfectly, thank you.

Hi,

Since you say it won't be more than 2 digits, without changing your current concatenate setup:

If you Only want to extract the Number at the far right:

Formula:

Please Login or Register  to view this content.

Or, if you want to return the Entire string but substract 1 from the Number at the far right as you described in Post # 1:

Formula:

Please Login or Register  to view this content.