PDA

View Full Version : Solved: Add 1 when copying and linking.



Blackie50
07-22-2010, 07:04 AM
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
07-22-2010, 09:36 AM
Something like this perhaps:
Left(Selection,4) & Right(Selection,3)+1

Blackie50
07-22-2010, 02:53 PM
How would this look in a linking formula?

thanks

Blackie50
07-23-2010, 01:24 AM
Ok - figured it now I've slept

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

cheers