{"id":15502,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/emetinse\/"},"modified":"2021-02-25T16:30:04","modified_gmt":"2021-02-25T16:30:04","slug":"istext","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/istext\/","title":{"rendered":"EMET\u0130NSE"},"content":{"rendered":"

ISTEXT<\/code> (T\u00fcrk\u00e7e’de EMET\u0130NSE<\/code>) fonksiyonu, belirtilen h\u00fccre veya de\u011ferin metin (string) olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer h\u00fccredeki de\u011fer metin t\u00fcr\u00fcndeyse TRUE (DO\u011eRU), de\u011filse FALSE (YANLI\u015e) de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr. Bu fonksiyon, veri t\u00fcrlerini analiz ederken ve metin tabanl\u0131 i\u015flemler yaparken ko\u015fullar olu\u015fturmak i\u00e7in kullan\u0131lmaktad\u0131r.<\/p>\n

EMET\u0130NSE Fonksiyonun S\u00f6zdizimi<\/h2>\n

EMET\u0130NSE<\/code> fonksiyonunun s\u00f6zdizimi olduk\u00e7a basittir:<\/p>\n

=EMET\u0130NSE(de\u011fer)<\/code><\/pre>\n
    \n
  • de\u011fer<\/strong>: Test edilecek h\u00fccre, alan veya de\u011fer.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m:<\/strong><\/p>\n
    =EMET\u0130NSE(A1)<\/code><\/pre>\n
    E\u011fer A1 h\u00fccresi metin i\u00e7eriyorsa, bu form\u00fcl DO\u011eRU d\u00f6ner.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    EMET\u0130NSE<\/code> fonksiyonu, veri setlerini d\u00fczenlerken ve metin i\u00e7eren h\u00fccreleri belirlemek i\u00e7in m\u00fckemmeldir. \u0130\u015fte iki pratik kullan\u0131m \u00f6rne\u011fi:<\/p>\n
    \u00d6rnek 1: Metin \u0130\u00e7eren H\u00fccreleri Sayma<\/h2>\n
    Bir h\u00fccre aral\u0131\u011f\u0131ndaki metin de\u011ferlerinin say\u0131s\u0131n\u0131 hesaplamak i\u00e7in \u015fu ad\u0131mlar\u0131 izleyin:<\/p>\n
      \n
    • Veri aral\u0131\u011f\u0131n\u0131z A1:A10 olsun.<\/li>\n
    • Aral\u0131ktaki metin h\u00fccrelerinin say\u0131s\u0131n\u0131 hesaplamak i\u00e7in SAY<\/code> ve EMET\u0130NSE<\/code> fonksiyonlar\u0131n\u0131 birle\u015ftirebilirsiniz:<\/li>\n<\/ul>\n
      =SAY.E\u011eERD\u0130Z\u0130(A1:A10, EMET\u0130NSE(A1:A10))<\/code><\/pre>\n
      Bu form\u00fcl, A1:A10 aral\u0131\u011f\u0131nda metin i\u00e7eren h\u00fccre say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n
      \u00d6rnek 2: Metin \u0130\u00e7eren H\u00fccreleri Filtreleme<\/h2>\n
      E\u011fer b\u00fcy\u00fck bir veri setinden sadece metin i\u00e7eren h\u00fccreleri se\u00e7mek istiyorsan\u0131z:<\/p>\n
        \n
      • A s\u00fctununuz \u00e7e\u015fitli veri t\u00fcrlerini i\u00e7eriyor olsun.<\/li>\n
      • Yeni bir B s\u00fctunu olu\u015fturun ve ilk h\u00fccreye (B1) a\u015fa\u011f\u0131daki form\u00fcl\u00fc uygulay\u0131n:<\/li>\n<\/ul>\n
        =E\u011eER(EMET\u0130NSE(A1), A1, \"\")<\/code><\/pre>\n
          \n
        • Bu form\u00fcl, A s\u00fctunundaki her h\u00fccre i\u00e7in, e\u011fer h\u00fccre metin ise de\u011feri B s\u00fctununa aktar\u0131r, de\u011filse o h\u00fccreyi bo\u015f b\u0131rak\u0131r.<\/li>\n
        • Bu i\u015flemi B s\u00fctunundaki di\u011fer h\u00fccrelere uygulayarak devam edebilirsiniz.<\/li>\n<\/ul>\n
          Bu \u00f6rnekler, EMET\u0130NSE<\/code> fonksiyonunun i\u015f s\u00fcre\u00e7lerinizi nas\u0131l kolayla\u015ft\u0131rabilece\u011fini ve veri analizi i\u015flemlerinizi nas\u0131l iyile\u015ftirebilece\u011fini g\u00f6stermektedir. Bu fonksiyon sayesinde metin verileri \u00fczerinde daha verimli analizler ve i\u015flemler yapabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
          De\u011fer bir metinse, DO\u011eRU verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[586],"tags":[],"class_list":["post-15502","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISTEXT (EMET\u0130NSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISTEXT (EMET\u0130NSE) 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\/istext\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISTEXT (EMET\u0130NSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISTEXT (EMET\u0130NSE) 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\/istext\/\" \/>\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:30:04+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 ISTEXT (EMET\u0130NSE) 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\/istext\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/istext\/\",\"name\":\"Excel'de ISTEXT (EMET\u0130NSE) 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:30:04+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISTEXT (EMET\u0130NSE) 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\/istext\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/istext\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/istext\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bilgi\",\"item\":\"https:\/\/functiontranslator.com\/tr\/bilgi\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EMET\u0130NSE\"}]},{\"@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 ISTEXT (EMET\u0130NSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISTEXT (EMET\u0130NSE) 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\/istext\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISTEXT (EMET\u0130NSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISTEXT (EMET\u0130NSE) 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\/istext\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:30:04+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISTEXT (EMET\u0130NSE) 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\/istext\/","url":"https:\/\/functiontranslator.com\/tr\/istext\/","name":"Excel'de ISTEXT (EMET\u0130NSE) 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:30:04+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISTEXT (EMET\u0130NSE) 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\/istext\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/istext\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/istext\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Bilgi","item":"https:\/\/functiontranslator.com\/tr\/bilgi\/"},{"@type":"ListItem","position":3,"name":"EMET\u0130NSE"}]},{"@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\/15502","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=15502"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15502\/revisions"}],"predecessor-version":[{"id":26770,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15502\/revisions\/26770"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}