View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Combining Digits

I'm wondering if there is a function that will simplify adding each
individual digit in a number string. Here's an example:
Input 123 --- formula 1 + 2 + 3 --- result 6

I could parse the number using left, right and mid functions but I'm
wondering if there is any easier approach.

Thanks for the ideas.

- John