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
|