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.

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.

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)

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

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

6. Re: Letters representing numbers

Thank you both very much

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