CONCAT()
Joins text from multiple cells or strings together, with no delimiter.
CONCAT(text1, [text2], ...)CONCAT joins everything you give it end-to-end into one string. It replaces the older CONCATENATE function and, unlike CONCATENATE, accepts whole ranges — CONCAT(A1:A5) joins all five cells without listing each one.
It has no built-in delimiter — to join with a comma, space, or other separator between items, use TEXTJOIN instead.
CONCAT replaced CONCATENATE by accepting ranges as well as individual arguments, but it offers no delimiter and no way to skip blanks — so joining a column of names with CONCAT runs them together and includes the gaps. TEXTJOIN is the better function for almost every real joining task. The detail that catches people out with either is that numbers and dates lose their formatting when concatenated: a date arrives as its five-digit serial number unless you wrap it in TEXT with an explicit format string.
Arguments
- text1
- The first text value, cell, or range to join.
- text2, ...optional
- Additional text values, cells, or ranges to join.
Examples

=CONCAT(A2, " ", B2)Joins a first and last name with a space in between.
=CONCAT(A2:A10)Unlike CONCATENATE, CONCAT accepts a whole range — but it offers no delimiter, so use TEXTJOIN when you need separators.
=CONCAT(A2, " ", TEXT(B2, "dd mmm yyyy"))A date concatenated raw appears as its serial number. TEXT forces the display format you want.
Notes and gotchas
- CONCAT has no delimiter argument. It joins everything with nothing between, so names come out as "JaneSmith" unless you add the space yourself.
- Use
TEXTJOINwhen you want a separator or need to skip empty cells — CONCAT includes blanks as nothing, which is fine, but offers no control. - Unlike the old
CONCATENATE, CONCAT accepts whole ranges:CONCAT(A1:A10). - Numbers lose their formatting when joined — a currency-formatted 1234.5 becomes "1234.5". Wrap in
TEXTto keep the display format. - The result is capped at 32,767 characters, Excel's cell limit.
Common errors
| You see | Because | Fix |
|---|---|---|
| #VALUE! | The combined result exceeds the cell character limit. | Join fewer values, or split across cells. |
| #NAME? | CONCAT is unavailable before Excel 2019. | Use CONCATENATE or the & operator. |
CONCAT tricks, tips, and workbook hacks
CONCAT replaces the legacy CONCATENATE function with one major upgrade: you can pass a continuous range like A2:E2 instead of clicking five cells one by one. However, CONCAT does not insert a separator between cells and does not skip anything—if you need commas, hyphens, or automatic blank-skipping across a range, TEXTJOIN is the superior tool.
Reach for CONCAT when you are joining a contiguous block of fixed-width codes, assembling composite lookup keys across columns, or collapsing an array transformation without delimiters.
Quick CONCAT checks before trusting the result
- Switch to TEXTJOIN(delimiter, TRUE, range) whenever you need spaces, commas, or hyphens between range cells.
- Format dates and currencies with TEXT(B2, "yyyy-mm-dd") inside CONCAT so Excel doesn't print raw serial numbers like 46096.
- Use CONCAT(DEC2BIN(...)) or CONCAT(MID(...)) to reassemble character-level array operations back into a single string.
| CONCAT pattern | CONCAT formula | Best use | Watch out |
|---|---|---|---|
| Composite lookup key across a row range | =CONCAT(A2:C2) | Building a single helper key from Company + CostCenter + Account columns. | If "AB" + "C" could collide with "A" + "BC", use TEXTJOIN("|", FALSE, A2:C2) instead. |
| Extract only the digits from a messy phone or ID string | =CONCAT(IFERROR(--MID(A2,SEQUENCE(LEN(A2)),1),"")) | Stripping parentheses, spaces, dashes, and letters out of "(415) 555-0192 ext 4" to leave "41555501924". | Requires Excel 365/2021 for SEQUENCE. |
| Dynamic narrative sentence with formatted numbers | =CONCAT("Q1 revenue closed at ",TEXT(B2,"$#,##0")," on ",TEXT(C2,"mmm d, yyyy"),".") | Executive commentary headers that update automatically when model numbers change. | Include trailing spaces inside your quoted string fragments. |
| CONCAT mistake | What happens in CONCAT | Fix |
|---|---|---|
| Passing a range and expecting spaces between words | =CONCAT(A2:B2) on "Jane" and "Doe" outputs "JaneDoe" with no space. | Use =TEXTJOIN(" ", TRUE, A2:B2) or =CONCAT(A2, " ", B2). |
| Unformatted date serials inside joined text | Sentence reads "Contract expires on 46386" instead of "Contract expires on Dec 31, 2026". | Wrap the date cell in TEXT(DateCell, "mmm d, yyyy"). |
CONCAT practice drills
- Compare =CONCAT(A2:D2) against =TEXTJOIN("-", TRUE, A2:D2) on a 4-column table where column C is occasionally blank.



