Try this UDF (User Defined function). From workbook launch VBE using Alt+F11.
From menu Insert a Module and paste the below function.Close and get back to
workbook and try the below formula.

=EquateFormula(A1)

Function EquateFormula(strData As String) As Long
EquateFormula = Application.Evaluate("=" & strData)
End Function

If this post helps click Yes
---------------
Jacob Skaria


"Rechie" wrote:

I have column in a sheet that contains below:
8+4+8
8+4+4
4+8+4
4+8+2
Equation might be text as I exported this from other application.
I have to insert = sign at the start of the equation to calculate. e.g =8+4+8
and press enter to get the results of 20. How can I get the results in a
quicker way? I have thousand lines in the file.
Thanks