Hi

I have contract numbers containing a mix of letters and numbers. They are 7 digits in length.

The last 3 digits are always numbers

e.g. ABCD259 cell A1 (sheet1)
FTGW514

I would like to be able to copy the contract from one sheet/cell to another but add 1 to it

so ABCD260 cell A1 (sheet2)
FTGW515

Can't seem to make it work.

Any help appreciated

thanks
Jon