Trim

Remove leading and trailing spaces from a string.

Syntax
      Trim(string)

Key
   string    A text string or string expression.

The Trim() function may be used in VBA or in an SQL query.

Examples

Dim strDemo as String
strDemo = Trim("   The world is everlasting  ")
Returns "The world is everlasting"

“The hands of every clock are shears, trimming us away scrap by scrap, and every time piece with a digital readout blinks us towards implosion” ~ Dean Koontz

Related:

LTrim - Remove leading spaces from a string.
RTrim Remove trailing spaces from a string.


© Copyright SS64.com 1999-2013
Some rights reserved