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.
=A2&", "&B2→Lee, DanaJoins a last name and a first name with a comma.
=CONCAT(A2:C2)→INV0042CONCAT joins a whole range with no separator.
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).
CONCATENATE is the older function and takes single cells only. CONCAT accepts ranges. TEXTJOIN also adds a delimiter and can skip empty cells.
Wrap the value in TEXT: =A2&" "&TEXT(B2, "dd/mm/yyyy"). Without it, a date appears as its serial number.
It tells TEXTJOIN to ignore empty cells, so you do not get doubled delimiters.
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.