Your Programming and Traning Professionals

Right VBA Function in Microsoft Excel


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


Left(ExampleString, length)

Example:

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

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