Members lesson 27
SPLIT and TEXTJOIN
Split names into columns, then combine cells with consistent separators.
What you will practice
- Split names into columns with a delimiter
- Join a range with one consistent separator
- Ignore blank cells in TEXTJOIN
Lesson preview
Starting tableContact names
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Imported name | First part | Second part | Name list | Joined result | ||
| 2 | Ana Chen | Ana | |||||
| 3 | Diaz,Bo | ||||||
| 4 | Bo | ||||||
| 5 | Cam | ||||||
| 6 |