RIGHT

RIGHT returns the last characters in a text string, based on the number of characters you specify.

Syntax

RIGHT(text,num_chars)

Text    is the text string containing the characters you want to extract.

Num_chars    specifies the number of characters you want RIGHT to extract.

Remarks

• Num_chars must be greater than or equal to zero.
• If num_chars is greater than the length of text, RIGHT returns all of text.
• If num_chars is omitted, it is assumed to be 1.

Example

Formula	Description (Result)
=RIGHT("Sale Price",5)	Last 5 characters of the string (Price)
=RIGHT("Stock Number")	Last character of the string (r)