# Letters representing numbers

1. ## Letters representing numbers

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.  Register To Reply

2. ## Re: Letters representing numbers

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.  Register To Reply

3. ## Re: Letters representing numbers

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)  Register To Reply

4. ## Re: Letters representing numbers

Maybe if you enter words into separate cells it can be done with single formula.
Enter formula in C1 and copy down
Formula:  `Please Login or Register  to view this content.`
WORDS.JPG  Register To Reply

5. ## Re: Letters representing numbers

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  Register To Reply

6. ## Re: Letters representing numbers

Thank you both very much  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 