TRIM

Description

Removes all spaces from text except single spaces between words.

Syntax

TRIM ( text )

Parameter Description
text Any text string.

Remarks

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

Examples

This function returns Level 3, Gate 45:

TRIM(" Level 3, Gate 45 ")

See also

CLEAN

MID

REPLACE

SUBSTITUTE

TRIMX