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,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!