Skip to main content

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)