Without the need to use SHIFT+CTRL+ENTER,
=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"DMG" wrote in message
...
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