Replace a formula with its result

Microsoft Office Excel 2003

Caution  When you replace a formula with its value, Microsoft Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo Button image immediately after you enter or paste the value.

  1. Select the cell that contains the formula.

    If the formula is an array formula, select the range that contains the array formula.

    ShowHow?

    1. Click a cell in the array formula.
    2. On the Edit menu, click Go To.
    3. Click Special.
    4. Click Current array.
  2. Click Copy Button image.
  3. Click Paste Button image on the Standard toolbar.
  4. Click the arrow next to Paste Options Button image, and then click Values Only.

ShowReplace part of a formula with its calculated value

Caution  When you replace part of a formula with its value, it cannot be restored.

  1. Click the cell that contains the formula.
  2. In the formula bar Formula bar, select the portion of the formula you want to replace with its calculated value. When you select the part of the formula you want to replace, make sure to include the entire operand. For example, if you select a function, you must select the entire function name, the opening parenthesis, the arguments, and the closing parenthesis.
  3. To calculate the selected portion, press F9.
  4. To replace the selected portion of the formula with its calculated value, press ENTER.

    If the formula is an array formula, press CTRL+SHIFT+ENTER.