Home  Excel Function  Excel Right Function

  Syntax or Excel Right Function

What is the use Excel Right Function?

Excel RIGHT Function can extract a specified characters from a cell starting from the last character.Excel Right Function To Extract Text If you check above example word “Brown” has 5 characters starting from the first character from the right side.

Syntax for excel right function

RIGHT(text,num_chars)

text A text or number from which you want to extract some characters. (Required)

num_char Number of characters you want to extract. (Optional)

Additional Information on excel right function

  • You will get an #Value! error on using negative numbers in num_char.
  • If you skip specifying num_char, it will assume 1 as default.
  • You can’t refer to more than one cell. If you do that it will return the characters from the top-left cell of the range.

Examples to understand excel right function

In above example, we have extracted 6 characters using right function. If you know, how many characters you need to extract from the string, you can simply extract them by using a number.

Excel Right Function Simple Examples

Now, if you look at the above example, where we have to extract the last name from the cell, but we are not confirmed about the number characters in the last name. So, we are using LEN Function & Find Function along with the right formula to get the name.

Excel Right Function Example For Understanding

Let me show you, how we have done this. First of all, we have used the Len function to get the length of that entire text string, then we used the Find Function to get the position number of space between first & last name. And, in the end, we have used both the figures to get the last name.

Excel Right Function With Other Excel Functions

Download Sample File

Download Sample File Learn More About Excel RIGHT Function

More Tips related With Excel RIGHT Function

Conclusion

The best part of the Excel Right Function is that you can use it with other functions to get some dynamic results. Learn more about RIGHT from here.

Related Functions

Search | Rept | Mid | Left | Right

Blog | Excel Functions