TEXTJOIN Generator
Combine a range of cells into one string with your chosen delimiter, skipping blanks if you want.
TEXTJOIN
Combine values from a range into one string with a delimiter.
Text placed between each value. Needs quotes, for example ", ".
TRUE skips blank cells; FALSE keeps them.
The cells whose values you want to join.
=TEXTJOIN(", ", TRUE, A2:A10)Checks Before You Paste
- •Use CHAR(10) as the delimiter to join onto separate lines.
- •TEXTJOIN needs Excel 2019+ or Microsoft 365; use CONCATENATE otherwise.
- •Set ignore-empty to TRUE to avoid doubled-up delimiters.