Combine text from two or more cells into one cell

To combine text from two or more cells into one in Excel, you can use:

✅ 1. Ampersand (&) Operator

Formula:

=A1 & B1

If you want to add a space or other separators (like a comma):

=A1 & " " & B1

🔹 Example:
If A1 = John, B1 = Smith, the formula:

=A1 & " " & B1

will return:
John Smith

✅ 2. TEXTJOIN Function (Recommended for multiple cells with a separator)

=TEXTJOIN(" ", TRUE, A1, B1, C1)

• " " = space as separator
• TRUE = ignore empty cells

🔹 Example: Combines A1, B1, and C1 with spaces.

✅ 3. CONCAT Function (Excel 2016 and newer)

=CONCAT(A1, " ", B1)

Replaces older CONCATENATE function.

✅ 4. CONCATENATE Function (Older Excel versions)

=CONCATENATE(A1, " ", B1)

Still works but is now replaced by CONCAT.