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

You can use Replace to remove a space from the cells in a row or column if they contain no spaces you want to preserve. Restrict Replace to your selected cell range by using the Replace options.

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.

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.

One obvious way to clean up data in Excel is to use the Find and Replace function, but Excel does a whole lot more.

Finding and removing blank spaces and rows in Excel is easy and can be done by using the "Find & Select" feature. Here's how to delete blank rows in Excel on a Mac or PC.