Removes leading, trailing, and repeated spaces in text.
TRIM(" First Quarter GDP growth ")
- text - The text from which the additional spaces are to be removed.
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.
- TRIM removes all spaces in a text string, leaving just a single space between words.
- Whitespace or non-breaking space will not be trimmed.