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… 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: