Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).

Public Shared Function LTrim(ByVal Str As String) As String
Public Shared Function RTrim(ByVal Str As String) As String
Public Shared Function Trim(ByVal Str As String) As String

Parameter

Str

Required. Any valid String expression.

Example

This example uses the LTrim function to strip leading spaces and the RTrim function to strip trailing spaces from a string variable. It uses the Trim function to strip both types of spaces.

Dim MyString, TrimString As String
MyString = "  <-Trim->  "   ' Initializes string.
TrimString = LTrim(MyString)   ' TrimString = "<-Trim->  ".
TrimString = RTrim(MyString)   ' TrimString = "  <-Trim->".
TrimString = LTrim(RTrim(MyString))   ' TrimString = "<-Trim->".
' Using the Trim function alone achieves the same result.
TrimString = Trim(MyString)   ' TrimString = "<-Trim->".

See Also

Left Function | Right Function