I've been trying this for a while without success.
I'm trying to assign the numbers 1-9 to letters of the alphabet A-Z (A=1 B=2 C=3 D=4 E=5 F=6 G=7 H=8 I=9 J=1 K=2 L=3 etc.)
I want to be able to type a word and have the numbers corresponding to each letter show up, e.g. AND would be 154, FALL would be 6133.
In another cell I want to be able to sum up the digits of the number, e.g. AND would be 1+5+4 = 10. FALL = 6+1+3+3 = 13.