RIGHT
Returns a set number of characters from the end of a text value.
Syntax
RIGHT(text, [num_chars])
Text Functions.
A worked example
=RIGHT(A2,4)
Returns Bell
Takes the last four characters of Marcus Bell — which only works because that surname happens to be four letters long.
Where it goes wrong
Like LEFT, a fixed count only works when every value is the same shape. Pair it with LEN and FIND for variable-length text.