Description
Returns the rightmost characters from a text string.
NOTES
- The number of characters to return is specified by num_chars.
If num_chars is omitted, RIGHT returns the last character of the text.
Syntax
Copied!=RIGHT(text, [num_chars])
SAMPLE-1
EXAMPLE 1.1
Copied!=RIGHT(A2:A6, 3)