#1   Report Post  
Posted to microsoft.public.excel.misc
Joy Joy is offline
external usenet poster
 
Posts: 29
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating text in a calculation Tim Excel Worksheet Functions 3 September 12th 08 09:21 PM
month text in calculation T. Valko Excel Worksheet Functions 2 July 23rd 08 05:41 PM
Ignore calculation if text AndyB Excel Worksheet Functions 4 November 29th 07 02:35 PM
Put in text after a calculation joel Excel Discussion (Misc queries) 2 October 16th 06 08:55 AM
Calculation within Text GeorgeF Excel Worksheet Functions 6 November 18th 05 05:23 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"