How to Use the RIGHT Function in Excel (Extract Characters from the End)

How to Use the RIGHT Function in Excel (Extract Characters from the End)

The RIGHT() function is used to extract a specified number of characters from the end (right side) of a text string.

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("EMP2025ID", 2)

This will return "ID", the last 2 characters.

🎯 Use Cases:

• Extract last digits from employee codes
• Pull domain extensions from URLs
• Get product type codes from SKUs

⚡ Pro Tip:

You can combine RIGHT with LEN() and FIND() for more flexible string parsing.

For more insights like this, follow ScriptDataInsights!