Greetings.
I m trying to do some indexing in my company (using excel 2016) and i would like to:
A) Be able to insert a 3 digit code (from A4 until A10000 cell) but when i write this code to AUTOMATICALLY have a prefix of 2020 (lets say if i write 2XL the result will be 2020.2XL)
B) The 3 digit code should be UNIQUE (so the A4:A10000 should have unique values) => i ve done it
I ve managed to achieve B.
Can anyone help with A?