RIGHT
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
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
When the field Full Name has the value Johny Rivers, this will return Rivers
Excel equivalent
Last updated