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

You can still do this exactly as I have already described. You'll just need one more step to add the multiple digits if the result is > 9.

Neither I nor anyone else here is likely to do it for you (at least not for free). That is the kind of thing many of us here do for a living. However, we are all more than willing to help you do it, and answer any questions you may have, and help with any problems.

So, there YOU have it. The solution has been described and posted in this thread. Try it and let us know what the problems are.

Answer 3

Thanks for that Bob; I will endeavour to get to the bottom of this but as I have said previously I am not into these mathematical equations but hopefully various friends of mine will be able to sort this for me.  Many thanks from a very grateful 73 year old pensioner.

You have helped considerably

kind regards,

Gordon