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 extracts 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 file extensions like ".pdf" or ".xlsx"
• Pull out last names from full names (with logic)
• Format and clean trailing codes or labels

💡 Bonus Tip:

Combine with LEN() and FIND() for flexible dynamic text extractions.

Want more Excel skills that matter? Follow ScriptDataInsights for daily tutorials and tools!