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

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("INV2025", 4)

This returns "2025", the last four characters of the string.

🎯 Use Cases:

• Get the year from a code like "INV2025"
• Trim suffixes or unique IDs
• Extract currency codes from strings

💡 Bonus Tip:

Combine with LEN() and FIND() for flexible data extraction.

For daily Excel tips, follow ScriptDataInsights!