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

📘 Syntax:

=RIGHT(text, num_chars)

✅ Example:

=RIGHT("ScriptDataInsights", 9)

This returns "Insights" — the last 9 characters from the string.

🎯 Use Cases:

• Extract suffixes like domain names from email addresses
• Split codes or IDs ending with a unique format
• Clean up data with fixed-length fields

💡 Pro Tip:

Pair with LEN() and FIND() to get advanced extractions in combination with MID().

For more Excel how-tos, follow ScriptDataInsights and upgrade your data game!