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.

with the results of one formula's calculations being fed into another. How to Delete a Row if Text Equals VBA in Excel. Microsoft Excel 2010 comes with the... How to Separate Text From Numbers in ...

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.

The SUBSTITUTE function in Excel is used to replace a particular text with another text. Here, we will show you how to use the SUBSTITUTE function to remove dashes in Excel. This method also works ...