Exercises / Cleaning text · 6 of 13
Get the username from an email
FIND(what, text) returns the position of one text inside another. When the part you want has no fixed length, use FIND to locate the separator and LEFT to cut up to it.
Your taskIn C2, use LEFT to return the part of the email in B2 before 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 | Username | |
| 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 |