What it does
CONCAT joins text from cells or ranges.
Syntax or pattern
=CONCAT(text1, [text2], ...)✅
5 practical examples
1
Join two cells
Combine first and last name.
=CONCAT(A2," ",B2)TEXTJOIN is often better when blanks matter.
2
Join a range
Combine a range of characters.
=CONCAT(A2:D2)No delimiter is added automatically.
3
Create an ID
Join department and number.
=CONCAT(A2,"-",TEXT(B2,"000"))Use TEXT to format numeric pieces.
4
Create a label
Build a product label.
=CONCAT(B2," (",C2,")")Good for readable dropdown labels.
5
Join with line breaks
Combine notes with a line break.
=CONCAT(A2,CHAR(10),B2)Turn on wrap text to display line breaks.
Common mistakes to avoid
- Not handling missing delimiters.
- Forgetting that some text functions return text, not numbers.
- Using fixed positions when the text layout is not consistent.
Related Excel examples
FAQ
Can text formulas work with Excel Tables?
Yes. Table references can make text-cleaning formulas easier to understand.