{"id":15656,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yerinekoy\/"},"modified":"2021-02-25T16:36:50","modified_gmt":"2021-02-25T16:36:50","slug":"substitute","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/substitute\/","title":{"rendered":"YER\u0130NEKOY"},"content":{"rendered":"

Nedir YER\u0130NEKOY Fonksiyonu?<\/h2>\n

SUBSTITUTE<\/code> fonksiyonu, bilinen ad\u0131yla Excel ve Google Sheets’te YER\u0130NEKOY<\/code>, bir metin dizisinde belirli bir alt metni farkl\u0131 bir metinle de\u011fi\u015ftirmek amac\u0131yla kullan\u0131l\u0131r. Bu fonksiyon, belirli bir kelimeyi veya metin dizisini ba\u015fka bir metinle de\u011fi\u015ftirmenize olanak sa\u011flar ve b\u00fcy\u00fck veri metinleri \u00fczerinde kelimeleri de\u011fi\u015ftirme veya d\u00fczenleme gibi i\u015flemleri kolayla\u015ft\u0131r\u0131r.<\/p>\n

Fonksiyon S\u00f6zdizimi ve Parametreleri<\/h2>\n

YER\u0130NEKOY fonksiyonunun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

YER\u0130NEKOY(metin, eski_metin, yeni_metin, [n])<\/code><\/pre>\n
    \n
  • metin<\/strong>: De\u011fi\u015fiklik yap\u0131lacak olan orijinal metindir.<\/li>\n
  • eski_metin<\/strong>: Metinde de\u011fi\u015ftirilecek metin par\u00e7as\u0131d\u0131r.<\/li>\n
  • yeni_metin<\/strong>: Eski metnin yerine konulacak yeni metindir.<\/li>\n
  • n<\/strong> (iste\u011fe ba\u011fl\u0131): Eski metnin, metin i\u00e7inde ka\u00e7\u0131nc\u0131 kez g\u00f6r\u00fcld\u00fc\u011f\u00fc yerde de\u011fi\u015ftirilece\u011fini belirtir. Bu parametre belirtilmezse, fonksiyon metin i\u00e7indeki t\u00fcm eski metin \u00f6rneklerini yeni metinle de\u011fi\u015ftirir.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =YER\u0130NEKOY(\"merhaba d\u00fcnya\", \"d\u00fcnya\", \"herkes\", 1)<\/code><\/pre>\n
    Bu \u00f6rnekte, “merhaba d\u00fcnya” metninde “d\u00fcnya” yerine “herkes” konularak sonu\u00e7 “merhaba herkes”<\/strong> olarak ger\u00e7ekle\u015fir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    1. Raporlarda Kelime De\u011fi\u015ftirmek<\/h2>\n
    Farkl\u0131 zaman dilimlerine ait sat\u0131\u015f raporlar\u0131n\u0131zda eski tarihleri yeni tarihlerle g\u00fcncellemek gerekebilir. \u00d6rne\u011fin, bir tekstil firmas\u0131n\u0131n 2021 y\u0131l\u0131na ait “2021 y\u0131l\u0131 sat\u0131\u015f raporu” adl\u0131 bir dok\u00fcman\u0131 2022 y\u0131l\u0131 i\u00e7in yenilemesi gerekmektedir:<\/p>\n
    =YER\u0130NEKOY(\"2021 y\u0131l\u0131 sat\u0131\u015f raporu\", \"2021\", \"2022\")<\/code><\/pre>\n
    Bu i\u015flem, t\u00fcm “2021” metinlerini “2022” ile de\u011fi\u015ftirerek dok\u00fcman\u0131 “2022 y\u0131l\u0131 sat\u0131\u015f raporu” olarak g\u00fcnceller.<\/p>\n
    2. E-posta \u015eablonu G\u00fcncellemek<\/h2>\n
    Mevcut bir e-posta \u015fablonunda, her yeni y\u0131l ba\u015f\u0131nda y\u0131l say\u0131s\u0131n\u0131 otomatik olarak g\u00fcncellemek isteyebilirsiniz. Y\u0131l de\u011ferini dinamik bir \u015fekilde g\u00fcncellemek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<\/p>\n
    =YER\u0130NEKOY(\"Ho\u015f geldiniz! 2021 y\u0131l\u0131n\u0131n harika ge\u00e7mesini dileriz.\", \"2021\", TEXT(TODAY(), \"YYYY\"))<\/code><\/pre>\n
    Bu form\u00fcl, metindeki “2021” metnini i\u00e7inde bulundu\u011funuz y\u0131l\u0131n de\u011feriyle de\u011fi\u015ftirecektir. \u00d6rne\u011fin, 2023 y\u0131l\u0131nda kullan\u0131ld\u0131\u011f\u0131nda sonu\u00e7 “Ho\u015f geldiniz! 2023 y\u0131l\u0131n\u0131n harika ge\u00e7mesini dileriz.”<\/strong> \u015feklinde olacakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metin dizesinde, eski metnin yerine yeni metin koyar<\/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-15656","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de SUBSTITUTE (YER\u0130NEKOY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUBSTITUTE (YER\u0130NEKOY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:36:50+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 SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/substitute\/\",\"name\":\"Excel'de SUBSTITUTE (YER\u0130NEKOY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:36:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/substitute\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/substitute\/#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\":\"YER\u0130NEKOY\"}]},{\"@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 SUBSTITUTE (YER\u0130NEKOY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUBSTITUTE (YER\u0130NEKOY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:36:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/","url":"https:\/\/functiontranslator.com\/tr\/substitute\/","name":"Excel'de SUBSTITUTE (YER\u0130NEKOY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:36:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUBSTITUTE (YER\u0130NEKOY) 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\/substitute\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/substitute\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/substitute\/#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":"YER\u0130NEKOY"}]},{"@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\/15656","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=15656"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15656\/revisions"}],"predecessor-version":[{"id":26924,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15656\/revisions\/26924"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}