RIGHT

The RIGHT function returns a specified number of characters from the end of a text string.

Syntax

=RIGHT(text, [num_chars])

Parameters

• text: The text string from which you want to extract characters
• num_chars: Optional. The number of characters to extract (default is 1)

Examples

=RIGHT("Hello World", 5) // Returns "World"
=RIGHT("Excel", 2) // Returns "el"
=RIGHT("A") // Returns "A" (default 1 character)