TRIM

Removes leading and trailing spaces from text.

Examples

• TRIM(” The first go. ”) - Returns “The first go.” without leading and trailing spaces.
• TRIM(C5) - Returns the text in cell C5 without leading and trailing spaces.