Solved: Add 1 when copying and linking.

[Blackie50]

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

[mbarron]

Something like this perhaps:
[vba]Left(Selection,4) & Right(Selection,3)+1[/vba]

[Blackie50]

How would this look in a linking formula?

thanks

[Blackie50]

Ok - figured it now I've slept

=left(!sheet1A1,4)&right(!sheet1A1,4)+1

cheers