Skip to content

CONCATENATE

TextExcel 2007

Legacy function to join several text values (use CONCAT / TEXTJOIN).

Syntax

CONCATENATE(text1, [text2], …)

Arguments

text1 …
Values to join. Does not accept ranges — list cells individually.

How it works

Kept for backward compatibility. New workbooks should use CONCAT (ranges) or TEXTJOIN (with a delimiter), or the & operator.

Examples

=CONCATENATE(A2, " ", B2)

→ Priya Sharma

Related functions

CONCATTEXTJOIN

More Text functions

ARRAYTOTEXTASCBAHTTEXTCHARCLEANCODECONCATDBCSDOLLAREXACTFINDFINDB

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.