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!