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

Check the formula, which appears in the formula bar just above the spreadsheet, for any obvious circular references like if the formula is trying to reference the cell it is currently sitting in.