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

Or you can choose Edit in Formula Bar. By clicking this option, Excel places the formula into editing mode in the formula bar, allowing you to make direct adjustments.