Calculation by inserting = sign at the start of equaton
 

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

Calculation by inserting = sign at the start of equaton
 

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

Calculation by inserting = sign at the start of equaton
 

Thanks.... Perfectly working!!!

"Jacob Skaria" wrote:

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

Calculation by inserting = sign at the start of equaton
 

Go to Define name | name it as ABC | in refers to : =Evaluate(B2) | ok

now in you worksheet in cell C2 put =ABC.


On Nov 18, 12:53*pm, 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