Exercises / Cleaning text · 1 of 13
Join first and last names
The & operator joins text: =A2&B2 sticks two cells together. Put " " (a space in quotes) between them to keep the words apart.
Your taskIn C2, join the first name in A2 and the last name in B2 with a space between them. 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 | First | Last | Full name |
| 2 | Maya | Chen | |
| 3 | Luca | Romano | |
| 4 | Amara | Okafor | |
| 5 | Jonas | Berg | |
| 6 | Elira | Kola | |
| 7 | Sam | Taylor |