Hi!

You can't "build" a formula like that although it is possible to calculate
the resulting TEXT string but the formula needed to do that would be a mile
long and EXTREMELY difficult to maintain.

So, I have to ask, why are you wanting to do this? Why not put the values in
separate cells?

Biff

"Neil" wrote in message
...
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.