{"id":15679,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/metinbirlestir\/"},"modified":"2021-02-25T16:37:36","modified_gmt":"2021-02-25T16:37:36","slug":"textjoin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/textjoin\/","title":{"rendered":"Metinbirle\u015ftir"},"content":{"rendered":"

Fonksiyon \u00d6zellikleri ve Kullan\u0131m\u0131: TEXTJOIN (Metinbirle\u015ftir)<\/h2>\n

TEXTJOIN, yani T\u00fcrk\u00e7e ad\u0131yla Metinbirle\u015ftir, Microsoft Excel ve Google Sheets’te bulunan ve farkl\u0131 h\u00fccrelerdeki metinleri belirledi\u011finiz bir ay\u0131r\u0131c\u0131 ile birle\u015ftirerek yeni bir metin stringi olu\u015fturman\u0131za olanak sa\u011flayan bir fonksiyondur. Bu fonksiyon, veri i\u015fleme ve d\u00fczenleme i\u015flemlerinde olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n

S\u00f6z dizimi ve Parametreler<\/h2>\n

TEXTJOIN fonksiyonunun genel yap\u0131land\u0131rmas\u0131 a\u015fa\u011f\u0131da belirtilmi\u015ftir:<\/p>\n

TEXTJOIN(ay\u0131r\u0131c\u0131, metinleri_yoksay, metin1, [metin2], ...)<\/code><\/pre>\n
    \n
  • ay\u0131r\u0131c\u0131<\/strong>: Metinler aras\u0131na eklenecek ay\u0131r\u0131c\u0131 karakterler. E\u011fer bo\u015f metin (“”) kullan\u0131l\u0131rsa, metinler aras\u0131na hi\u00e7bir karakter eklenmeyecektir.<\/li>\n
  • metinleri_yoksay<\/strong>: Bo\u015f h\u00fccrelerin birle\u015ftirme i\u015flemi s\u0131ras\u0131nda dikkate al\u0131n\u0131p al\u0131nmamas\u0131 gerekti\u011fini belirten Boolean (TRUE\/FALSE) de\u011feri.<\/li>\n
  • metin1, metin2, …<\/strong>: Birle\u015ftirilecek olan metinler. \u0130lk metin zorunlu olup, ard\u0131ndan gelen metinler iste\u011fe ba\u011fl\u0131 olarak eklenir.<\/li>\n<\/ul>\n
    Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Ad ve Soyad Birle\u015ftirme<\/p>\n
    Diyelim ki, bir ki\u015finin ad\u0131n\u0131 ve soyad\u0131n\u0131 i\u00e7eren iki ayr\u0131 s\u00fctununuz var. Bu s\u00fctunlar\u0131 birle\u015ftirerek ki\u015finin tam ad\u0131n\u0131 olu\u015fturmak istiyorsunuz:<\/p>\n
    =TEXTJOIN(\" \", TRUE, A2, B2)<\/code><\/pre>\n
    Bu form\u00fcl, A2 h\u00fccresindeki ad\u0131 ve B2 h\u00fccresindeki soyad\u0131 aras\u0131na bir bo\u015fluk koyarak birle\u015ftirir.<\/p>\n
    \u00d6rnek 2: E-posta Listesi Olu\u015fturma<\/p>\n
    Bir etkinlik i\u00e7in kat\u0131l\u0131mc\u0131lar\u0131n e-posta adreslerini tek bir h\u00fccrede virg\u00fclle ayr\u0131lm\u0131\u015f \u015fekilde birle\u015ftirmek isteyebilirsiniz:<\/p>\n
    =TEXTJOIN(\", \", TRUE, A2:A100)<\/code><\/pre>\n
    Bu form\u00fcl, A2’den A100’e kadar olan h\u00fccrelerdeki e-posta adreslerini “, ” ay\u0131r\u0131c\u0131s\u0131 kullanarak birle\u015ftirir ve bo\u015f h\u00fccreler g\u00f6z ard\u0131 edilir.<\/p>\n\n\n\n\n
    Kullan\u0131m Senaryosu<\/th>\nForm\u00fcl<\/th>\n<\/tr>\n
    Ad ve Soyad Birle\u015ftirme<\/td>\n=TEXTJOIN(” “, TRUE, A2, B2)<\/td>\n<\/tr>\n
    E-posta Listesi<\/td>\n=TEXTJOIN(“, “, TRUE, A2:A100)<\/td>\n<\/tr>\n<\/table>\n
    Pratik Uygulamalar ve Farkl\u0131 Durumlar<\/h2>\n
    TEXTJOIN fonksiyonu, veri birle\u015ftirme ve d\u00fczenli raporlar olu\u015fturma gibi durumlarda olduk\u00e7a i\u015fe yarar. \u00d6zellikle, farkl\u0131 bilgileri i\u00e7eren h\u00fccrelerden tek bir h\u00fccrede toplu bilgi sunumu yapmak istedi\u011finiz zamanlar i\u00e7in idealdir. Ayr\u0131ca, bo\u015f h\u00fccrelerin fonksiyona dahil edilip edilmemesini iste\u011fe ba\u011fl\u0131 olarak ayarlayabilirsiniz.<\/p>\n
    B\u00fcy\u00fck veri listeleri ile \u00e7al\u0131\u015f\u0131rken, TEXTJOIN fonksiyonunu kullanarak veri entegrasyonu ve analiz i\u015flemleri yapabilirsiniz. Data temizleme s\u00fcre\u00e7lerinde bo\u015f h\u00fccreleri yok sayarak sadece gereksinim duyulan verilerin i\u015flenmesi, fonksiyonun sunmu\u015f oldu\u011fu avantajlardan biridir.<\/p>\n
    Her kullan\u0131m senaryosu ve veri yap\u0131s\u0131 farkl\u0131 oldu\u011fundan, TEXTJOIN fonksiyonunun esnekli\u011fi, \u00e7e\u015fitli ihtiya\u00e7lara cevap verme potansiyeline sahiptir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Birden \u00e7ok aral\u0131k ve\/veya dizedeki metinleri birle\u015ftirir ve birle\u015ftirilen her metin de\u011feri aras\u0131na belirtti\u011finiz bir s\u0131n\u0131rlay\u0131c\u0131y\u0131 ekler S\u0131n\u0131rlay\u0131c\u0131 bo\u015f bir metin dizesi ise, bu i\u015flev sonucunda aral\u0131klar s\u0131n\u0131rlay\u0131c\u0131 olmadan birle\u015ftirilir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[581],"tags":[],"class_list":["post-15679","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TEXTJOIN (Metinbirle\u015ftir) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/textjoin\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TEXTJOIN (Metinbirle\u015ftir) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/textjoin\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:37:36+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/textjoin\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/textjoin\/\",\"name\":\"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:37:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TEXTJOIN (Metinbirle\u015ftir) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/textjoin\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/textjoin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/textjoin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Metin\",\"item\":\"https:\/\/functiontranslator.com\/tr\/metin\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Metinbirle\u015ftir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TEXTJOIN (Metinbirle\u015ftir) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/tr\/textjoin\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TEXTJOIN (Metinbirle\u015ftir) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/textjoin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/textjoin\/","url":"https:\/\/functiontranslator.com\/tr\/textjoin\/","name":"Excel'de TEXTJOIN (Metinbirle\u015ftir) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:37:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TEXTJOIN (Metinbirle\u015ftir) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/textjoin\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/textjoin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/textjoin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Metin","item":"https:\/\/functiontranslator.com\/tr\/metin\/"},{"@type":"ListItem","position":3,"name":"Metinbirle\u015ftir"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15679"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15679\/revisions"}],"predecessor-version":[{"id":27065,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15679\/revisions\/27065"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}