Array Functions
Intermediate
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 @.
Learning Objectives:
- Extract text after a delimiter
- Replace a RIGHT/LEN/FIND stack
- Keep formulas readable
Hints
Solve without hints for +5 XP
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 teaches (contains 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.