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?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
false
false