Exercises / Cleaning text · 10 of 13
One line with every attendee
TEXTJOIN(delimiter, ignore_empty, range) joins a whole range with a separator. With ignore_empty TRUE, blank cells are skipped, so you do not get ", ," in the result.
Your taskIn D2, use TEXTJOIN to join the names in B2:B9 into one line separated by a comma and a space, skipping the empty cells.
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 | D |
|---|---|---|---|---|
| 1 | Seat | Attendee | Attendees | |
| 2 | 1 | Maya | ||
| 3 | 2 | Luca | ||
| 4 | 3 | |||
| 5 | 4 | Amara | ||
| 6 | 5 | Jonas | ||
| 7 | 6 | |||
| 8 | 7 | Elira | ||
| 9 | 8 |