TRIM()

Text with extraneous spaces removed

Returns the specified value with leading and trailing spaces removed and each interior multi-space reduced to only a singe space.

Sample usage

TRIM(" Hi there!") : Hi there!

TRIM("Hi there! ") : Hi there!

TRIM("Hi there!") : Hi there!

Syntax

TRIM(value)

• value - Value of any type.

See also

INITIALS()

LEFT()

LOWER()

MID()

RIGHT()

SUBSTITUTE()

UPPER()