For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=FUNCTIONS

CONCAT()

Text

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

Excel worksheet with First/Last name columns and a CONCAT formula joining them into a full name, with a callout about CONCAT lacking a built-in delimiter.
=CONCAT(A2, " ", B2)
→John Smith

Joins a first and last name with a space in between.

=CONCAT(A2:A10)
→ABCDEFGHI

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"))
→Invoice 04 Mar 2026

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 TEXTJOIN when 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 TEXT to keep the display format.
  • The result is capped at 32,767 characters, Excel's cell limit.

Common errors

What goes wrong with CONCAT, and why
You seeBecauseFix
#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.
Tips / Tricks / Hacks

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 tricks and formula patterns
CONCAT patternCONCAT formulaBest useWatch 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.
Common CONCAT mistakes and how to fix them
CONCAT mistakeWhat happens in CONCATFix
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 textSentence 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

  1. Compare =CONCAT(A2:D2) against =TEXTJOIN("-", TRUE, A2:D2) on a 4-column table where column C is occasionally blank.

Related functions