How to use RIGHT Function in Excel

The RIGHT function can extract specified character(s) from a cell/string starting from the last (right) character.

You just need to refer to the cell where you have original text and specify the numbers of characters which you want to extract from the text string.

In the below example, we have extracted the last five characters from the cell where we have “Jack Brown”.

how to use right function in excel

Syntax

RIGHT(text,num_chars)

  1. text A text or number from which you want to extract some characters.
  2. num_char Number of characters you want to extract.

Examples

In the below 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.

get five characters from using right function
get last name using right function

Let me show you, how we have done this.

First of all, we have used the LEN to get the length of that entire text string, then we used the FIND to get the position number of space between first and last name.

And in the end, we have used both the figures to get the last name.

how right function get last name from cell

Remember

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

Sample File