One way would be to do Data TextToColumns Fixed, and split each digit out
into it's own column and then just summing horizontally......

Vaya con Dios,
Chuck, CABGx3



"John Michl" wrote:

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