assign number value to text

2

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!
 
C

Carlos

Use the code function:

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