RIGHT

Returns the specified number of characters from the end (right side) of a text string and outputs the result as text.

The RIGHT function returns the last character or characters in a text string, based on the number of characters you specify. When used with a number, the resultant value is stored as text.

Syntax

right(text/number, [num_chars])

Arguments

text/number - Required. The text string containing the characters you want to extract.

num_chars - Required. Specifies the number of characters you want RIGHT to extract.

Example

right([Full Name],6)
//When the field Full Name has the value Johny Rivers, this will return Rivers

Right function

Excel equivalent

RIGHT