# 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.