Learn how to remove formula in Excel and keep the text. Use Paste Special option to delete formulas without removing values in Excel.

The Microsoft Excel Status Bar is now more advanced than before with the new ability to copy and paste values.

To lock these numeric values, you need to delete the formula without deleting the calculated results. This is accomplished using Excel's copy and paste feature.