Call

Left VBA Function in Microsoft Excel


The Excel Left VBA function returns a set of characters to the left of a character number that you specify.

Left(ExampleString, length)

Example:

Dim ExampleString As String
ExampleString = “ExcelHelp”
Getit = Left(ExampleString, 3)

The Getit variable would return “Exc” from ExcelHelp since since “Exc” are the left 3 characters in the string.