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

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("EMPLOYEE456", 3)

This returns "456", the last 3 characters of the string.

🎯 Use Cases:

• Extract employee ID numbers or codes from text
• Identify version numbers or suffix tags
• Filter batch numbers from serial codes

💡 Bonus Tip:

Combine with LEN() to dynamically calculate how many characters to extract based on other inputs.

For more Excel insights, follow ScriptDataInsights!