I was able to combine a couple solutions together to accomplish this task, one for extracting a string, a second for incrementing a number within a string and a third for substituting one for the other but the result is a huge formula.
Is this the most efficient way to accomplish this or is there some more efficient method that I'm not seeing?
First: Extract "Row-x" to helper column B:
Then increment "Row-x" to "Row-x+1" to helper column C:
Then substituting one for the other:
For the final result without using helper columns (longer because I've had to repeat certain parts:
Bookmarks