How to Use TEXTAFTER Formula in Excel + Tips

Hello everyone! Today i will show you how to use TEXTAFTER formula in Excel step by step. TEXTAFTER is available in Excel 2021 and Excel 365.

What is TEXTAFTER Function in Excel?

The TEXTAFTER function help you extract all text that appears after a specific character or delimiter (like space " ", dash -, at sign @, or comma ,). In old Excel, you need combine RIGHT, LEN, and FIND formulas together, but TEXTAFTER make your formula very short and simple!

📚 Related Tutorial: Want to extract text BEFORE a delimiter instead? Check out How to Use TEXTBEFORE Function in Excel!

🛠️ Formula Syntax

=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])

• text: The cell or original text string you want to extract from (example: A1).
• delimiter: The symbol or text character you look for (example: "@", " ", "-").
• [instance_num] (Optional): Which occurrence of delimiter to match. Use positive number (like 1 or 2) from left to right, or negative number (like -1) from right to left!
• [match_mode] (Optional): 0 for case-sensitive match (default), 1 for case-insensitive match.
• [if_not_found] (Optional): What text to show if delimiter is not found in cell.

📊 Simple Examples

Example 1: Extract Last Name from Full Name

=TEXTAFTER(A1, " ")

If cell A1 contains "John Smith", formula returns: Smith

Example 2: Extract Domain Name from Email Address

=TEXTAFTER(A1, "@")

If cell A1 contains "meng@gmail.com", formula returns: gmail.com

Example 3: Extract Text After Dash -

=TEXTAFTER(A1, "-")

If cell A1 contains "John-Smith", formula returns: Smith

Example 4: Get Text After 2nd Delimiter

=TEXTAFTER(A1, "-", 2)

If cell A1 contains "2026-09-14", setting instance_num to 2 returns: 14

Example 5: Extract Text After LAST Delimiter (Negative Instance -1)

=TEXTAFTER(A1, "-", -1)

If cell A1 contains "ABC-123-XYZ", using -1 searches from right to left and returns: XYZ

Example 6: Avoid #N/A Error if Delimiter Missing

If delimiter might not exist in cell, use IFNA to return original cell A1 cleanly:

=IFNA(TEXTAFTER(A1, "-"), A1)

⚡ Modern Excel Text Functions Comparison

💡 Quick Tips & Easy Memory Rule:

1. Memory Rule: TEXTBEFORE = ⬅️ Before, TEXTAFTER = ➡️ After.
2. Pro Tip for File Paths or URLs: Use -1 for instance_num to quickly extract file extension or file name after the last slash / or backslash \!

📚 Related Resources & Tutorials

• How to Use TEXTBEFORE Function in Excel
• How to Use TEXTSPLIT Function in Excel
• How to Use TEXTJOIN Function in Excel
• Top 15 Basic Excel Formulas for Beginners ↗