Excel RIGHT Function

What is the RIGHT function in Excel?


The RIGHT function is one of the (TEXT) functions of Excel. It returns the specified number of

characters from the end of a text string.

We can find this function in TEXT of insert function Tab.

How to use RIGHT function in excel?

  1. Click on empty cell (like F5 )
1

2. Click on fx on the below of font word (or press shift+F3)

3. In insert function tab you will see all functions

4. Select TEXT category

5. Select RIGHT function

6. Then select ok

7. In function arguments Tab you will see RIGHT function

8. Text is the text string that contains the characters you want to extract

9. Num_chars specifies how many characters you want to extract, 1 if omitted

10. You will see the results in formula result section

Examples of RIGHT function in Excel

What is the purpose of RIGHT function?

It returns the specified number of characters from the end of a text string.

What is the Return value  of RIGHT function?

It can return any type of data.

RIGHT (text,Num_chars)=number,text,...

How many arguments does RIGHT function have?

RIGHT (text,Num_chars)

RIGHT function has 2 argument.

Text is the text string that contains the characters you want to extract

Num_chars specifies how many characters you want to extract, 1 if omitted

Which version of excel supports RIGHT function?

This function is available for all excel versions (2003-2019)

Errors in RIGHT function

Leave a Reply

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