Numeric values to the alphabet

Question

I want to give the alphabet numeric numbers i.e. a=1, b=2,  and have a formula so when I type in any word it will add up its value. Please help!!.

Answer 1

That is pretty hard to do with a single formula. Your best bet is to build a table of the values that you want for each letter. Then use a formula to separate the word into single characters per cell (look at the MID function). then do a look up of the cell into the table you created (look at the VLOOKUP function). And, finally sum the total.

Answer 2

The technique will work perfectly if there are numbers and/or symbols. just add them to the table and change the lookup formula to span the entire table range.

Don't forget that I am not into any of this I just have this problem whereby I need to change alpha to numeric. Where do I begin to add this information? How do I set up the tables to which you refer?

Bear in mind that the letters of the alphabet do not run 1 - 26 as this number is divided by 9; being 1 to 9 on my system.

I do hope you are able to help and guide my through this maze

Thanks for your interest

Gordon

Answer 3

Also the programme required is to be able to type in an alpha name and the outcome will be a single digit number

Answer 4

Your requirements are completely conflicting. If you assign a numeric value to each letter, you said you wanted to sum the assigned values of the letter. How can this result i a single digit? I already explained how to do this in a prior post. If that is not what you want, please provide an example, of what someone would type and the numeric result expected.

Answer 5

Hi Bob

The basis of this is using 1 to 9 and the letters of the alphabet are assigned a number which when a word is used a basic number will be generated. The values are as follows:

1  -  2  -  3  -  4  -  5  -  6  - 7  - 8  - 9
A    B     C     D    E     F    G   H    I
J     K     L     M   N     O    P   Q    R
S    T     U     V   W     X    Y   Z    -

If you check the above the word BAT will equal 5

Also to take into account amounts that pass 10 ie  RAP would equal 17 = 8

Thus the programme must carry out the necessary mathematics to reduce the additions

for each of the various letter values.

There you have it – or not!!!

regards,

Gordon.