Sum within one cell

M

Medha

if i want to make sum of numbers which are within one cell how it is possible ?
Weather it is possible or not?
 
P

Paul B

With numbers like 123456 in one cell? If that is what you want try this, for
numbers on A1

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top