To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

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.

Install the Remove Duplicates add-on from the Google Workspace Marketplace. In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques.