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

The SUBSTITUTE function in Excel is used to replace a particular text with another text. Here, we will show you how to use the SUBSTITUTE function to remove dashes in Excel.

Excel's Trim function will remove all but one space between words; however, it cannot remove non-breaking spaces – this requires a combination Excel's Substitute and Trim functions.