I have a field where I want to find and replace a multiple letters within the data of a field. See example below.
I need to replace A, B and C. A should be replaced with 1, B with 2 and C with 3 when present. I know if I just had one character, I could just use the REPLACE function. But in this case I have multiple different characters that could be found within the field. How do I go about search and replacing multiple characters with the data of a field. Hopefully, that makes sense.