RIGHT

Returns the specified number of characters from the end of a text string.

Syntax

RIGHT(text, num_chars)

Arguments

• text: The text string from which to extract characters.
• num_chars: The number of characters to extract from the right.

Example

RIGHT("AnyDB", 2) → Returns "DB"
RIGHT(A1, 3) → Returns the last 3 characters of the text in cell A1