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:
- Select the cells to convert.
- Copy cells (with CTRL-C).
- Select Edit from the menu.
- Select Past Special from the menu.
- In the dialog box that opens, unselect formulas and select the desired conditions and press OK.