Exercises / Cleaning text · 7 of 13
Get the domain with TEXTAFTER
TEXTAFTER(text, delimiter) returns everything after a delimiter, and TEXTBEFORE everything before it. They replace most LEFT/MID/FIND combinations in Excel 365.
Your taskIn C2, use TEXTAFTER to return the domain of the email in B2: everything after the @. It will be copied down to C7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C |
|---|---|---|---|
| 1 | Full name | Domain | |
| 2 | Maya Chen | maya.chen@brightlabs.io | |
| 3 | Luca Romano | luca@romano-design.it | |
| 4 | Amara Okafor | a.okafor@greenfield.org | |
| 5 | Jonas Berg | jonas.berg@nordicsoft.se | |
| 6 | Elira Kola | elira@kola.al | |
| 7 | Sam Taylor | sam.t@taylorandco.com |