Text · join items · Nov 2026

The CONCATENATE function,
measured & explained.

Syntax, a live playground, a measured joining gallery, the range and number-format traps, and a sourced error library: joining text items in order.

D1
fx
=CONCATENATE(A2, " ", A3)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How CONCATENATE works

Joins up to 255 text items into one string in the order given. Takes individual items, not ranges; numbers become text.

=CONCATENATE(text1, [text2], [...])
text1The first item — cell, literal, or number.
text2...Up to 255 items, joined in order.
numbersConverted to text; format with TEXT first.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Join text

What CONCATENATE actually joins

CONCATENATE joins up to 255 text items into one string, in the order you list them. Numbers become text. Every row was measured live in HyperFormula. Click any row to load it.

Joining gallery — items in order, numbers as text

ExpressionResultWhy
=CONCATENATE(A2,A3)ExcelFormulaJoin two cells with no separator
=CONCATENATE(A2," ",A3)Excel FormulaAdd a space between the parts
=CONCATENATE(A2,"-",B2)Excel-101Mix text and a number
=CONCATENATE("a","b","c")abcJoin literal strings
=CONCATENATE(A5," ",A2)Lab ExcelOrder is exactly as listed
=CONCATENATE(B2,C2)1013Numbers are joined as text
=CONCATENATE(A2,"/",A3,"/",A4)Excel/Formula/LookupBuild a path from parts
=A2&A3ExcelFormulaThe & operator does the same job

The shorter alternative

ExpressionResultWhy
=A2&" "&A3Excel FormulaThe & operator joins with less typing
=CONCATENATE(A2)ExcelA single item is returned as text
⚠ CONCATENATE takes individual items, not ranges. In Excel =CONCATENATE(A2:A5) errors — to join a whole range use CONCAT (Excel 2019+) or TEXTJOIN. The & operator does the same job as CONCATENATE with less typing. CONCATENATE is legacy but still fully supported; Microsoft recommends CONCAT for new work.
// 03 — Try it live

Interactive CONCATENATE playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see CONCATENATE join cells, add separators, mix numbers, and match the & operator.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where CONCATENATE works

CONCATENATE is available across modern Excel, Google Sheets and LibreOffice. It is legacy; CONCAT and TEXTJOIN (Excel 2019+) are the modern replacements.

PlatformSupportNotesGotcha
✓ Supported full CONCATENATE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master text joining

CONCATENATE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • CONCATENATE vs & vs CONCAT vs TEXTJOIN
  • The range limitation and the 255-item cap
  • Keeping number and date formats with TEXT
  • Choosing the right join for the job
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked