Site icon ExcelNotes

How to Use RIGHT Function

The RIGHT function returns the last characters in a text string based on the number of characters you specified.

Formula:

=RIGHT(text, [num_chars])

Explanations:

– The text is required, the text string that contains the text you need to extract;

Number_chars is optional, the number of characters you need to extract from right.

Cautions:

The Num_chars needs to be greater than or equal to 0;

– If num_chars is omitted, the result returns to the last character;

– If num_chars has decimals, only integer portion will be extracted;

– If num_chars is negative, the result returns #VALUE!

Example: Extract the last character from the text string in cell A2.

= RIGHT(A2,1)

The result returns "n", the last character in the sentence.

Download: RIGHT Function

Exit mobile version