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 extracts a specific number of characters from the end (right side) of a given text string.

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("HR2025EMP", 3)

This will return "EMP", possibly indicating employee type or ID suffix.

🎯 Use Cases:

• Extract year or code from structured IDs
• Clean file name suffixes or types
• Isolate last names or serial endings

💡 Bonus Tip:

Use LEN() with RIGHT() when extracting based on string length.

For more Excel breakdowns, follow ScriptDataInsights!