TRIM

Removes all spaces from a text string except for single spaces between words.

Syntax

TRIM(string)

Arguments

Argument	Description	Required
string	The text from which you want to remove spaces.	Required

Examples

Remove leading and trailing spaces

Remove extra spaces between words

Clean up cell text

Related Functions

Other Text functions:

• CLEAN - Removes all nonprintable characters from text
• CONCATENATE - Returns the concatenation of a list of arguments.
• ENDSWITH - Returns TRUE if the text ends with search text, returns FALSE otherwise.
• EXACT - Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise
• FIND - Returns the position of the first occurrence from within_text.
• FIXED - Formats a number as text with a fixed number of decimals
• LEFT - Returns a substring from the left side of a supplied string.
• LEN - Returns the length of a given string.
• LOWER - Returns a string after converting it to lowercase
• MID - Returns a substring from the middle of a given string.
• PROPER - Capitalizes the first letter in each word of a text value
• REGEXMATCH - Returns true if the text matches the regular expression pattern; otherwise returns false.
• REPLACE - Replaces part of a text string with a different text string
• REPT - Repeats text a given number of times
• RIGHT - Returns a substring from the right side of a given string.
• SEARCH - Returns the start position of the find_text string from the first character of the text string.
• STARTSWITH - Returns TRUE if the text starts with search text, returns FALSE otherwise.
• SUBSTITUTE - Returns the text after replacing one or more text strings with another text string
• TEXTJOIN - Returns the combination of two or more one-dimensional arrays with or without a delimiter.
• UPPER - Returns the string after converting all letters to uppercase
• VALUE - Returns a numeric value for a text that appears in a recognized format (i.e. a number, date, or time format).

---

← Back to Formula Reference