Excel Concatenate with Space: A Complete Guide to Joining Text with Spaces

If you searched for Excel concatenate with space, the quickest answer is =A2 & " " & B2. In real-world work, however, you also need to handle double spaces caused by blank cells, preserving date and number formats, joining multiple columns at once, and cleaning up nonbreaking spaces (CHAR(160)). This guide provides step-by-step recipes and standard formulas that even beginners can use without mistakes.

Quick Fix: Join Text with a Space in 10 Seconds

1. Click the result cell (for example, C2).
2. Enter:

   =A2 & " " & B2

3. Press Enter, then drag the fill handle down to copy the formula.

To join multiple cells at once, automatically skip blanks, and insert just one space (recommended for Microsoft 365/Excel 2021 and later):

=TEXTJOIN(" ", TRUE, A2:C2)

Why Does This Happen?

& vs. CONCAT/CONCATENATE vs. TEXTJOIN

• & operator: The simplest and fastest option. You must enter the delimiter, such as a space " ", manually: =A2 & " " & B2
• CONCAT: Can join text and ranges, but has no delimiter option, so you must add " " manually.
• TEXTJOIN: Supports a delimiter and ignoring blank cells (TRUE). It cleanly handles multiple columns and ranges at once.

Blank Cells, Double Spaces, and Nonbreaking Spaces (CHAR(160))

When blank cells are included, the A2 & " " & B2 approach can create double spaces or leading and trailing spaces. In addition, web and ERP data often contains CHAR(160), which TRIM alone may not remove. In that case, use SUBSTITUTE(,CHAR(160)," ") first, then apply TRIM.

Practical Examples

1) Basic: The & Operator

=A2 & " " & B2

2) Recommended: Automatically Ignore Blank Cells (TEXTJOIN)

=TEXTJOIN(" ", TRUE, A2:B2)

=TEXTJOIN(" ", TRUE, FILTER(A2:D2, A2:D2<>""))

3) Preserve Date and Number Formats

=TEXTJOIN(" ", TRUE, A2:B2, TEXT(E2, "yyyy-mm-dd"), TEXT(F2, "#,##0"))

4) Process Many Rows at Once (BYROW/LAMBDA)

=BYROW(A2:D100, LAMBDA(r, TEXTJOIN(" ", TRUE, FILTER(r, r<>""))))

5) Line Break and Comma Delimiters

=TEXTJOIN(", ", TRUE, A2:D2)

=TEXTJOIN(CHAR(10), TRUE, A2:D2)

After entering the formula, select Format Cells > Alignment > Wrap text.

6) Join Text After Cleaning Nonbreaking Spaces (CHAR(160))

=LET(
  clean, TRIM(SUBSTITUTE(A2:D2, CHAR(160), " ")),
  TEXTJOIN(" ", TRUE, FILTER(clean, clean<>""))
)

Alternatives, Notes, and Checklist

• Older versions: If TEXTJOIN is unavailable, use CONCAT or & (CONCATENATE is for legacy compatibility).
• Prevent double spaces: Use TEXTJOIN(" ", TRUE, …) or remove blank values with FILTER.
• Lock in formatting: Use TEXT(cell,"format") for dates and numbers.
• Process large ranges: Use BYROW/LAMBDA.
• Nonbreaking spaces: Use SUBSTITUTE(,CHAR(160)," ") → TRIM.

Troubleshooting

Related Reading

• Split names and cities with TEXTSPLIT
• 5 patterns for cleaning up spaces with TRIM
• SUMIFS guide for multiple-condition summaries
• Complete guide to VLOOKUP with multiple criteria
• All-in-one XLOOKUP guide