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.
Syntax
=RIGHT (text, [num_chars])
Arguments
- 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.
Example:
In the example below, we extract the state code “OR” (Oregon) from the string “Portland, OR”
=RIGHT("Portland, OR",2) // returns "OR"