View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default how do I total the value of the cell to a single value, 37=3+7=10

click the cell and type an equal sign then a number then a plus sign, like so

=5+5+4+3
cell should equal 17

--
Cheers,
Ryan


"huong" wrote:

Is there a function like substring in excel or something similar like that.
I would like to add all the digits in a cell to a single value, how would I
do that?

Thank you very much,

huong