assign number value to text

[2fast]

hi, i want to know if is possible to asign a number value to a letter,

for example, if i want to make A to have a value 4 (A=4). so when
write the letter E, it gives a 5 number value, so i can sum all letter


A=4
B=3
C=2

A B A = 11
(4)+(3)+(4) = 11

Thanks for all your help!

 

[Carlos]

Use the code function:

=CODE("A")-64 returns 1
=CODE("B")-64 returns 2
:
=CODE("Z")-64 returns 26