Excel function RIGHT

Using the RIGHT function, you can extract a specified number of characters starting from the end of a text string ...

Let's try an example:

Cell B1 contains a reference.

We want to extract the two last letters ...

To do this, select the RIGHT function:

  • In the "Text" field, enter the cell that contains the text string.
  • In the "Num_chars" field, enter the number of characters to extract, starting from the right (2, in this case). Click OK.
right function - right

The function will now return the last two characters:

right - right