Learn How to Use Microsoft Excel RIGHT Function

Microsoft Excel RIGHT Function

The Microsoft Excel RIGHT function is used to extract the text from the text string's right side. That means by using the RIGHT function, you can able to pull a given number of characters from the right side of the specified text string. Here is an example to understand this:

RIGHT("angle", 3) will return "gle."

RIGHT Function Return Value

it will be the text extracted from the right side of the text string in the form of one or more characters.

RIGHT Function Syntax

= RIGHT(text, [num-chars])

Where the arguments:

• text: The text string from where you want to extract the characters.
• num-chars: The number of characters you want to extract from a specified text string.

How to Use the Microsoft Excel RIGHT Function?

As we know now, the RIGHT function is used to extract the n numbers of characters from the right side of the given text string. The arguments, text, and num-chars are used with the RIGHT function.

In case the num-chars is not provided, it defaults to 1, and if the num-chars is more than the characters in the text, the RIGHT function will return the entire text string. You can also use the LEFT and MID function to extract the text from the left and middle of the text string.

You can even use the RIGHT function with LEN and FIND function to perform more complex operations. Let us understand the RIGHT function with some examples as given below:

Example 1: = RIGHT("Portland, OR", 2) - The return value will be "OR".

Example 2: = RIGHT("XYZ") - The return value will be "C" .

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel