How to use RIGHT function in Microsoft Excel

 

In this article, we will learn about RIGHT function in Microsoft Excel.

RIGHT function is used to return the rightmost character or characters from a text string.

image 1

 

With the help of examples, let us understand the use of RIGHT function. So, here we have dummy data with some sample text in column A.

image 2

 

1st Example:-

In this example, we have sentence in a cell from which we want to retrieve the text from the right in the cell.

image 3

 

Follow the steps given below:-

  • Enter the function in cell B7
  • =RIGHT(A7,4), Press Enter

image 4

 

Formula Explanation: In this function, first we have selected text from which we want to extract the text from the right side and as we want to extract 4 text, so we entered 4.
 
2nd Example:-

In this example, we will learn what happens when we do not enter number of characters?

image 5

 

Follow the steps given below:-

  • Enter the function in cell B8
  • =RIGHT(A8), Press Enter

image 6

 

The function has returned the rightmost character of that string, and in this case, it returns “s” which is the rightmost character of “This is” string.

 

3rd Example:-

In this example, we will see what happens when we enter 0 in 2nd argument (num_chars).

image 7

 

Follow the steps given below:-

  • Enter the function in cell B9
  • =RIGHT(A9,0), Press Enter

image 8

 

The function has returned the empty cell because it is looking for “0” character to extract from this string and hence it returns blank cell.

 

4th Example:-

Now see what happens when we enter a negative value in number of character argument.

image 9

 

Follow the steps given below:-

  • Enter the function in cell B10
  • =RIGHT(A10,-1), Press Enter

image 10

 

It returns #VALUE error because RIGHT function does not allow any negative value.

 

5th Example:-

What happens in case we don’t know how many characters are to be extracted and we type any random number which is greater than the length of the original string?

image 11

 

Follow the steps given below:-

  • Enter the function in cell B11
  • =RIGHT(A11,15), Press Enter

image 12

 

It has extracted whole text from the cell, as you can see here we have typed 15 as the number of character whereas the length of this string is 9, which is less than the number of character we specified in the 2nd argument.

So this is how RIGHT function works in various ways in Excel.

 

image 48

 

Video: How to use RIGHT function in Microsoft Excel

Watch the steps in this short video, and the written instructions are above the video

 

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 



Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>