Perform basic operations basen on a cell

[georgiboy]

If you are using an older version of Excel then you could use a small UDF:

Function CalcTextFormula(v1 As String, op As String, v2 As String)
    CalcTextFormula = Evaluate(v1 & op & v2)
End Function

Used in the spreadsheet like:

=CalcTextFormula(A1,B1,C1)