Trim, Trim$ Functions

---

Named Arguments

No

Syntax

Trim(string)

string

Use: Required

Data Type: String

Any string expression.

Return Value

A String (Trim$) or Variant of subtype String (Trim).

Description

Removes both leading and trailing spaces from a given string.

Rules at a Glance

If string is Null, the Trim function returns Null.

Programming Tips and Gotchas

Trim combines into a single function call what would otherwise be separate calls to the RTrim and LTrim functions.

See Also

LTrim Function, RTrim Function