Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

RIGHT

Description: RIGHT returns the last character or characters in a text string.

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 0.

• 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:

• RIGHT("Sale Price", 5) = Price [the last 5 characters of the string]

• RIGHT("Stock Number") = r [the last character of the string]