TRIM

Description Removes all spaces from text except single spaces between words.

Syntax TRIM ( text )

Argument	Description
text	Any text string or a reference to a cell that contains a text string.

Remarks Text that is imported from another environment may require this function.

Example This function returns Level 3, Gate 45:

TRIM(" Level 3, Gate 45 ")

See Also CLEAN, MID, REPLACE, SUBSTITUTE