4] Run a VBA code to remove formatting. You can also use VBA code to remove formatting from Excel. Once you have created the required VBA script, you just need to run it to quickly clear all the ...

Here's how you can clear the formatting of your Excel table and revert it to the default style: Click on a cell in your formatted table. Select the Table Design tab that appears on the ribbon.

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.