Home » questions » excel experts?

excel experts?

2006-07-29 10:43:13, Category: Programming & Design
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...

Answers

  1. Web-designer ©

    On 2006-07-29 10:48:03


    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
  2. wbriii13

    On 2006-07-29 10:58:22


    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
  3. sellis_sellis

    On 2006-07-29 12:08:53


    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