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

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("INV2025", 4)

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

🎯 Use Cases:

• Extract year from invoice numbers
• Get file extensions like ".pdf"
• Split suffixes from employee codes

💡 Pro Tip:

Combine RIGHT() with LEN() to make dynamic formulas.

For more Excel tips, follow ScriptDataInsights!