TRIM

Description

TRIM removes all spaces from text except single spaces between words.

Syntax

TRIM ( text )

 

Parameter

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 ")

Also, see

CLEAN

MID

REPLACE

SUBSTITUTE