Excel: LTrim Function (VBA only)

In Excel, the LTrim function removes leading spaces from a string.

The syntax for the LTrim function is:

LTrim( text )

text is the string that you wish to remove leading spaces from.

Applies To:

For example:

LTrim(" Tech on the Net") would return "Tech on the Net"

LTrim(" Alphabet ") would return "Alphabet "

VBA Code

The LTrim function can only be used in VBA code. For example:

Dim LResult As String

LResult = LTrim(" Alphabet ")

The variable LResult would now contain the value of "Alphabet ".