Excel TEXTJOIN Function: How to Use It, with Examples
Turkish: METİNBİRLEŞTİR

Joins the text in a range with a separator you choose and can skip empty cells.

TEXTJOIN syntax

=TEXTJOIN(delimiter, ignore_empty, text1)

In Turkish Excel: =METİNBİRLEŞTİR(sınırlayıcı; boşları_yoksay; metin1)

ArgumentDescription
delimiterText to put between items (e.g. ", ").
ignore_emptyTRUE skips empty cells.
text1The range or text to join.

TEXTJOIN examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=TEXTJOIN(", ",TRUE,A2:A4)
Result: Pen, Notebook, Eraser

Joins the first three products with commas.

Results were calculated in real Excel.

Related functions

More formula guides

More tools

About TEXTJOIN Function

Joins the text in a range with a separator you choose and can skip empty cells.

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 TEXTJOIN Function

  1. Type the formulaStart typing =TEXTJOIN( 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 TEXTJOIN in Turkish Excel?

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

Which Excel versions have TEXTJOIN?

TEXTJOIN is available in Excel 2019 and Microsoft 365.