ExcelHeroThe TEXTJOIN function
Joins text with a separator between each piece.
In German Excel: TEXTVERKETTEN
How to write it
=TEXTJOIN(delimiter, ignore_empty, text1, …)- delimiter
- What goes between pieces, like ", ".
- ignore_empty
- TRUE skips empty cells.
- text1
- A range or values to join.
💡 Perfect for turning a column into one line.
Try it
List all students in one cell, separated by a comma and a space.
A
B
C
D
1
Student
Score
Everyone
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
=TEXTJOIN(separator, TRUE, range). TRUE skips empty cells.