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 is used to extract a specific number of characters from the end (right side) of a string.

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("HRMGR123", 3)

This returns "123", the last three characters of the string.

🎯 Use Cases:

• Extract numeric codes from alphanumeric strings
• Separate suffixes from product names
• Handle standardized naming patterns in reports

💡 Pro Tip:

Combine with LEN() and FIND() to get more dynamic extractions.

For more Excel tips and insights, follow ScriptDataInsights!