I have a cell which is has mixed numbers and letters(ex.
AA12CC45WR) and they are random.
On another sheet, I have a table which has the equivalent for each letter like (cells
A=1 C=25 W=66 R=77
for the ABC letters until Z
The solution should be
How do I generate a function to replace all the letters with the defined numbers in the other sheet?