How to use CONCAT in Excel
Joins text together.
Syntax
text1Text or a cell[text2]More text optionalExample
Here’s CONCAT on a small table of orders. The highlighted cells are the ones the formula reads.
=CONCAT(C2," ",B2)Edit this formula live Change the ranges and watch the answer update. Free, no sign-up.
Common mistakes with CONCAT
Add your own spaces
CONCAT joins exactly what you give it. Include " " between parts: =CONCAT(A2," ",B2).
Use TEXTJOIN for lists
To join a range with a separator, TEXTJOIN is easier than adding separators by hand.
What the error messages mean
Type these slips into Gridwise and this is the feedback you get:
Leaving off the closing bracket
=CONCAT(C2," ",B2
Parentheses don’t match. You have 1 opening and 0 closing parentheses. Every ( needs a ).
Questions
What does the CONCAT function do in Excel?
Joins text together. The syntax is CONCAT(text1, [text2], …).
Why is my CONCAT formula giving the wrong answer?
Add your own spaces: CONCAT joins exactly what you give it. Include " " between parts: =CONCAT(A2," ",B2). Use TEXTJOIN for lists: To join a range with a separator, TEXTJOIN is easier than adding separators by hand.
Does CONCAT work in Google Sheets?
Most Excel functions, including the core ones on this page, work the same way in Google Sheets. A few newer functions arrived in Sheets later or behave slightly differently, so test it on your own data.