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
|