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?
- Click on empty cell (like F5 )

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)