Exercises / Cleaning text · 8 of 13
First names with TEXTBEFORE
TEXTBEFORE(text, delimiter) returns everything before the first delimiter. A space as the delimiter gives the first word.
Your taskIn C2, use TEXTBEFORE to return the first name from the full name in A2. 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 | First name | |
| 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 |