I have a list of quantites in one cell "D4"
"D4" = 6/6 3/2.6 5/1.2.
I need to sum each of these to a total so I use the following formula
=SUBSTITUTE(SUBSTITUTE(TRIM(D4),"/","*")," ","+")
Result: "6*6+3*2.6+5*1.2"
How can I convert the result to a formula that would show the sum 49.8

Thanks for any help.