Excel Left VBA Function

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)


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.