# How to use RIGHT function in Microsoft Excel

http://www.exceltip.com/text/excel-right-function.html

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

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.

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.

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

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?

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

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).

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

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.

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

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?

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

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.

# Video: How to use RIGHT function in Microsoft Excel

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