Excel CONCAT Function: How to Use It, with Examples
Turkish: ARALIKBİRLEŞTİR

Joins several pieces of text or cells into one text. It replaces the older CONCATENATE and accepts ranges.

CONCAT syntax

=CONCAT(text1, [text2])

In Turkish Excel: =ARALIKBİRLEŞTİR(metin1; [metin2])

ArgumentDescription
text1The first text, cell or range to join.
[text2]More text.

CONCAT examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=CONCAT(A2," - ",B2)
Result: Pen - Ankara

Joins product and region with a dash.

Results were calculated in real Excel.

Tips for CONCAT

  • TEXTJOIN is handier when you need a separator.
  • The & operator does the same: =A2&" "&B2

Related functions

More formula guides

More tools

About CONCAT Function

Joins several pieces of text or cells into one text. It replaces the older CONCATENATE and accepts ranges.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use CONCAT Function

  1. Type the formulaStart typing =CONCAT( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is CONCAT in Turkish Excel?

In Turkish Excel, CONCAT is called ARALIKBİRLEŞTİR. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have CONCAT?

CONCAT is available in Excel 2019 and Microsoft 365.