LinkBack URL
About LinkBacks
Hi how to make when a word is typed in one cell to sum the numbers of each letter and show me the result?
For example A=1, B=2, C=3...so if i type the word 'Baby' it will give me 30, ABC = 6.
Hi how to make when a word is typed in one cell to sum the numbers of each letter and show me the result?
For example A=1, B=2, C=3...so if i type the word 'Baby' it will give me 30, ABC = 6.
Is there a maximum number of letters that can be typed into the cell? It is possible to do this with a formula but it will be a long formula, and VBA might be preferred.
Here is a formula that will work for up to 6 letters. If you have anything but letters in the string you will get odd results.
=-LEN(A1)*(CODE("A")-1)+IFERROR(CODE(MID(UPPER(A1),1,1)),0)+IFERROR(CODE(MID(UPPER(A1),2,1)),0)+IFERROR(CODE(MID(UPPER(A1),3,1)),0)+IFERROR(CODE(MID(UPPER(A1),4,1)),0)+IFERROR(CODE(MID(UPPER(A1),5,1)),0)+IFERROR(CODE(MID(UPPER(A1),6,1)),0)
Maybe if you enter words into separate cells it can be done with single formula.
Enter formula in C1 and copy down
WORDS.JPGFormula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Here is another possible scenario
1. Enter formula in cell E1 and drag formula across to cell Z1 and copy down to row 26
Formula:Please Login or Register to view this content.
2. Enter in D1 and copy down
Formula:Please Login or Register to view this content.
Select columns E:Z and hide them
WORDS_2.JPG
Thank you both very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks