There are mainly two ways to remove the formula in Excel and keep the text. No matter how many formulas you have used in your spreadsheet, you can delete or hide them without removing the values.

you're not locked into keeping that text or the highlight in your spreadsheet. Excel gives you options to delete just the text, just the highlight or the text and the highlight. Start Excel.

Let’s check these options one by one. The steps for these options are the same for Word and Excel. It’s the simplest way to delete a text box while keeping its text. First, copy the text ...

Microsoft Excel 2010 ... specified text. Once you set up your VBA code correctly, all you have to do is press a button and all the targeted rows will be deleted. How to Remove the Decimal When ...