An Overview of RIGHT Function | Microsoft Excel

The RIGHT function is one of the most commonly used text functions in Microsoft Excel. The  RIGHT function is usually used collaboratively with other functions to form formulas. For this reason, you need to learn the proper use of the RIGHT function. This article will give you an overview of the RIGHT function in Excel.


The RIGHT function returns a certain number of characters from the right side of a text string. For example,  =RIGHT(welcome,2) returns me which is the 2 characters from the right-most side of the string welcome.


=RIGHT(text, [num_chars])


  • text: Compulsory. The text string from which you need to extract the characters.
  • num_chars: Optional. It refers to the number of characters you want to extract from the text argument.


The RIGHT function returns a certain number of characters from the right side of a text string that is supplied to the function. For example, if you mention 5 in the function num_chars, the RIGHT function will return the 5 characters from the right-most side of the character string.

Examples of RIGHT Function

Assume you have a text string that is ABCXYZ and the text string is located in cell A2. Now you want to extract the last 3 characters from there. To do that, you can use the RIGHT function. Here is the formula using the RIGHT function:


The output will be XYZ.

Here are some examples of the usage of the RIGHT function.

Examples of the RIGHT Function in Excel

Usage Guide of RIGHT Function

Step_1: Start by inserting an equal sign (=) in a blank cell.

Step_2: Then type RIGHT.

Step_3: Type open parenthesis “(“.

As you type the open parenthesis, Excel will show the syntax of the RIGHT function.

Usage Guide of the Text Function in Excel

Step_4: Insert the text argument first.

You can directly insert the text or a cell address that contains the text.

Here, I’m inserting A2, which has the text argument.

Step_5: Then insert a comma (,).

After inserting the comma (,), Excel will ask you for the num_chars argument. The full form of num_chars is the number of characters.

Step_6: Now insert the second argument, num_chars.

You can insert the cell address of the num_chars or directly insert the num_chars.

Here, I’m inserting B2 inside the as num_chars.

Step_9: Next, insert the closing parenthesis “)”.

Step_10: Finally, hit the ENTER key to insert the formula inside the cell.

Final Result >

Here, the text is ABCXYZ and the second argument num_chars is 3. The RIGHT function starts from the right side of the text, extracts 3 characters from ABCXYZ, and finally returns XYZ.


  • Excel for Microsoft 365
  • Excel 2016
  • Excel for Microsoft 365 for Mac
  • Excel 2016 for Mac
  • Excel for the web
  • Excel 2013
  • Excel 2021
  • Excel 2010
  • Excel 2021 for Mac
  • Excel 2007
  • Excel 2019
  • Excel for Mac 2011
  • Excel 2019 for Mac
  • Excel Starter 2010


  • The RIGHT function counts the spaces as characters too.
  • It takes all punctuation marks into consideration as well.
  • If the num_chars argument is omitted, the RIGHT function returns the entire text string.
  • If the text string is empty, the output will also be empty.
  • The RIGHT function is case-sensitive, meaning that it distinguishes between uppercase and lowercase characters.
  • If the text argument is an error value (e.g., #N/A, #VALUE!), or if the num_chars argument is not a positive integer, the RIGHT function returns an error value.


The RIGHT function is one of the text functions in Excel. If you have any questions regarding the RIGHT function, please comment below. Keep exploring Microsoft Excel!

Rate this post

Leave a Reply

Your email address will not be published. Required fields are marked *