RIGHT

See also A-Z Spreadsheet Function List

Description Returns the rightmost characters from the given text string.

Syntax RIGHT(text [, num_chars])

text is any text string.

num_chars is the number of characters to return. The value must be greater than or equal to zero. If num_chars is greater than the number of characters in text, the entire string is returned. Omitting this argument assumes a value of 1.

See Also LEFT and MID functions

Examples RIGHT(“2nd Quarter”) returns “r”

         RIGHT(“2nd Quarter”, 7) returns “Quarter”