numerical value of a letter

G

Guest

Please help:

In one cell you may have a letter. In another cell I want to use a formula
that returns the numerical value of the letter, e.g. a=1, b=2, c=3 etc.

The formula must not reference to anyother cell except for the one
containing the letter, i.e. this means you cannot use a vlookup.

Can someone please advise? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averaging a column of letter grades into a numeric GPA 3
IF statement to check for numerical value 3
Custom Formating Letters to Numbers while Displaying Letters 2
Excel Use COUNTIF across a range of cells with formulas 0
Converting a letter grade to a numerical value 3
Array Function to do a Sum of VLookUps that translate a letter gra 3
How can you convert a text value to a numerical formula ? 16
Linking cells within workbook with ALL formating 3

Top