TRIM

The TRIM function in Excel is a function that removes all the spaces from a string of text and only leaves a single space between words. This function is quite useful when cleaning text that has been previously imported from another application or source, as this type of text can have a variety of formats.