Level 2Text, Part 2Practice, 2 min
TEXTJOIN: an email list for the invite
The task
You need every attendee's email in one cell to paste into a calendar invite. In D2, join the emails in B2:B7 with a comma and a space, skipping the people with no email.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Attendee | Invite list | ||
| 2 | Dana Kwan | [email protected] | ||
| 3 | Marcus Reed | |||
| 4 | Lina Park | [email protected] | ||
| 5 | Theo Marsh | [email protected] | ||
| 6 | Ellen Price | |||
| 7 | Omar Haddad | [email protected] |