Excel RIGHT function
In this blog post, we will learn about Excel RIGHT function. What is Excel RIGHT Function and how can we use this function in our working routine.
This function is very similar to Excel LEFT function. The only difference is the Excel LEFT Function retrieves the data from the left side of a string. Whereas Excel RIGHT function retrieves it from the right side.
How to define Excel RIGHT function
Excel RIGHT function retrieves some specific numbers of text characters from the right side of a given string in a cell.
Excel RIGHT Function
=RIGHT (text, [num_chars])
text (required)- The text (or number) string in a cell from which we will extract text or number characters.
[num_chars] – (optional) these are the number of characters we will retrieve from the given text string in a cell.
[num_chars] must be “0” or greater than “0” and if it is not it will consider as 1 by default.
If [num_chars] are more than a text string, it will retrieve all the characters in a cell.
If [num_chars] are not mentioned, retrieve first (1) character from a string.
[num_chars] it works with numeric and text characters as equal.
[num_chars] if this value is (-1) negative value, it will return the result as (#VALUE!)
Here is the function
=RIGHT (go to this cell, retrieve required TEXT or number from given string)
As we can see in the below image, we take “3” as “num_chars” and result is “nsg”. It retrieves only three characters from the right side.
In the previous example, we put “A2” as a cell reference. But in this example, we put text “Excelnsg” in place of cell reference (A2). See that both results are same. So it will produce the same result, from cell reference or type a whole text string.
In this example, we did not specify “num_chars” and see that it assume it as “1” by default. And returns result as “E” first characters of “Excelnsg”.
In this example, we take “num_chars” as “0” so the result is blank. It extracts 0 characters from a string.
It will provide the result as #VALUE! if num_chars taken as a negative value.
If the text string or cell value is alpha cum numeric, it will follow the rule always.