convert each letter(text) to number

  • Thread starter Thread starter Joy
  • Start date Start date
J

Joy

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
 
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
Click to expand...

Yes it is possible.

How do you determine the value of each letter? From your example, it seems to
be a random assignment.
--ron
 
Try this array formula

=SUM(N(CHOOSE(MATCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),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
 
Back
Top