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

Then use the SUBSTITUTE () function to replace the non-breaking space with normal space. And then use the TRIM () function to remove all spaces from both ends of the original text string.

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.

How to Remove Leading Blank Spaces in Excel. However carefully you monitor the data you enter and import into Microsoft Excel, and the output of formulas and functions that produce new values, it ...

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources.