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 full names: First + Middle + Last
• Creating mailing labels from address lines
• Joining product codes and descriptions

⚠️ Common Tips

• Always insert separators like space or comma manually (e.g., " " or ", ").
• Use TRIM() to remove extra spaces if needed.
• For large data, use TEXTJOIN() for cleaner formulas.

📥 Need an Excel name generator or address combiner? Download our free tools on Gumroad.