Description
Obtains a specified number of characters from the end of a string.
Syntax
Right ( string, n )
Argument |
Description |
---|---|
string |
The string from which you want characters returned |
n |
A long whose value is the number of characters you want returned from the right end of string |
Return value
String. Returns the rightmost n characters in string if it succeeds and the empty string ("") if an error occurs.
If n is greater than or equal to the length of the string, Right returns the entire string. It does not add spaces to make the return value's length equal to n.
Examples
This expression returns HILL:
Right("CASTLE HILL", 4)
This expression returns CASTLE HILL:
Right("CASTLE HILL", 75)
See also