RIGHT function

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.

Examples

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