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