How to use Excel RIGHT function

Quick view of Excel RIGHT Function

Explanation: In the above table, the RIGHT function is applied to the data and the results are from D25 to D32. The formula can be seen in the E column.

Excel Right Function

The Excel RIGHT function helps us to extract the desired number of characters from the RIGHT most of the selected cell.

Purpose (When to use Right Function)

The RIGHT function is used to extract the text from the right of a string.

Return value (Result)

This function fetches us the desired number of characters.

Syntax (Rules to use Right Function)

=RIGHT (text, [num_chars])

Arguments (Parts of Syntax)

  1. text – The text from which you wish to extract Characters.
  2. Num_chars – Desired number of characters to be extracted from the Right side of the Text.

Explanations

To extract the last three characters of PQR123

=RIGHT(“PQR123”,3) gives us “123”.

To extract the last four characters of John Smith

=RIGHT(“John Smith”,5) fetches “Smith”.

To extract the last Six characters of David Wilson

=RIGHT(“David Wilson”,6) fetches “Wilson”.

To extract the last four characters of 180-0789- 3210

=RIGHT(“180-0789-3210”,3) fetches 3210 as a text.