If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
convert each letter(text) to number
I need to calculate text for each letter, it is possible
for using for numerlogy name calculation. for expl: Joy +1+7+1=9 j -1 o-7 y-1 |
#2
|
|||
|
|||
convert each letter(text) to number
On Thu, 12 Nov 2009 03:28:02 -0800, Joy wrote:
I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1=9 j -1 o-7 y-1 Yes it is possible. How do you determine the value of each letter? From your example, it seems to be a random assignment. --ron |
#3
|
|||
|
|||
convert each letter(text) to number
Try this array formula
=SUM(N(CHOOSE(MATCH(MID(A1,ROW(INDIRECT("1:"&LEN(A 1))),1),{"a","b","c","d","e","f","g","h","I","j"," o","y"},0),1,1,1,2,3,4,5,6,7,1,7,1))) You will need to add the other letters and the correct values -- __________________________________ HTH Bob "Joy" wrote in message ... I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1=9 j -1 o-7 y-1 |
Thread Tools | |
Display Modes | |
|
|