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 spaces 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