ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   text calculation (https://www.excelbanter.com/excel-discussion-misc-queries/248258-text-calculation.html)

Joy

text calculation
 
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


Eduardo

text calculation
 
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


Dave Peterson

text calculation
 
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


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com