Removes leading, trailing, and repeated spaces in text.
Sample Usage
TRIM(" lorem ipsum")
TRIM(A2)
Syntax
TRIM(text)
text- The string or reference to a cell containing a string to be trimmed.
Notes
- Google Sheets trims text input into cells by default.
- It is important to use
TRIMwhen text is used in formulas or data validation because spaces in front of or after the text are significant. TRIMremoves all spaces in a text string, leaving just a single space between words.- Whitespace or non-breaking space will not be trimmed.
See Also
SUBSTITUTE: Replaces existing text with new text in a string.
REPLACE: Replaces part of a text string with a different text string.