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.