TRIM function

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 TRIM when text is used in formulas or data validation because spaces in front of or after the text are significant.

  • TRIM removes 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.

Examples

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
35
false
false