total value of letters from words in cells

[teacher2013]

Hello,

Using 1-26 and the alphabet I would like to be able to total the sum of letters from lists of words.

so using 1-26 with A to Z
a = 1
b = 2
c = 3
d = 4
.....



Example:

the word cat = 3+1+20 = 24
dog = 4+15+7 = 26



would appreciate any assistance.

best regards,
Rob



PS I can do this if I split the words into different cells but this is a pain

[dilipandey]

Hi teacher2013,

welcome to the forum.

See the attached file and let me know if this helps:-
total value of letters.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[teacher2013]

Thank you very much. That is exactly what I want.

[dilipandey]

You are welcome...

Please mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>