Calculation by inserting = sign at the start of equaton

  • Thread starter Thread starter Rechie
  • Start date Start date
R

Rechie

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
 
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
 
Thanks.... Perfectly working!!!

Jacob Skaria said:
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
Click to expand...
 
Go to Define name | name it as ABC | in refers to : =Evaluate(B2) | ok

now in you worksheet in cell C2 put =ABC.
 
Back
Top