This is often because Excel's Remove Duplicates tool may consider two duplicate values to actually be unique values instead, usually because of some underlying difference in formatting or another ...

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.

Formatting cells that aren't used can grow your workbook's file size. See how to reset the last cell on an Excel File to remove formatting.

How to clear formatting in Excel? Select all the cells you need (Press Ctrl + A to select all the cells). On the Home tab, in the Editing group, click the arrow next to the Clear button, and then do ...

One formatting flaw is caused by Tab symbols, which are not visible, although the unwanted spaces in your spreadsheet caused by these characters are readily apparent.

How to Remove CSV Formatting From a File. Files containing comma separated values (CSV) files are useful for storing data from disparate sources or from your relational database management system.