text to column
Chip's code returns each digit to a separate cell as a number.
Simply SUM the range.
Or..........if you want to leave all the digits in one cell like 5445655
Use this formula =SUMPRODUCT(--MID($A$1,ROW(INDIRECT("1:" & LEN($A$1))),1))
which returns 34
Gord Dibben MS Excel MVP
On Mon, 8 Dec 2008 12:13:01 -0800, ChewinFoil
wrote:
So now that I understand the MID function is there any way to use the
individually displayed characters as numbers. Since the function is just
displaying the character in that position is there any way to use the actual
value? For example from my original question could the 5 4 4 5 6 5 5 now be
added to equal 34. Thanks.
|