RIGHT function

Category: Text functions

What does this function do?

Returns characters to the right of a string according to the number of characters specified.

Syntax:

RIGHT(text, [num_chars])

• text (required): The text string that contains the characters you want to extract
• num_chars (optional): specifies the number of characters you want to extract. It 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:

=RIGHT("Excel",2)= "el"