I am trying to figure this out and am stuck. Say the text to be replaced is entered in A1 and is entered as "GSLAB-01", then use this function: =REPLACE(A1,8,2,2).

The bolded part of the function, the new_text field, what function do you enter into there to make it perform "+1". If I could figure that part out, then it is just a matter of copying the formula down.