TRIM Function

It is a TEXT function
It removes the black spaces to the text at both ends of the text
It eliminates the spaces between words., except one space between word to word
It retains only one space between one word to another, in a cell

Functional Arguments:

Example:

Download The Workbook

Example:

Download The Workbook