Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi...
I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1 = 9 Sum: j -1 o-7 y-1 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
you can do text to column and split the name in different columns, then get the calculation needed based in a table with all the letters and the numbers. I have not idea how you got 1 for J and Y, if you give me some explanation I will try to help you "Joy" wrote: Hi... I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1 = 9 Sum: j -1 o-7 y-1 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
See your later post.
Joy wrote: Hi... I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1 = 9 Sum: j -1 o-7 y-1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formating text in a calculation | Excel Worksheet Functions | |||
month text in calculation | Excel Worksheet Functions | |||
Ignore calculation if text | Excel Worksheet Functions | |||
Put in text after a calculation | Excel Discussion (Misc queries) | |||
Calculation within Text | Excel Worksheet Functions |