Get the domain out of an email address
TEXTAFTER returns everything past a delimiter.
Task:
You are grouping signups by company. In C2, use TEXTAFTER to pull the part of the address in A2 that comes after the @.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of TEXTBEFORE, TEXTAFTER
0/4The same formula in the other shapes it takes at work.
- Get the domain out of an email address
TEXTAFTER returns everything past a delimiter.
CoreIntermediate - TEXTBEFORE: the part before the @
The mirror image of TEXTAFTER.
Beginner - TEXTAFTER the last delimiter: a file name
A negative instance number counts from the end.
Intermediate - TEXTAFTER the second delimiter
The instance number picks which hyphen to split after.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Signed up | Domain | |
| 2 | ada@lovelace.io | 2026-03-04 | |
| 3 | bo@nilsson-group.com | 2026-03-05 | |
| 4 | cy@watanabe.co.jp | 2026-03-07 |
What this exercise teachesMay contain the answer
The classic version of this is =RIGHT(A2,LEN(A2)-FIND("@",A2)) — three functions and an off-by-one waiting to happen. TEXTAFTER says what it does.