Skip to main content

Posts

Showing posts with the label Execute Excel formula without using equal operator

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