Summing up digits in a cell
Thanks gaurav, this has helped for two digits.
regards
krishna
"Gaurav" wrote:
If you only have 2 digits, try this
=SUM(LEFT(A2,1),RIGHT(A2,1))
"Sai Krishna" wrote in message
...
Hi,
i need to add all the digits in a cell. For example, if I have a number 58
in a cell, the adjacent cell should return a value of 13.
regards
krishna
|