TextLevel: IntermediateAvailable in: Excel 365 / 2021+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Example 3
- Related functions
TEXTAFTER returns the text that follows a delimiter — domains from emails, surnames, file extensions.
Syntax
=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
| Argument |
What it means |
instance_num |
−1 = after the last occurrence. |
Examples
Example 1
=TEXTAFTER(A2, "@")
company.in from an email.
Example 2
=TEXTAFTER(A2, ".", -1)
File extension: xlsx.
Example 3
=TEXTAFTER(A2, " ", -1)
Surname.
TEXTBEFORE · RIGHT
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong