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

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

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

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("HR2025EMP", 3)

This will return "EMP", the suffix representing an employee ID type.

🎯 Use Cases:

• Extract suffix codes from structured data
• Retrieve last few digits of invoice or ID numbers
• Clean and segment text data in reports

💡 Bonus Tip:

Combine with LEN() to dynamically calculate how much text to grab from the end.

For more insights like this, follow ScriptDataInsights!