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:

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