Execute string

[Alexey Zalivin]

Hello,

Please advise me how I can receive in cell the result of the string in
other cell, for example:

A1 A2
5*2 10

Thank you and best regards,
Alexey.

 

[J.E. McGimpsey]

One way, using a UDF:

Public Function Eval(rCell As Range) As Variant
Eval = Evaluate(rCell.Text)
End Function

A2: =Eval(A1)

If you're unfamiliar with UDFs, see David McRitchie's page:

http://www.mvps.org/dmcritchie/excel/getstarted.htm