Thread
:
summing characters in a string
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
DMG
Posts: n/a
summing characters in a string
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
Reply With Quote