Join text from several cells with a separator, skipping blanks.
Copy this formula
=TEXTJOIN(" ", TRUE, A2, B2)TEXTJOIN takes a delimiter, a flag to ignore empty cells (TRUE), and the cells or ranges to join. It's cleaner than chaining & when you have many cells or a whole range.
=TEXTJOIN(", ", TRUE, A2:A5)→Apple, Pear, PlumJoins a column of items into a comma list.
Simple two cells
=A2&" "&B2The & operator is enough for joining just a few cells.
Use CHAR(10) as the delimiter and turn on Wrap Text: =TEXTJOIN(CHAR(10), TRUE, A2:A5).
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.