Hi everyone!
I would like to know how to convert a word in into a number. For example: I assign the number 1 to the letter "A", the number 5 to the letter "B", the number 2 to the letter "C", and so on... so that if I write "ABC", I get in turn the sum of the three number (ABC = 1 + 5+ 2 = 8).
Thank you in advance for the answers!
Please tryAfter the 2 you can add more values for the remaining 23 letters of the alphabeth.Formula:
Please Login or Register to view this content.
Thank you!!!
Or:
=sum(lookup(mid(b4,sequence(len(b4)),1),h1:h4,i1:i4))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I'm glad tyo have helped and thanks for the feedback.
Please considder adding reputututation to answers of any helpers you think they deserve it.
Thank you Glenn!
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks