View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sai Krishna[_2_] Sai Krishna[_2_] is offline
external usenet poster
 
Posts: 29
Default 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