You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

Removing these leading spaces – or trailing spaces that fall at the end of a cell's contents – requires an Excel function.

If you wish to impart your Excel Spreadsheet a clean look, delete or remove the extra blank cells, rows, spaces, columns, from Excel sheet.

Removing these spaces can help the Remove Duplicates tool to better detect the duplicate values you want to remove. Think you know how to use Excel?