TRIM function - Excel

Remove all spaces from text except for single spaces between words in Excel 2003. ... Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.

office.microsoft.com