Assign numeric value to letters

Hi,

I am trying to assign a numeric value to letters in excel (A=1, B=2, C=3, ect) and then be able to add 5 and then have excel give me the letter that corresponds to the number. eg. A = 1. so A+5 = 6. and 6 = F. I was just wondering how or if this could be done.

Thanks in advance

Try this in A2

=CHAR(CODE("A")+ROW(A5))

Drag/Fill Down

Use
=CODE("A")

to return the Ascii value of the letter then add 5, by using Row(A5) as above we can increment the letter by 1 and add 5

Hope this helps

Place a letter in A1
this will get it's value
=CODE(LOWER(A1))-96