In a given string we normally look it from left to right and calculate the length and other values, but we also have a right formula which is an inbuilt text function in excel which will return the number of characters we specify to it but from right to left and this formula takes two arguments text and the number of characters.

**Right Formula in Excel (Table of Contents)**

## Excel Right Formula

With Excel, the RIGHT formula can be used to extract and return a substring, or a specified number of characters from the end of a string. This function can be very useful in financial analysis and extraction of substrings when combined with other String/Text and Mathematical Functions.

General Formula for the RIGHT function is as follows:

The RIGHT excel function syntax has the following arguments:

**text:**Required, represents the string from which we wish to extract the substring.**num_chars:**Optional, represents the number of characters that we wish to extract from the rightmost character of the string.

The text argument is generally provided as a cell reference to the function. The default value of num_chars is 1, i.e if this argument is omitted, then the function returns only one character or the rightmost/last character of the string.

This function applies to Excel 2013, Excel 2016, Excel 2019, Excel 2010, Excel 2007, Excel 2003, Excel 2000, Excel for Office 365, Excel 2011 for Mac, Excel XP.

### How to Use RIGHT Formula in Excel?

A RIGHT formula can be used in the following ways:

- Click on the cell where the computation of the RIGHT formula is desired, then type ‘=’ followed by ‘RIGHT’, and enter the arguments of the excel function:

- This would generate a dialog box that would show a list of functions. Select the function ‘RIGHT and then click ‘OK’.

- Then, another dialog box will appear that will ask for arguments to be entered. Enter the arguments and click ‘OK’.

### Examples of RIGHT Formula in Excel

Below are the examples of the right formula in Excel.

#### Example #1

If we want to return the last four characters of a given text:

=RIGHT(A2,4)

We can see that cell A2 contains the given text, and the last four characters of the text have to be extracted and returned in the cell: B2. To do this, we use the Excel RIGHT formula. The text is supplied as the first argument to the RIGHT function and the second argument is 4 since we desire to return 4 characters from the text.

So, with this, the substring: ‘riti’ is returned.

#### Example #2

Now, if we want to return the last alphabet of a given name:

=RIGHT(A2)

Apply the above formula in cell B2.

The result is “i”.

We can see that cell A2 contains the given name, and the last alphabet of this name is contained in the cell: B2. Thus, to do this we use the RIGHT function. The name is supplied as the first argument to the RIGHT function and the second argument is omitted. This is so as the default value of the argument ‘num_chars’ is 1. So, ‘i’ is returned.

The same result can also be achieved by supplying the second argument as ‘1’ to the ‘RIGHT’ function.

Below is the screenshot that illustrates this:

#### Example #3

Now, let’s say we have some numbers and we want to return the last two digits (unit’s place and hundred’s place) of these numbers so as to see their divisibility by some specific numbers:

=RIGHT(A2,2)

Apply the above formula:

We can see that the cells A2:A5 contains the given numbers, and the last two digits of these numbers are desired to be extracted and returned in the corresponding cells: B2:B5. Hence, the RIGHT Excel formula is used to do this task. The given number is supplied as the first argument to the RIGHT function and the second argument is 2 as we wish to extract the last 2 digits from the number. So, the last two digits of these numbers are returned in cell B2.

We had extracted the last 2 digits from the number

Drag the Formula to rest of cells.

#### Example #4

Now, it is also possible sometimes that some strings may be succeeded with some unnoticed spaces (these trailing spaces are common when the strings are copied from somewhere). So, let us see how the RIGHT function will work in such cases:

=RIGHT(A2,3)

Apply the right formula as shown above:

It returned the last 3 characters of a string.

Here, cell A6 contains some trailing space.

So, we see that when we apply the RIGHT function, we get different results. This is so as the name in cell A6 is succeeded by a space. So, space is also counted as one character by the RIGHT function. Hence, we get different results in cells B2 & B6, even when we have applied the same formula to the same string. We can see that cells: A2 and A6 both contain the same string, and the last three characters of this name are to be returned in corresponding cells: B2 & B6.

### Things to Remember

- A RIGHT formula is a built-in function in Excel which is categorized as a String/Text function.
- It is believed to be useful in cases where substrings from the right side of the string are to be extracted.
- It can even be used to extract digits from numbers.
- Number formatting, for instance, symbols can’t be extracted since they are not part of the number.
- It can also be used as a worksheet and VBA function.
- The Excel RIGHT formula returns a text or string value.
- The argument which is supplied as ‘num-chars’ to the RIGHT function should be greater than or equal to zero.
- If the argument that is supplied as ‘num-chars’ to the RIGHT function is less than zero, then the function returns a ‘#VALUE!’ error. This is so as the function does not allow negative value.

Below is the screenshot that illustrates this:

- If the argument which is supplied as ‘num-chars’ to the RIGHT function is greater than the total length of the supplied string, then the RIGHT function returns the full string.

Below is the screenshot that illustrates this:

- In Excel, dates are stored in the form of some numbers. Thus, when we apply the RIGHT function on some date, then the function returns the rightmost digits of the number represented as that specific date.

Below is the screenshot that illustrates this:

This screenshot depicts that the data present in the cell: A2 is stored in Excel in the form of a number whose last three digits are 561.

- If we wish to return a substring from a string not on the basis of a number of characters, instead basis the number of bytes specified, then we can use RIGHTB instead of RIGHT function.

### Recommended Articles

This has been a guide to RIGHT Formula in Excel. Here we discuss how to use the RIGHT Formula in Excel to extract and return a substring, or a specified number of characters from the end of a string with some examples and downloadable excel template. You may learn more about excel from the following articles –

- Excel Insert Formula
- VBA SubString
- TEXT Function in Excel
- String Functions in VBA
- Left Function in VBA
- Separate Text in Excel

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion