Hello again,
I have assigned a numeric value to each letter of the alphabet, A=1, B=2, C=3, D=4, etc.
I have a string of characters in cell A1, let's say "ABCD". In cell B1, I'd need a function that can substitute each of the individual characters in the string (not case sensitive, i.e. a=1 and A=1) into their respective numbers, and then add each of the numbers.
So in this example, my string in A1 being ABCD, the result in B1 would be 10 (i.e. 1+2+3+4). If my string in A1 was AAAA, the result in B1 would be 4 (1+1+1+1).
Is that in any way possible? I've searched google for hours, and I've racked my brain for a solution, but I can't seem to find one.
Thanks for your insight
Bookmarks