Remove Extra Spaces Between Data in Excel
When text data is imported or copied into an Excel spreadsheet extra spaces can sometimes be included along with the text data.
The TRIM function can be used to remove the extra spaces from between words or other strings in Excel.
= TRIM ( Text )