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.
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.
Follow the steps given below:-
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?
Follow the steps given below:-
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).
Follow the steps given below:-
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.
Follow the steps given below:-
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?
Follow the steps given below:-
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.
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
Related Articles:
Left Function in Microsoft Excel
Extract Text From A String In Excel Using Excel’s LEFT And RIGHT Function
Split Numbers and Text from String in Excel
Popular Articles:
50 Excel Shortcuts to Increase Your Productivity
How to use the VLOOKUP Function in Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
