| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing characters in a string
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
| select a string of characters | Excel Worksheet Functions | |||
| trim a string by specific number of characters | Excel Discussion (Misc queries) | |||
| Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
