Formulas and Functions

RIGHT
The RIGHT function returns a string value consisting of the specified number of characters from the right end of a given string value.
RIGHT(source-string, string-length)
source-string: Any value.
string-length: An optional number value specifying the desired length of the returned string. string-length must be greater than or equal to 1.
Notes
If string-length is greater than or equal to the length of source-string, the string returned is equal to source-string.
Examples |
---|
=RIGHT("one two three", 2) returns "ee". =RIGHT("abc") returns "c". =RIGHT(606, 2) returns "06". |