Removing functions from a column, but keeping data (convert to normal text)?

I have a column that contains the results of a few different formulas. I want to convert all of these cells to normal text, getting rid of the formulas.

I know I'm missing something obvious here.


Solution 1:

  1. Select the cells to convert.
  2. Copy cells (with CTRL-C).
  3. Select Edit from the menu.
  4. Select Past Special from the menu.
    • In the dialog box that opens, unselect formulas and select the desired conditions and press OK.