Removes leading, trailing, and repeated spaces in text.
Sample Usage
TRIM(" First Quarter GDP growth ")
TRIM(C5)
Syntax
TRIM(text)
- text - The text from which the additional spaces are to be removed.
Examples
TRIM(" First Quarter GDP growth ") returns the text string without the extra spaces.Roman number
TRIM(C5) removes leading, trailing and additional spaces from the text in C5.
Notes
- TRIM removes all spaces in a text string, leaving just a single space between words.
- Whitespace or non-breaking space will not be trimmed.