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.
[L | R]Trim[$](stringexpr)
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; LTrim$, RTrim$, and Trim$ each return a String.
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..