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

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false