The RIGHT() function returns a specified number of characters from a string, starting from the right-hand side.
Syntax
=RIGHT(text,num_chars)
text
is a reference to the cell containing the text string.
num_chars
is the number of characters to be returned
Returns a string.