Excel RIGHT Function

HomeExcel FunctionsExcel RIGHT Function (Example + Sample File)

What is EXCEL RIGHT FUNCTION

The Excel RIGHT Function is listed under Microsoft Excel's Text Functions category. It returns sequential characters from a string starting from the right side (ending). In simple words, with the RIGHT function, you can extract characters from a string from its left side.

How to use it

To learn how to use the RIGHT function in Excel, you need to understand its syntax and arguments: 

Syntax

RIGHT(text,num_chars)

Arguments

  • text: A text or number from which you want to extract characters.
  • [num_char]: A number of characters you want to extract.

Notes

  • You will get a #VALUE! error on using negative numbers in num_char.
  • If you skip specifying num_char, it will assume 1 as default.
  • You can’t refer to more than one cell and if you do that, it will return the characters from the top-left cell of the range.

Example

To master the RIGHT function we need to try it out in an example and below is one which you can try out:

In the below example, we have extracted 6 characters using the right function. If you know, how many characters you need to extract from the string, you can simply extract them by using a number.

Now, if you look at the below example, where we have to extract the last name from the cell, but we are not confirmed about the number of characters in the last name.

So, we are using LEN and FIND to get the name.

Let me show you how we have done this.

First of all, we have used the LEN to get the length of that entire text string, then we used the FIND to get the position number of space between first and last names.

And in the end, we have used both the figures to get the last name.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.