What is the use of RIGHT Function in Excel?

The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. For example, RIGHT(“apple”,3) returns “ple”.

  • Purpose: Extract text from the right of a string
  • Return value: One or more characters.


=RIGHT (text, [num_chars])


  • text - The text from which to extract characters on the right.
  • num_chars - [optional] The number of characters to extract, starting on the right. Optional, default = 1.


In the example below, we extract the state code “OR” (Oregon) from the string “Portland, OR”

=RIGHT("Portland, OR",2) // returns "OR"