What Is the TEXTJOIN Function in Excel & When Should You Use It? If you’ve ever needed to combine multiple cell values into a single cell, Excel’s TEXTJOIN function is your best friend. It’s smarter and cleaner than CONCATENATE or ampersands ( & ), especially when dealing with blanks and custom separators. 🔧 Syntax: =TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) delimiter – The text separator you want between values (e.g., ", ", " | ", "-"). ignore_empty – Use TRUE to skip empty cells; FALSE to include them. text1, text2, ... – The values or cell ranges to join. 📘 Examples =TEXTJOIN(", ", TRUE, A1:A5) → Joins values from A1 to A5 with commas, ignoring blanks. =TEXTJOIN(" - ", FALSE, "Name", "", "Age") → Result: "Name - - Age" =TEXTJOIN(CHAR(10), TRUE, B1:B3) → Joins cells with a line break (useful for addresses). ...