RTrim

Returns a String containing a copy of a specified string without trailing spaces.

Syntax: RTrim$( string ), RTrim( string )

string

required Any valid string expression. If string contains Null, Null is returned.

The $-suffixed form returns a String; the unsuffixed form returns a Variant (String).

Example

This example uses the RTrim function to strip trailing spaces from a string variable.

Dim MyString, TrimString
MyString = "  <-Trim->  "         ' Initialize string.
TrimString = RTrim(MyString)      ' TrimString = "  <-Trim->".

See Also

• LTrim, Trim functions

_{License: CC-BY-4.0 Code license: MIT Attribution: VBA-Docs}