Assume your cell to use is A1, this formula will work. Enter it using
CTRL+SHIFT+ENTER as it is an array formula:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))


--
Regards,
Dave


"DMG" wrote:

Hi
Is there a way to sum the characters in a string. For example A1 contains
12345. I would like a formula to return 15 (1+2+3+4+5).
As an added twist, the string is variable length.

Thanks