How to Use the RIGHT Function in Excel (Extract Characters from the Right)

How to Use the RIGHT Function in Excel (Extract Characters from the Right)

The RIGHT() function is used to extract a specific number of characters from the end (right) of a text string. It's perfect for getting codes, numbers, or text suffixes.

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("Invoice2025", 4)

This returns "2025" – the last 4 characters from the text.

🎯 Use Cases:

• Extract year or IDs from invoice numbers
• Handle suffixes in product codes
• Automate consistent formatting

📌 Bonus Tip:

Combine LEN() and RIGHT() to dynamically trim text from variable-length strings.

For more Excel tricks, follow ScriptDataInsights!