| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
numerical value of a letter
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. |
|
#2
|
|||
|
|||
|
=CODE(UPPER(A1))-64
-- Kind regards, Niek Otten Microsoft MVP - Excel "Graeme" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search in the entire sheet for different letter and cal. | Excel Worksheet Functions | |||
| FIRST letter of the names, mi and the whole last name. | Excel Discussion (Misc queries) | |||
| How do I add row total when cell contains both number and letter . | Excel Discussion (Misc queries) | |||
| Have A Letter Reference A Name For An Intoduction | New Users to Excel | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
Linear Mode
