How to set auto-prefix in Excel?

[Haris1977]

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?

Edited December 17, 2019 by Tripredacus

[Tripredacus]

In general theory:

$dataInsert = "2020." & $var

What language are you using?

[Haris1977]

I have the english version if this is what you mean. Will try your code tomorrow in work as i am home as we speak. I will report back

 

 

Where should i put this code? Cause i have already one formula in column A

 

 

[Tripredacus]

You posted into the programming section, that is what I mean by language. My "code" is "code theory" and while it may be usable in certain languages, it is only an example.

If you are not writing a program to do this, I can move the topic into the Office section.

[Haris1977]

Thanks for your suggestion.

Meanwhile i ve managed to do it, but anyway thanks.

 

Topic is considered closed:)