=SUM(VALUE(MID(A1,ROW($A$1:OFFSET($A$1,LEN(A1)-1,0)),1)))
This works perfectly for numbers in the cell. We can copy paste and get the result. Thanks.
=SUM(VALUE(MID(A1,ROW($A$1:OFFSET($A$1,LEN(A1)-1,0)),1)))
This works perfectly for numbers in the cell. We can copy paste and get the result. Thanks.
Last edited by Chandrasekhar Dash; 10-23-2013 at 11:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks