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

How to Add Space Between Columns in Excel. Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data ...