Lets If You have have data in following format in Excel
1*(4+3.00)/2*3
5*(4+5.00)/2*4
1*(5.30+300)/2*4
1*(2.30+400)/2*3
1*(5.30+3.00)/2*4
1*(t.30+3.00)/2*3
You want to convert it in formula ( Result ) without entered "=" manually. how cant it possible ?
Solution:
Download and install ASAP Utilities (http://www.asap-utilities.com/)
Open your worksheet.
Select all the cells that you want to convert.
In the ASAP Utilities menu:
Go to "Text".
Click on "Insert before and/or after each cell in your selection".
Put in an = sign in the "add before:" box.
"treat cells as:" values (default)
Click on "OK".
Now, press and hold Ctrl.
Press the "H" key.
That will open the "Find and Replace" dialogue box in Excel.
(Type an = sign into both boxes.)
"Find what:" =
"Replace with:" =
Click on "Replace All".
1*(4+3.00)/2*3
5*(4+5.00)/2*4
1*(5.30+300)/2*4
1*(2.30+400)/2*3
1*(5.30+3.00)/2*4
1*(t.30+3.00)/2*3
You want to convert it in formula ( Result ) without entered "=" manually. how cant it possible ?
Solution:
Download and install ASAP Utilities (http://www.asap-utilities.com/)
Open your worksheet.
Select all the cells that you want to convert.
In the ASAP Utilities menu:
Go to "Text".
Click on "Insert before and/or after each cell in your selection".
Put in an = sign in the "add before:" box.
"treat cells as:" values (default)
Click on "OK".
Now, press and hold Ctrl.
Press the "H" key.
That will open the "Find and Replace" dialogue box in Excel.
(Type an = sign into both boxes.)
"Find what:" =
"Replace with:" =
Click on "Replace All".
Comments
Post a Comment
Please avoid link comments