When you have a formula that you want to replace with a permanent value you can do this easily by clicking in the cell containing the formula. Click at the end of the formula in the Formula Bar and press F9. This converts the formula to a calculated value. Now press Enter to enter the result into the cell.
