-
Solved: Add 1 when copying and linking.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules