VBA Function: LTrim

Description

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

LTRIM Syntax

LTrim(text)

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