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 `+2+5`

or `+10+5+7+1+8`

.

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.

**Update**

Through this formula:
`=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D25,"E",""),"_",""),"S","=",1),"S","+")`

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!