I have a single cell that contains the text entry:
"1,4,6,7"
I want to know a formula (I'd prefer to not use a macro, although obviously a macro could solve this fairly easily) that will SUM the numbers in a cell to give a result in another cell - for example the result of the above is 1+4+6+7=18.
Can anyone think of a neat trick to accomplish this?
Much appreciated
"1,4,6,7"
I want to know a formula (I'd prefer to not use a macro, although obviously a macro could solve this fairly easily) that will SUM the numbers in a cell to give a result in another cell - for example the result of the above is 1+4+6+7=18.
Can anyone think of a neat trick to accomplish this?
Much appreciated