Remove Formulas in Excel (and Keep the Data)
- Select the cells in column C that have the formula.
- Right-click on any of the selected cells and click on Copy (or use Control + C)
- Again click on any cell in the selection and right-click.
- Click on the Paste Special option. ...
- In the 'Paste Special' dialog box, select 'Values'
- Click OK.