What is TRIM?
Removes extra spaces from text, leaving only single spaces between words. Essential for cleaning imported or user-entered data.
Syntax
=TRIM(text)
Example
Formula: =TRIM(A1)
Result: Clean Text
How It Works
Removes leading, trailing, and duplicate internal spaces. If A1 contains ' Clean Text ', result is 'Clean Text'. Does not remove non-breaking spaces.