| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Probablility calculation related to start date | Excel Discussion (Misc queries) | |||
| How can I add a + sign to a positive result of a calculation? | Excel Discussion (Misc queries) | |||
| random start and calculation | Excel Worksheet Functions | |||
| Having to key the equal sign to start a formula | Excel Worksheet Functions | |||
| equaton with #'s Y and N | Excel Discussion (Misc queries) | |||
Linear Mode
