How to Combine Text from Multiple Cells in Excel How to Combine Text from Multiple Cells in Excel (With & Without CONCATENATE) Need to combine first and last names? Or join address lines? Excel provides multiple ways to merge text from different cells. Here's how to do it easily: 🔗 Method 1: Use the Ampersand (&) This is the quickest way to join cells: =A2 & " " & B2 This combines A2 and B2 with a space in between. Great for First Name + Last Name. 🧩 Method 2: Use CONCAT or CONCATENATE CONCATENATE is the older function. Example: =CONCATENATE(A2, " ", B2) In modern Excel versions, use CONCAT instead: =CONCAT(A2, " ", B2) 🔁 Method 3: TEXTJOIN for Many Cells If you're joining a range of cells with a common separator, use: =TEXTJOIN(", ", TRUE, A2:C2) This joins all three cells with a comma and skips blanks. ✅ Example Use Cases Combining fu...

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). ...