View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DMG
 
Posts: n/a
Default 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