For your convenience, you can replace a formula or a part of a formula in a cell with its result. Simply follow the steps below:
1.Select the formula or a part of a formula directly in the cell or in the Formula bar. A pop-up tooltip with the calculated value will appear above the selected part of the formula or above the formula itself.
2.Click the F9 key to replace the selected part of the formula or the entire formula with its value.