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

How to Delete Functions in Excel. Excel uses the Visual Basic for Applications (VBA) language to generate functions used within the spreadsheet.

Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete. Click the "Formulas" tab and click "Name Manager" in the Defined Names group.