Excel: Convert A Calculated Result To A Value
Sometimes, you may need to replace a formula with its results - either to preserve a static value or to optimize your sheet by reducing calculations. There’s a pretty simple trick for this, but a word of warning: Be sure you really want to wipe out a formula before you do it. (There could be undesirable consequences.)
In fact, a good practice is to create a backup copy of the workbook as a safety net in case things go awry.
To convert a formula, click in its cell and press [F2] to enable in-cell editing. Next, press [F9] to calculate the formula and display its results. Then, hit [Enter], and your formula will be replaced by the value it produced.
You can also copy the formula and use Paste Special | Values to paste the results someplace else, leaving the formula intact in its original location.