right

 The RIGHT function in Excel is used to extract a specified number of characters from the end (right side) of a text string. Below are 10 examples of how you can use the RIGHT function, including data and formulas:

Example 1: Basic Usage

Data: "Hello World"
Formula: =RIGHT(A1, 5)
Result: "World"
Explanation: Extracts the last 5 characters from the text in cell A1.

Example 2: Extracting File Extensions

Data: "report.docx"
Formula: =RIGHT(A2, 4)
Result: ".docx"
Explanation: Extracts the last 4 characters, which is the file extension.

Example 3: Dynamic Length Extraction

Data: "123-456-7890"
Formula: =RIGHT(A3, LEN(A3) - FIND("-", A3))
Result: "456-7890"
Explanation: Extracts everything after the first hyphen.

Example 4: Extracting Last Word

Data: "Excel Functions"
Formula: =RIGHT(A4, LEN(A4) - FIND(" ", A4))
Result: "Functions"
Explanation: Extracts the last word by finding the space and taking everything after it.

Example 5: Extracting Year from Date

Data: "2023-10-05"
Formula: =RIGHT(A5, 2)
Result: "05"
Explanation: Extracts the last 2 characters, which represent the day in the date.

Example 6: Extracting Last 3 Digits of a Number

Data: 123456789
Formula: =RIGHT(A6, 3)
Result: "789"
Explanation: Extracts the last 3 digits of the number.

Example 7: Combining with LEFT and MID

Data: "ABCD-1234-XYZ"
Formula: =LEFT(A7, 4) & "-" & MID(A7, 6, 4) & "-" & RIGHT(A7, 3)
Result: "ABCD-1234-XYZ"
Explanation: Combines LEFT, MID, and RIGHT to reconstruct the original string.

Example 8: Extracting Domain from Email

Data: "user@example.com"
Formula: =RIGHT(A8, LEN(A8) - FIND("@", A8))
Result: "example.com"
Explanation: Extracts the domain part of the email address.

Example 9: Extracting Last Name from Full Name

Data: "John Doe"
Formula: =RIGHT(A9, LEN(A9) - FIND(" ", A9))
Result: "Doe"
Explanation: Extracts the last name by finding the space and taking everything after it.

Example 10: Extracting Currency Symbol

Data: "$100.00"
Formula: =RIGHT(A10, 1)
Result: "0"
Explanation: Extracts the last character, which is the last digit of the amount. (Note: This example is more illustrative; typically, you'd use LEFT to extract the currency symbol.)

Bonus Example: Extracting Last 4 Digits of a Credit Card Number

Data: "1234-5678-9012-3456"
Formula: =RIGHT(A11, 4)
Result: "3456"
Explanation: Extracts the last 4 digits of the credit card number.

These examples demonstrate the versatility of the RIGHT function in Excel, showing how it can be used in various scenarios to extract specific parts of text strings.