{"id":4106,"date":"2023-07-13T13:45:49","date_gmt":"2023-07-13T13:45:49","guid":{"rendered":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/"},"modified":"2023-07-13T13:45:49","modified_gmt":"2023-07-13T13:45:49","slug":"ozel-karakterler-icin-excel-aramasi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/","title":{"rendered":"Excel&#39;de bir h\u00fccredeki \u00f6zel karakterler nas\u0131l bulunur?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Excel&#8217;deki belirli bir h\u00fccrenin, h\u00fccrenin herhangi bir yerinde \u00f6zel karakterler i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>=SUMPRODUCT(--ISNUMBER(SEARCH({\"!\",\"#\",\"$\",\"%\",\"(\",\")\",\"^\",\"@\",\"[\",\"]\", \"{\",\"}\"}, <span style=\"color: #3366ff;\">A2<\/span> )))&gt;0\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel form\u00fcl, <strong>A2<\/strong> h\u00fccresinin herhangi bir \u00f6zel karakter i\u00e7erip i\u00e7ermedi\u011fini kontrol eder ve i\u00e7eriyorsa <strong>DO\u011eRU<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Aksi takdirde <strong>FALSE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">\u00d6rnek: Excel&#8217;de H\u00fccredeki \u00d6zel Karakterleri Bulma<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de a\u015fa\u011f\u0131daki ifade listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32635 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/special1.png\" alt=\"\" width=\"527\" height=\"459\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u00d6zel bir karakter i\u00e7erip i\u00e7ermedi\u011fini belirlemek i\u00e7in A s\u00fctunundaki her c\u00fcmleyi aramak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in <strong>B2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>=SUMPRODUCT(--ISNUMBER(SEARCH({\"!\",\"#\",\"$\",\"%\",\"(\",\")\",\"^\",\"@\",\"[\",\"]\", \"{\",\"}\"}, <span style=\"color: #3366ff;\">A2<\/span> )))&gt;0<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32636\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/special2.png\" alt=\"H\u00fccredeki \u00f6zel karakterleri Excel'de arama\" width=\"598\" height=\"497\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">C\u00fcmle \u00f6zel bir karakter i\u00e7eriyorsa form\u00fcl <strong>TRUE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Aksi takdirde, \u00f6zel karakter bulunamazsa <strong>FALSE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin \u015funlar\u0131 g\u00f6rebiliriz:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u0130lk c\u00fcmle en az bir \u00f6zel karakter i\u00e7eriyor.<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u0130kinci c\u00fcmle herhangi bir \u00f6zel karakter i\u00e7ermiyor.<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u00dc\u00e7\u00fcnc\u00fc c\u00fcmle en az bir \u00f6zel karakter i\u00e7eriyor.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ve benzeri.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fcn en yayg\u0131n \u00f6zel karakterleri i\u00e7erdi\u011fini unutmay\u0131n; ancak di\u011fer \u00f6zel karakterleri aramak istiyorsan\u0131z form\u00fcle <strong>SEARCH()<\/strong> i\u015flevindeki karakterleri eklemeniz yeterlidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ayr\u0131ca isterseniz yaln\u0131zca belirli \u00f6zel karakterleri aramay\u0131 se\u00e7ebilece\u011finizi de unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, h\u00fccrelerde yaln\u0131zca dolar i\u015faretini veya y\u00fczde i\u015fareti aramak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--ISNUMBER(SEARCH({\"$\",\"%\"}, <span style=\"color: #3366ff;\">A2<\/span> )))&gt;0<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu form\u00fcl, belirli bir h\u00fccrede bir dolar i\u015fareti ($) veya y\u00fczde i\u015fareti (%) alg\u0131lan\u0131rsa <strong>DO\u011eRU de\u011ferini<\/strong> , hi\u00e7bir karakter alg\u0131lanmazsa <strong>YANLI\u015e<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/excel-arama-yildizi\/\">Excel&#8217;de bir h\u00fccrede y\u0131ld\u0131z i\u015fareti nas\u0131l bulunur?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-soru-isareti-arama\/\">Excel&#8217;de Soru \u0130\u015fareti Nas\u0131l Bulunur?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-birden-fazla-sutunda-benzersiz-degerler-bulma\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de birden \u00e7ok s\u00fctundan benzersiz de\u011ferler nas\u0131l bulunur?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;deki belirli bir h\u00fccrenin, h\u00fccrenin herhangi bir yerinde \u00f6zel karakterler i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =SUMPRODUCT(&#8211;ISNUMBER(SEARCH({&#8220;!&#8221;,&#8221;#&#8221;,&#8221;$&#8221;,&#8221;%&#8221;,&#8221;(&#8220;,&#8221;)&#8221;,&#8221;^&#8221;,&#8221;@&#8221;,&#8221;[&#8220;,&#8221;]&#8221;, &#8220;{&#8220;,&#8221;}&#8221;}, A2 )))&gt;0 Bu \u00f6zel form\u00fcl, A2 h\u00fccresinin herhangi bir \u00f6zel karakter i\u00e7erip i\u00e7ermedi\u011fini kontrol eder ve i\u00e7eriyorsa DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr. Aksi takdirde FALSE de\u011ferini d\u00f6nd\u00fcr\u00fcr. A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir. \u00d6rnek: Excel&#8217;de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4106","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de Bir H\u00fccredeki \u00d6zel Karakterler Nas\u0131l Bulunur \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;deki bir h\u00fccredeki \u00f6zel karakterlerin nas\u0131l bulunaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Bir H\u00fccredeki \u00d6zel Karakterler Nas\u0131l Bulunur \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;deki bir h\u00fccredeki \u00f6zel karakterlerin nas\u0131l bulunaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T13:45:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/special1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\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:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/\",\"url\":\"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/\",\"name\":\"Excel&#39;de Bir H\u00fccredeki \u00d6zel Karakterler Nas\u0131l Bulunur \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-13T13:45:49+00:00\",\"dateModified\":\"2023-07-13T13:45:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir h\u00fccredeki \u00f6zel karakterlerin nas\u0131l bulunaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de bir h\u00fccredeki \u00f6zel karakterler nas\u0131l bulunur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de Bir H\u00fccredeki \u00d6zel Karakterler Nas\u0131l Bulunur \u2013 Statorials","description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir h\u00fccredeki \u00f6zel karakterlerin nas\u0131l bulunaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Bir H\u00fccredeki \u00d6zel Karakterler Nas\u0131l Bulunur \u2013 Statorials","og_description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir h\u00fccredeki \u00f6zel karakterlerin nas\u0131l bulunaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/","og_site_name":"Statorials","article_published_time":"2023-07-13T13:45:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/special1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/","url":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/","name":"Excel&#39;de Bir H\u00fccredeki \u00d6zel Karakterler Nas\u0131l Bulunur \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-13T13:45:49+00:00","dateModified":"2023-07-13T13:45:49+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir h\u00fccredeki \u00f6zel karakterlerin nas\u0131l bulunaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/ozel-karakterler-icin-excel-aramasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de bir h\u00fccredeki \u00f6zel karakterler nas\u0131l bulunur?"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4106"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4106\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}