Replace a formula with its result

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