How to Use the TEXTJOIN Function in Excel (Merge Text with a Delimiter) Want to combine text from multiple cells with a separator like comma, space, or hyphen? Use Excel's TEXTJOIN function! 🧩 Syntax: =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) 📌 Parameters: delimiter: Character(s) to separate values (e.g., ", " or " - ") ignore_empty: TRUE to skip blank cells text1, text2: The text ranges or values to join 💡 Example: =TEXTJOIN(", ", TRUE, A1:A3) If A1 = "Apple", A2 = "", A3 = "Banana" → Result: Apple, Banana ⚡ Why TEXTJOIN is Better Than CONCATENATE: Easier to join large ranges Automatically skips blanks Lets you add separators easily 🧠 Use Cases: Combine full names Create email lists Merge addresses Make your Excel work cleaner and smarter—master TEXTJOIN! For more Excel formula guides, follow ScriptDataInsights.