How to Use Excel Right Function?

Excel is full of features, and we can do anything with it. You can use built-in functions and formulas to perform various mathematical operations. If you want to extract the characters from the right side of a text string, then Right Function will be the right choice to use in Excel. It is a built-in function and categorized under TEXT Functions.

This article gives you an illustration of the explanation, syntax, and usage of the Right function in Excel. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Description of Right Function

• It is one of the built-in functions in Excel.
• The Right function is used to extract the texts with the given number of characters from the right side.

Syntax

• Here, you will see the syntax of the RIGHT function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=RIGHT(text,[num_chars])

Argument Description

• Text – The input text string.

Practical Examples

Let’s grasp some examples of the Right function and explore how it works in Microsoft Excel.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have entered the input value in Cell B3, and we want to get the rightmost character from it.
• After that, we have to apply the above-mentioned formula to get the result.
• To get the result, you will need to click on the button.
• Let’s see another example to make it clear. In case, you want to get a specific number or range of characters, then you have to mention it as shown in the below screenshot.
• Now, it will extract the characters from position 5, and you will get the result, as shown below.