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
---------------
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

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

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 <Rec...@discussions.microsoft.com> 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