What it does
CONCAT joins text from cells or ranges.
Syntax or pattern
=CONCAT(text1, [text2], ...)5 practical examples
Join two cells
Combine first and last name.
=CONCAT(A2," ",B2)TEXTJOIN is often better when blanks matter.
Join a range
Combine a range of characters.
=CONCAT(A2:D2)No delimiter is added automatically.
Create an ID
Join department and number.
=CONCAT(A2,"-",TEXT(B2,"000"))Use TEXT to format numeric pieces.
Create a label
Build a product label.
=CONCAT(B2," (",C2,")")Good for readable dropdown labels.
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.
Here are some ideas for you
Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.
- Excel formula booksSee ideas
Practice formulas with structured examples you can keep beside your desk.
- Excel shortcut guidesSee ideas
Build speed with keyboard shortcuts for selection, formatting and navigation.
- Numeric keypadsSee ideas
Helpful if you enter many numbers on a laptop or compact keyboard.
- External monitorsSee ideas
Useful for viewing large worksheets, formulas and reference tables side by side.
- Desk notebooksSee ideas
Sketch formula logic, report ideas and table structures before building.
- Laptop standsSee ideas
Make long spreadsheet sessions more comfortable and ergonomic.
Some links in this section may be affiliate links. Choose only what is useful for your own work.