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) |