{"id":4653,"date":"2023-07-09T07:01:57","date_gmt":"2023-07-09T07:01:57","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-dogru-arama\/"},"modified":"2023-07-09T07:01:57","modified_gmt":"2023-07-09T07:01:57","slug":"excel-dogru-arama","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-dogru-arama\/","title":{"rendered":"Excel: sa\u011fdan bir dize nas\u0131l bulunur?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Excel&#8217;de sa\u011fdan ba\u015flayarak bir dize bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TRIM(RIGHT(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> , \" \", REPT(\" \", 100)), 100))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel form\u00fcl, <strong>A2<\/strong> h\u00fccresindeki dizenin son s\u00f6zc\u00fc\u011f\u00fcn\u00fc bulur.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu form\u00fcl, dizedeki her bir bo\u015flu\u011fu 100 bo\u015flukla de\u011fi\u015ftirerek, ard\u0131ndan dizenin son 100 karakterini ba\u015ftaki ve sondaki bo\u015fluklar kald\u0131r\u0131lm\u0131\u015f \u015fekilde d\u00f6nd\u00fcrerek \u00e7al\u0131\u015f\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sonu\u00e7 olarak, bu form\u00fcl yaln\u0131zca bir dizenin son s\u00f6zc\u00fc\u011f\u00fcn\u00fc 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> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de Sa\u011fdan Bir Dize Nas\u0131l Bulunur?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de a\u015fa\u011f\u0131daki dize s\u00fctununa sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36293 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sr1.png\" alt=\"\" width=\"456\" height=\"422\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>A2<\/strong> h\u00fccresindeki dizenin son kelimesini bulmak 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: 17px;\"> <strong>=TRIM(RIGHT(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> , \" \", REPT(\" \", 100)), 100))<\/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-36294\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sr2.png\" alt=\"Sa\u011fdan Excel aramas\u0131\" width=\"604\" height=\"454\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">B s\u00fctunu, A s\u00fctunundaki her dizenin son s\u00f6zc\u00fc\u011f\u00fcn\u00fc g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dizelerinizde bo\u015fluktan ba\u015fka bir s\u0131n\u0131rlay\u0131c\u0131 varsa, bu s\u0131n\u0131rlay\u0131c\u0131y\u0131 <strong>SUBSTITUTE<\/strong> i\u015flevinde belirtmeniz yeterlidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, dizelerimizin her birinde s\u0131n\u0131rlay\u0131c\u0131 olarak bo\u015fluk yerine e\u011fik \u00e7izgi bulundu\u011funu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sr3.png\" alt=\"\" width=\"477\" height=\"413\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>A2<\/strong> h\u00fccresindeki dizenin son kelimesini bulmak i\u00e7in <b>B2<\/b> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TRIM(RIGHT(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> , \"\/\", REPT(\" \", 100)), 100))<\/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=\" wp-image-36295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sr4.png\" alt=\"\" width=\"604\" height=\"420\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">B s\u00fctunu, A s\u00fctununun dizelerindeki son e\u011fik \u00e7izgiden sonraki son s\u00f6zc\u00fc\u011f\u00fc g\u00f6r\u00fcnt\u00fcler.<\/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-hucreden-belirli-bir-metni-sil\/\" target=\"_blank\" rel=\"noopener\">Excel: Belirli bir metin h\u00fccrelerden nas\u0131l kald\u0131r\u0131l\u0131r<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-son-3-karakteri-sil\/\" target=\"_blank\" rel=\"noopener\">Excel: Bir dizeden son 3 karakter nas\u0131l kald\u0131r\u0131l\u0131r<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-bir-dizeye-bir-karakter-ekleme\/\" target=\"_blank\" rel=\"noopener\">Excel: Bir dizeye karakter nas\u0131l eklenir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;de sa\u011fdan ba\u015flayarak bir dize bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =TRIM(RIGHT(SUBSTITUTE( A2 , &#8221; &#8220;, REPT(&#8221; &#8220;, 100)), 100)) Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dizenin son s\u00f6zc\u00fc\u011f\u00fcn\u00fc bulur. Bu form\u00fcl, dizedeki her bir bo\u015flu\u011fu 100 bo\u015flukla de\u011fi\u015ftirerek, ard\u0131ndan dizenin son 100 karakterini ba\u015ftaki ve sondaki bo\u015fluklar kald\u0131r\u0131lm\u0131\u015f \u015fekilde d\u00f6nd\u00fcrerek \u00e7al\u0131\u015f\u0131r. Sonu\u00e7 olarak, bu form\u00fcl yaln\u0131zca [&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-4653","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: Sa\u011fdan Bir Dize Nas\u0131l Bulunur?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;de sa\u011fdan bir dizenin nas\u0131l aranaca\u011f\u0131 bir \u00f6rnekle 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\/excel-dogru-arama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Sa\u011fdan Bir Dize Nas\u0131l Bulunur?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;de sa\u011fdan bir dizenin nas\u0131l aranaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-dogru-arama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T07:01:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sr1.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\/excel-dogru-arama\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-dogru-arama\/\",\"name\":\"Excel: Sa\u011fdan Bir Dize Nas\u0131l Bulunur?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-09T07:01:57+00:00\",\"dateModified\":\"2023-07-09T07:01:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;de sa\u011fdan bir dizenin nas\u0131l aranaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-dogru-arama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-dogru-arama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-dogru-arama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: sa\u011fdan bir dize 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: Sa\u011fdan Bir Dize Nas\u0131l Bulunur?","description":"Bu e\u011fitimde, Excel&#39;de sa\u011fdan bir dizenin nas\u0131l aranaca\u011f\u0131 bir \u00f6rnekle 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\/excel-dogru-arama\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Sa\u011fdan Bir Dize Nas\u0131l Bulunur?","og_description":"Bu e\u011fitimde, Excel&#39;de sa\u011fdan bir dizenin nas\u0131l aranaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-dogru-arama\/","og_site_name":"Statorials","article_published_time":"2023-07-09T07:01:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sr1.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\/excel-dogru-arama\/","url":"https:\/\/statorials.org\/tr\/excel-dogru-arama\/","name":"Excel: Sa\u011fdan Bir Dize Nas\u0131l Bulunur?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-09T07:01:57+00:00","dateModified":"2023-07-09T07:01:57+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;de sa\u011fdan bir dizenin nas\u0131l aranaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-dogru-arama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-dogru-arama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-dogru-arama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: sa\u011fdan bir dize 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\/4653","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=4653"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4653\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}