Google Sheets CONCAT & CONCATENATE Issues & How To Fix Them

Your text-joining formulas aren’t working, results are incomplete, spacing is wrong, or formulas break when adding more cells.
This usually happens due to confusion between CONCAT, CONCATENATE, and better alternatives like & or TEXTJOIN.

Why the Issue Happens

Using CONCAT for multiple cells (it only supports two)
Using CONCATENATE inefficiently with many inputs
Missing spaces between joined values
Mixing text and numbers without formatting
Blank cells causing unexpected gaps
Using outdated functions instead of better alternatives
Not handling ranges properly

Step-by-Step Fixes

Step 1: Understand the Difference

CONCAT → only joins 2 values

=CONCAT(A2, B2)

If you try more:

=CONCAT(A2, B2, C2)   ❌ (won’t work)

CONCATENATE → joins multiple values

=CONCATENATE(A2, B2, C2)

But it’s outdated and not flexible.

Step 2: Use `&` Operator (Best Simple Method)

Instead of CONCAT/CONCATENATE:

=A2 & B2

With spaces:

=A2 & " " & B2

Step 3: Fix Missing Spaces

Common issue:

=CONCATENATE(A2, B2)

Result → JohnSales

Fix:

=A2 & " " & B2

Step 4: Use TEXTJOIN for Multiple Cells (Best Method)

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

" " → delimiter
TRUE → ignore blanks
A2:C2 → range

Step 5: Handle Blank Cells Properly

Problem:

Blank cells create extra separators

Fix:

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

Step 6: Combine Numbers and Text Correctly

If numbers are involved:

="Total: " & TEXT(A2, "0.00")

Step 7: Join Entire Column

Wrong:

=CONCATENATE(A2:A100)   ❌

Correct:

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

Step 8: Avoid CONCAT for Ranges

CONCAT doesn’t work well with ranges:

=CONCAT(A2:A10)   ❌

Use:

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

Step 9: Clean Data Before Joining

Hidden spaces affect output.

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

Step 10: Use ARRAYFORMULA for Dynamic Joining

=ARRAYFORMULA(A2:A & " - " & B2:B)

Common Mistakes

Using CONCAT for multiple cells
Forgetting delimiters (spaces, commas)
Using CONCATENATE instead of TEXTJOIN
Not handling blank cells
Mixing text and numbers without formatting
Using ranges incorrectly

Pro Tips

Comma-separated list

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

Full name format

=A2 & " " & B2

Conditional joining

=IF(A2<>"", A2 & " - " & B2, "")

Bottom Line

If CONCAT or CONCATENATE isn’t working, fix in this order:

Use & for simple joins
Use TEXTJOIN for multiple cells
Add proper delimiters (spaces, commas)
Handle blanks using TRUE in TEXTJOIN
Avoid CONCAT for ranges

Most issues come from using the wrong function for the job.
Switch to TEXTJOIN or &, and your text combinations will work cleanly.