{"id":15628,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/mbul-arab-islevleri\/"},"modified":"2021-03-01T16:47:15","modified_gmt":"2021-03-01T16:47:15","slug":"search-searchbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/search-searchbs\/","title":{"rendered":"MBUL, ARAB"},"content":{"rendered":"

Microsoft Excel ve Google Sheets metin ve veri analizi konusunda kapsaml\u0131 ara\u00e7lar sa\u011flar. Bu ara\u00e7lardan SEARCH<\/code> ve SEARCHB<\/code> (MBUL ve ARAB olarak da bilinir) fonksiyonlar\u0131, metin i\u00e7inde belirli bir alt metni bulmay\u0131 kolayla\u015ft\u0131r\u0131r. Bu fonksiyonlar, bir metin dizgisinde arad\u0131\u011f\u0131n\u0131z metin par\u00e7as\u0131n\u0131n ilk olarak ba\u015flad\u0131\u011f\u0131 yerin konumunu d\u00f6nd\u00fcr\u00fcr. A\u015fa\u011f\u0131da bu fonksiyonlar\u0131n kullan\u0131m\u0131na dair detaylar ve pratik \u00f6rnekler yer almaktad\u0131r.<\/p>\n

SEARCH ve SEARCHB Fonksiyonlar\u0131n\u0131n S\u00f6zdizimi<\/h2>\n

SEARCH<\/code> fonksiyonunun genel s\u00f6zdizimi:<\/p>\n

  =SEARCH(aranan_metin, metin, [ba\u015flang\u0131\u00e7_noktas\u0131]) <\/code> <\/pre>\n
    \n
  • aranan_metin<\/strong>: Metin i\u00e7inde aranacak alt metni belirtir.<\/li>\n
  • metin<\/strong>: Araman\u0131n yap\u0131laca\u011f\u0131 ana metin dizgisidir.<\/li>\n
  • ba\u015flang\u0131\u00e7_noktas\u0131<\/strong>: Opsiyonel. Araman\u0131n ba\u015flayaca\u011f\u0131 konumu belirtir. E\u011fer bu de\u011fer belirtilmezse, varsay\u0131lan olarak 1 kabul edilir, yani metnin ba\u015f\u0131ndan itibaren arama yap\u0131l\u0131r.<\/li>\n<\/ul>\n
    SEARCHB<\/code> fonksiyonu temelde ayn\u0131 ama\u00e7la kullan\u0131l\u0131r ancak \u00c7ift Baytl\u0131k Karakter Seti (DBCS) kullanan dil sistemleri i\u00e7in \u00f6nerilir (\u00f6rne\u011fin Japonca).<\/p>\n
    \u00d6rnek Kullan\u0131m<\/h2>\n
      =SEARCH(\"elma\", \"masada bir elma var\") \/\/ \u00c7\u0131kt\u0131: 11 =SEARCH(\"el\", \"kelime\", 3) \/\/ \u00c7\u0131kt\u0131: 3 <\/code> <\/pre>\n
    \u0130lk \u00f6rnekte, “elma” kelimesinin “masada bir elma var” metni i\u00e7indeki ba\u015flang\u0131\u00e7 konumu 11 olarak belirlenir. \u0130kinci \u00f6rnekte, “kelime” i\u00e7inde 3. konumdan itibaren “el” dizgisi arand\u0131\u011f\u0131nda, ilk bulundu\u011fu konum olarak 3 d\u00f6ner.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    Uygulama: Dosya Adlar\u0131nda Belirli Bir Uzant\u0131y\u0131 Bulmak<\/h2>\n
    Bir s\u00fctunda bulunan .jpg, .png ve .gif gibi farkl\u0131 dosya uzant\u0131lar\u0131 i\u00e7eren dosya adlar\u0131n\u0131 s\u0131n\u0131fland\u0131rmak i\u00e7in SEARCH<\/code> fonksiyonu kullan\u0131labilir. Diyelim ki, sadece .png uzant\u0131l\u0131 dosyalar\u0131 bulmak istiyorsunuz.<\/p>\n
      =SEARCH(\".png\", A1) <\/code> <\/pre>\n
    E\u011fer arama sonucu hata verirse (yani “.png” bulunamazsa), bir IF fonksiyonu ile y\u00f6netebilirsiniz:<\/p>\n
      =IF(ISERROR(SEARCH(\".png\", A1)), \"PNG de\u011fil\", \"PNG\") <\/code> <\/pre>\n
    Bu y\u00f6ntemle, t\u00fcm liste boyunca kolayca filtreleme yapabilirsiniz.<\/p>\n
    Uygulama: E-posta Adresindeki Domain’i Bulmak<\/h2>\n
    Bir email listesi i\u00e7erisindeki her bir email adresinin domain b\u00f6l\u00fcm\u00fcn\u00fc (“@gmail.com” gibi) ay\u0131rmak i\u00e7in SEARCH<\/code> fonksiyonunu kullanabilirsiniz.<\/p>\n
      =MID(A1, SEARCH(\"@\", A1) + 1, LEN(A1) - SEARCH(\"@\", A1)) <\/code> <\/pre>\n
    Burada MID<\/code> ve LEN<\/code> fonksiyonlar\u0131yla, “@” i\u015faretinden sonra ba\u015flayan t\u00fcm karakterler al\u0131n\u0131r. Bu y\u00f6ntem, email adreslerinin domain b\u00f6l\u00fcmlerini ay\u0131rmak i\u00e7in etkili bir \u00e7\u00f6z\u00fcm sunar.<\/p>\n
    G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, SEARCH<\/code> ve SEARCHB<\/code> fonksiyonlar\u0131, metin i\u015fleme ve belirli bilgileri \u00e7ekme i\u015flemlerinde Excel ve Google Sheets kullan\u0131c\u0131lar\u0131 i\u00e7in b\u00fcy\u00fck kolayl\u0131klar sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metin de\u011ferini, bir ba\u015fkas\u0131n\u0131n i\u00e7inde bulur (b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 de\u011fildir)<\/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-15628","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de SEARCH, SEARCHBs (MBUL, ARAB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SEARCH, SEARCHBs (MBUL, ARAB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/\" \/>\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-03-01T16:47:15+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 SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/search-searchbs\/\",\"name\":\"Excel'de SEARCH, SEARCHBs (MBUL, ARAB) 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-03-01T16:47:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/search-searchbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/search-searchbs\/#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\":\"MBUL, ARAB\"}]},{\"@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 SEARCH, SEARCHBs (MBUL, ARAB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SEARCH, SEARCHBs (MBUL, ARAB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-03-01T16:47:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/","url":"https:\/\/functiontranslator.com\/tr\/search-searchbs\/","name":"Excel'de SEARCH, SEARCHBs (MBUL, ARAB) 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-03-01T16:47:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SEARCH, SEARCHBs (MBUL, ARAB) 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\/search-searchbs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/search-searchbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/search-searchbs\/#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":"MBUL, ARAB"}]},{"@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\/15628","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=15628"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15628\/revisions"}],"predecessor-version":[{"id":32545,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15628\/revisions\/32545"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}