by Alexander Frolov, updated on
Here are good tips to save your time - 2 fastest ways to replace formulas in Excel cells with their values. Both hints work for Excel 365 - 2013.
You may have different reasons for converting formulas to values:
Suppose, you have the formula to extract domain names from URLs.
You need to replace its results with values.
Just follow the simple steps below:
That's it! If this way is still not fast enough for you, have a look at the next tip.
Have you ever had a feeling that some routine tasks in Excel that can be done in a few clicks take too much of your time? If so, you are welcome to our Ultimate Suite for Excel.
With this collection of 70+ time saving tools, you can quickly remove all blank cells, rows and columns; move columns by drag-n-dropping; count and sum by color, filter by the selected value, and much more.
With the Ultimate Suite installed in your Excel, here are the steps to get it working:
Done!
I do encourage you to explore other features of our Ultimate Suite. I can assure you that it will save 4-5 minutes on one Excel task, 5-10 minutes on another task, and by the end of the day it will save you an hour or more. How much does an hour of your work cost? :)
Table of contents