Let's say I have formula result that returns this
+10+5+1+40, as text. I want to then sum the those numbers to get the total.
The result could be any number of values, so like
In case it is helpful, the original data set is something like this
S10_S5_S1_S40 or this
E_E_S2_S5. I have stripped out everything except the numbers next to S, which is what I want to add.
Lastly, I am posting on superuser as I want to avoid VBA if I can.
Through this formula:
I've gotten it down to this
=10+5+1+40, where D25 =
S10_S5_S1_S40 ... but that is really the same as having a
+ in front, I guess!