Extract a substring from a string, starting from the right-most character.
Syntax
Right(string, NumberOfCharacters)
Key
string A string or string expression.
NumberOfCharacters The Number of characters to return
The Right() function may be used in VBA or in an SQL query.
Examples
Dim strDemo as String
strDemo = Right("The world is everlasting", 9 )
Msgbox strDemo
Returns "The world"
“Begin at the beginning, the King said, very gravely, and go on till you come to the end: then stop” ~ Lewis Carroll
Related:
Left - Extract a substring from a string
Mid - Extract a substring from a string
© Copyright SS64.com 1999-2013
Some rights reserved