Head to Excel Home -> Search and select Replace. Enter a typo in the Find bracket. Replace it with the correct term and click ...

Select columns from which you want to remove duplicates. Click OK. Excel displays a message showing the number of duplicate ...