RIGHT

Returns a specified number of characters from the end (right) of a text

Usage

RIGHT(text, num_chars)

Parameters

text

(Required) The text from which to extract characters.

num_chars

(Required) The number of characters to extract from the right of the text.

Examples

Example With these variables Result

RIGHT(“Anna Logwatch”, 8)

(None)

“Logwatch”

RIGHT(name, 5)

name is "Anna Logwatch"

“watch”

RIGHT(name, 50)

name is "Anna Logwatch"

“Anna Logwatch”

More information

The RIGHT function extracts characters from the end (right) of the text up the num_chars limit.

If num_chars is greater than the length of the text, the entire text is returned.

See also