There is list A containing Letters.
I would like to replace the Letters, with numbers:
A --> 0
B --> 1
To make it a bit harder, there are also items present which contain more info like:
A to D --> 0 to 3
I tried the replace text command, but I cant figure out how I can replace more Letters simultaneously.
Any suggestion how I could do this in a generic way?
Furthermore, 1 ‘almost’ simular/but opposite thing is, that I also have another list. Where the opposite has to happen.
0 --> A
1 --> B
2 --> C
11 --> L
I am a bit afraid that it will go wrong with 1/11 because the text has to be ‘recognized’ as 1 or 11, without mixing them up’
Thank you in advance