Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

TRIM

Description: Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.

Syntax: TRIM(Text)

• Text is the text from which you want spaces removed.

Example:

• TRIM(" First   Quarter   Earnings   ") = "First Quarter Earnings" [removes leading and trailing spaces from the text in the formula]