example: my data in A1 cell is ABCDE. I want to display it as 56789 in B1 cell. (because my codes are A=5, B=6, C=7, D=8 and E=9)
In a similar way I want a formulae that automatically converts my alphabet codes in row A into number format in row B.
Another similar example: my data in A2 cell is DACB. I want to display it as 8576 in B2 cell.
Thanks in advance,