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.Press Alt+F9 to replace the selected part of the formula or the entire formula with its value.