May 1, 2013

Execute Excel formula without using equal operator

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

No comments:

Post a Comment