Making prefix from current data Follow

0
Avatar
Karol Olszewski

Hello everyone

I would like to ask a (simple) question. How to make prefix from current data, as a single character, so in our example we want 2021 be changed into "D", when 2022 changed into "E" etc.

Is this even possible?

 

Thanks in advance

2 comments

0
Avatar
Paweł Gancarz
Comment actions Permalink

Hello

You can do the simplest solution in the Transform command search and replace.

0
Avatar
Pete Thane
Comment actions Permalink

Or else you could use VB and do a Dim routine or an If...then...else statement 

Please sign in to leave a comment.