Course
TEXTJOIN and CONCAT practice exercises
Five exercises, from a list with commas to a label that nests TEXTJOIN inside CONCAT. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the TEXTJOIN and CONCAT tutorial
Exercise 1 of 5
Join a row with commas
Each person lists up to three languages in B:D. In E2, use TEXTJOIN to list the languages of row 2 separated by a comma and a space, skipping empty cells, then copy it down to E5.
| Name | Language 1 | Language 2 | Language 3 | Languages |
| Olivia Reed | English | French | ||
| James Carter | Spanish | |||
| Sofia Patel | German | English | Italian | |
| Liam Brooks | Portuguese | English |