How to combine functions in a formula

Let’s do that step-by-step.

First, I’ll use theRIGHT functionto extract the three characters from the right.

This gives us the number.

you might see by the left alignment that the number is still in text format.

We get a correct result of 2, but we loose the padding with zeros.

So let’s add the padding back using theTEXT function.

The TEXT function lets us apply a number format inside a formula.

OK, so now we have our incremented number padded with zeros.

The final step is to rejoin this number to the original text using simpleconcatenation.

Now I can just copy the formula down the table to increment the remaining values.