Use Clear Formats in “Editing” To clear formatting in your Excel sheet, navigate to the Home tab, locate the Editing group, and click on “Clear”.

When you download an Excel file from the internet, the table format may not match your data table creation requirements. If so, you can remove the table format in Excel.

You might need to clear all the cells' formats so that they can be interpreted as plain text. Here we tell you how to quickly clear any batch of cells depending on your needs.

2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

How to Remove All Spaces in Excel With the Replace Feature There might be instances where you want to remove all spaces from your data, including those between words.