I want to turn letters into numbers (A=1, B=2, C=3, ..., Z=26) and calculate the sum. For example in cell A1 is the word icecream , cell B1 should then display 57
(i=9 + c=3 + e=5 +c=3 + r=18 + e=5 + a=1 + m=13 = 57)
There are online calculators, but I would like to calculate that with Excel (Office 2013), I also found several explanations for German excel, but none for English Excel.
Thanks!
Martina
Bookmarks