Excel RIGHT() Function

The RIGHT() function in excel returns the rightmost characters from a text value. This function is used for data manipulation.

Syntax

RIGHT(Text, [num_chars])

Parameter

Text (required)- This parameter represents the string from which you want to find letters.

num_chars(optional)- This parameter represents the number of characters you want to read from the right.

Category

Text

Return

This function returns the number of specified characters from the start of the string.

Example 1

Objective: Use the RIGHT function on the following strings

Text Result Formula
Laptop is working op is working  =RIGHT(A19,13)
EXCEL IS AWESOME! OME!  =RIGHT(A20,4)
MARKET IS CLOSED . OSED .  =RIGHT(A21,6)
1901 1  =RIGHT(A22,1)
SUPERSTORE IS OPENED ENED  =RIGHT(A23,LEN(A23)-16)

Example 2

Objective: Extract LastName using functions RIGHT function

Name Last Name Formula Used
Sukla Pati la Pati =RIGHT(B7,7)
Rachel Buffay  Buffay =RIGHT(B8,7)
Joey Mitchell Itchell =RIGHT(B9,7)
Chandler Kumar Patra r Patra =RIGHT(B10,7)
Delia Azahari Azahari =RIGHT(B11,7)
Mar Martin Castellano Tellano =RIGHT(B12,7)
Daniel Oso iel Oso =RIGHT(B13,7)

Example 3

Objective: Use the RIGHT function to get the results in the 2nd column

Text Result Formula
Phone Number is +(0)1234 is +(0)1234  =RIGHT(A19,11)
This is used for data cleaning data cleaning  =RIGHT(A20,13)



ADVERTISEMENT
ADVERTISEMENT