LTrim, LTrim$, RTrim, RTrim$, Trim, Trim$ Function
See Also Example
Returns a copy of a string with leading (leftmost), trailing (rightmost), or both leading and trailing spaces removed.
Syntax
[L | R]Trim[$](stringexpr)
Remarks
LTrim[$] removes leading spaces from a string; RTrim[$] removes trailing spaces. Trim[$] removes leading and trailing spaces.
LTrim, RTrim, and Trim each return a Variant
The stringexpr argument can be any string expression However, only LTrim, RTrim, and Trim can accept a Variant of VarType 1 (Null ) as stringexpr, in which case, a Null is returned.