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
"Medha" <Medha[ at ]discussions.microsoft.com> wrote in message
news:2D46FEA6-F16F-46CE-97BB-BB67F2C3D1B6[ at ]microsoft.com...
[Quoted Text] > if i want to make sum of numbers which are within one cell how it is
possible ?
> Weather it is possible or not?
|