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