How to use Excel RIGHT function with example

Excel RIGHT Function

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

Syntax

 

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.

 

Always Notice

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

 

Example 1

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.

 

Excel RIGHT Function

 

Example 2

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.

 

Excel RIGHT Function

 

Example 3

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

 

Excel RIGHT Function

 

Example 4

In this example, we take “num_chars” as “0” so the result is blank. It extracts 0 characters from a string.

 

Excel RIGHT Function

 

Example 5

It will provide the result as #VALUE! if num_chars taken as a negative value.

 

Excel RIGHT Function

 

Example 6

If the text string or cell value is alpha cum numeric, it will follow the rule always.

 

Excel RIGHT Function

 

 

Related Post: Excel LEFT Function

 

Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.