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”.

Examples

=RIGHT(“one two three”, 2) returns “ee”.

=RIGHT(“abc”) returns “c”.

=RIGHT(606, 2) returns “06”.