You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), ... The TRIM() function is a text function in Excel that is used to fix irregular spacing.

It's easy to remove all whitespace from a string, but you'll typically want to keep a single space between words. Excel's Trim function will remove all but one space between words; however, it ...

Look for extra spaces in your values' cells. If your duplicate values have extra spaces in their cells, those spaces will also cause the Remove Duplicates tool to consider them to be unique values.

Remove extra spaces using TRIM If you dont want to use the Find and Replace tool, explore the TRIM function in Excel to get the job done. Create a new column next to the one with extra spaces.