List Chaperones
I need to create a comma-separated list of all parents who volunteered for the trip to easily share with other organizers or print for quick reference.
=TEXTJOIN(", ", TRUE, B2:B5) How it works: The TEXTJOIN function is perfect for concatenating text from multiple cells with a specified delimiter. In this formula: - `", "` is the delimiter, placing a comma and a space between each chaperone's name. - `TRUE` tells TEXTJOIN to ignore any empty cells within the specified range, preventing extra delimiters if a cell is blank. - `B2:B5` is the range containing the names of the volunteer chaperones you want to list.
Data Setup
| Student Name | Chaperone Name | Contact Info | Status |
|---|---|---|---|
| Alice | John Doe | john.doe@email.com | Confirmed |
| Bob | Jane Smith | jane.smith@email.com | Confirmed |
| Charlie | Peter Jones | peter.jones@email.com | Confirmed |
| David | Mary Lee | mary.lee@email.com | Confirmed |
| Eve | Tom Brown | tom.brown@email.com | Pending |
Step-by-Step Guide
Identify the column containing the names of the chaperones (e.g., Column B).
Select the cell where you want the combined list to appear (e.g., F2).
Enter the formula: `=TEXTJOIN(", ", TRUE, B2:B5)`.
Press Enter to generate the comma-separated list of chaperone names.