Home/Formulas/Text/CONCATENATE
Texteasy

CONCATENATE()

Appends strings to one another.

Syntax
fx
=CONCATENATE(string1, [string2, ...])
Try it
F2
→
Acme Co Q1
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Older function. CONCAT and & are simpler for joining a few values; TEXTJOIN is far better when you need a delimiter and skip-empty behavior.
  • Sheets DOES accept ranges (CONCATENATE(A1:A3) works, unlike classic Excel CONCATENATE), but there's no built-in delimiter: reach for TEXTJOIN when you need separators between values.
  • Numbers are formatted using the cell's value (not its display formatting). Wrap with TEXT() to preserve formatting.
Related formulas
TEXTJOIN()
Combines text with a delimiter, optionally skipping empty cells.
Used by
TEXTJOIN()
Combines text with a delimiter, optionally skipping empty cells.
More Text formulas →Keyboard shortcuts for Sheets →