How To Use Excel RIGHT Function –Tutorial

Suppose we have the date of birth of an employee available with us and we just want to take out the year part of it.

Let us see how excel’s RIGHT function can help us with that…!!!

1. What is the RIGHT Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the RIGHT Function?

The RIGHT function can be used to extract the substring from the supplied text, starting from the rightmost character.


2. What is the Syntax?

=RIGHT(text,[num_chars])

  • text  = (Required) Text from which we have to extract the substring or a part of a text.
  • [num_chars] = [Optional] The no.of characters to extract from the right.

Note :

  • [num_chars] is optional and the default value for it is 1.
  • Any formatting applied to the cell (i.e Amount, currency) will not be considered while extracting the substring.

3. How to use it with an example?

Suppose we have to extract the year from the provided date of birth.

let’s see how to do that…!!!

Excel RIGHT Function.PNG

**Explained**

=RIGHT(B3,4)
  • B3 = Reference to the cell ,from which we want to extract the text from.
  • 4 = The no.of characters to extract from the rightmost side.

 

Hope it has helped you… 

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply