TRIM

  • Updated

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.