Exceljet

Quick, clean, and to the point

Excel RIGHT Function

Excel RIGHT function
Summary 

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.
Version 
Usage notes 

The RIGHT function extracts a given number of characters from the right side of a supplied text string. The second argument, called num_chars, controls the number of characters to extract. If num_chars is not provided, it defaults to 1. If num_chars is greater than the number of characters available, RIGHT returns the entire text string.

Use the LEFT function when you want to extract text starting from the left, and the MID function to extract from the middle of a text string.

The RIGHT function is commonly combined with other functions like LEN and FIND to extract text in more complex scenarios.

Examples

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

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

If the optional argument num_chars is not provided, it defaults to 1:

=RIGHT("ABC") // returns "C"

Notes

  • num_chars is optional and defaults to 1.
  • RIGHT will extract digits from numbers as well as text.
  • Number formatting is not counted or extracted.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas