The RIGHT function returns the specified number of characters from the end of a text string. When used with a number, the function returns the result as text.
RIGHT(text, num_chars)
text: The text string that contains the characters to extract.num_chars: The number of characters to extract from the end of the text.Returns the specified number of characters from the right side of the text string.
RIGHT("Region-East", 4)
Returns East.