VBA Function: LTrim


The VBA LTRIM Function returns a string after removing spaces from the left of the string.

LTRIM Syntax


VBA LTrim Example

Trim spaces from the left side of a string only:

Sub LTrimExample()

     MsgBox LTrim("   test")           'Returns: "test"
     MsgBox LTrim("test   ")           'Returns: "test   "
     MsgBox LTrim("   test   ")        'Returns: "test   "
     MsgBox LTrim("   test   test   ") 'Returns: "test   test   "
End Sub
To remove spaces from the right side of the string only, use the RTRIM function.
To remove extraneous spaces from the beginning and end of the string, use the TRIM function.