Dear Smartest Excelers In The World,
If I have this data in cell B14:
01-12-13-14-15
and I use this formula:
=SUBSTITUTE(B14,"-","+")
to generate:
01+12+13+14+15
How can I SUM this string so that in one cell I get the answer 55?
Any ideas?
If I have this data in cell B14:
01-12-13-14-15
and I use this formula:
=SUBSTITUTE(B14,"-","+")
to generate:
01+12+13+14+15
How can I SUM this string so that in one cell I get the answer 55?
Any ideas?