Examples

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

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

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

Syntax

TRIM( some-value )

Arguments

  • some-value (of any type)

Return Value

Text: The content of some-value with leading and trailing spaces removed and each interior multi-space run reduced to only a singe space.

See Also

INITIALS(), LEFT(), LOWER(), MID(), RIGHT(), SUBSTITUTE(), UPPER()

Did this answer your question?