Excel Experts?
I want to create a numerical value for a letter in a cell. when I type A in the cell I want the function to look at the alphabetical numerical value and return that number (1) to the cell below that cell with the letter. B returning 2 above the B...C returning 3 above the cell with C...D returning 4 above D...E returning 5 below that cell etc...
Use =CODE(UPPER(A1))-64 to get values from 1-26 for the roman alphabet. You can leave out UPPER() but its best to keep it if you don't know if the input will be upper or lower case.
You can replace the cell reference (A1) with any cell or enter an actual letter, for example to get the value for E (5) you would enter:
=CODE(UPPER("e"))-64
You can replace the cell reference (A1) with any cell or enter an actual letter, for example to get the value for E (5) you would enter:
=CODE(UPPER("e"))-64
Try to visit this websties for nice and best help...:::
http://www.mrexcel.com
Thats the best website...you can get any help from....the INTERNET
enjoy...and have a nice day...
BYe
http://www.mrexcel.com
Thats the best website...you can get any help from....the INTERNET
enjoy...and have a nice day...
BYe
Try this,
=CODE("A")
This will return the numerical value of A.
You will have to figure out the details to perform what you want.
Good Luck
=CODE("A")
This will return the numerical value of A.
You will have to figure out the details to perform what you want.
Good Luck
Use =CODE(UPPER(A1))-64 to get values from 1-26 for the roman alphabet. You can leave out UPPER() but its best to keep it if you don't know if the input will be upper or lower case.
You can replace the cell reference (A1) with any cell or enter an actual letter, for example to get the value for E (5) you would enter:
=CODE(UPPER("e"))-64
You can replace the cell reference (A1) with any cell or enter an actual letter, for example to get the value for E (5) you would enter:
=CODE(UPPER("e"))-64