Convert text to formula

[pham thau]

Dear Mr Excel,

Could you please advise how to convert the following text to formula:-

(300 lim L * 7.5 lim W * 0.5 lim D * 2.5 ton per cum) / 500 ton per hr + (10 hr - 8 hr) allow for standby time


Thanks in advance,

Kind regards,

Pham Thau

 

[shg]

Just take out the extraneous stuff:

= 300 * 7.5 * 0.5 * 2.5 / 500 + 10 - 8

 

[pham thau]

Dear shg,

Please advise if there are any ways or formula that Excel can automatic convert that text to formula & calculate the result.

Regards,

Pham Thau

 

[pgc01]

Hi
Welcome to the board

Not with a formula, you have to use vba.

If it's like in your example it seems very simple, just delete all the letters and evaluate the expression.