Excel Left VBA Function

Excel Left VBA Function

 

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.




 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)