{"id":3743,"date":"2023-07-15T19:37:31","date_gmt":"2023-07-15T19:37:31","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/"},"modified":"2023-07-15T19:37:31","modified_gmt":"2023-07-15T19:37:31","slug":"excel-mi-islevi-degisken-uzunlugu","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/","title":{"rendered":"Excel: de\u011fi\u015fken uzunluklu dizeler i\u00e7in mid i\u015flevi nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Excel&#8217;deki <strong>MID<\/strong> i\u015flevi, dizenin sol taraf\u0131ndaki ba\u015flang\u0131\u00e7 konumuna ba\u011fl\u0131 olarak bir dizeden belirli say\u0131da karakteri \u00e7\u0131karman\u0131za olanak tan\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ancak bazen belirli bir ba\u015flang\u0131\u00e7 ve biti\u015f karakterine g\u00f6re ortadaki karakterleri \u00e7\u0131karmak isteyebilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in <strong>MID<\/strong> i\u015flevini <strong>FIND<\/strong> i\u015fleviyle birlikte kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MID( <span style=\"color: #3366ff;\">A2<\/span> ,FIND(\"char1\", <span style=\"color: #3366ff;\">A2<\/span> )+2,FIND(\"char2\", <span style=\"color: #3366ff;\">A2,10<\/span> )-FIND(\"char1\", <span style=\"color: #3366ff;\">A2<\/span> )-2)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Bu \u00f6zel form\u00fcl, <strong>A2<\/strong> h\u00fccresindeki dizeden <strong>char1<\/strong> ve <strong>char2<\/strong> karakterleri aras\u0131ndaki her karakteri \u00e7\u0131kar\u0131r.<\/span><\/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 De\u011fi\u015fken Uzunluklu Dizeler i\u00e7in MID \u0130\u015flevi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki web sitesi URL&#8217;leri listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30498 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/var1.jpg\" alt=\"\" width=\"525\" height=\"431\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Diyelim ki \u00e7ift e\u011fik \u00e7izgi ( <strong>\/\/<\/strong> ) ile URL&#8217;nin sonuna yak\u0131n <strong>.com<\/strong> aras\u0131nda yaln\u0131zca web sitesi ad\u0131n\u0131 \u00e7\u0131karmak istiyoruz.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MID( <span style=\"color: #3366ff;\">A2<\/span> ,FIND(\"\/\/\", <span style=\"color: #3366ff;\">A2<\/span> )+2,FIND(\".com\", <span style=\"color: #3366ff;\">A2,10<\/span> )-FIND(\"\/\/\", <span style=\"color: #3366ff;\">A2<\/span> )-2)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30499\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/var2.jpg\" alt=\"Excel de\u011fi\u015fken uzunluklu MID i\u015flevi\" width=\"675\" height=\"517\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">B S\u00fctunu art\u0131k yaln\u0131zca web sitesi ad\u0131ndaki \u00e7ift e\u011fik \u00e7izgi <strong>\/\/<\/strong> ile ad\u0131n sonuna yak\u0131n <strong>.com<\/strong> aras\u0131ndaki karakterleri g\u00f6steriyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Bu form\u00fcl\u00fcn, her web sitesi ad\u0131n\u0131n uzunlu\u011fu ayn\u0131 olmasa bile i\u015fe yarad\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>FIND<\/strong> i\u015flevi kullan\u0131lmadan <strong>MID<\/strong> i\u015flevi tek ba\u015f\u0131na bu g\u00f6revi ger\u00e7ekle\u015ftiremez.<\/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-orta-sag\/\">Excel: sa\u011fdan MID form\u00fcl\u00fc<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/bos-degilse-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: \u201cbo\u015f de\u011filse\u201d form\u00fcl\u00fc<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-bos-hucreleri-yok-sayar\/\" target=\"_blank\" rel=\"noopener\">Excel: Form\u00fclleri Kullan\u0131rken Bo\u015f H\u00fccreler Nas\u0131l Yoksay\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;deki MID i\u015flevi, dizenin sol taraf\u0131ndaki ba\u015flang\u0131\u00e7 konumuna ba\u011fl\u0131 olarak bir dizeden belirli say\u0131da karakteri \u00e7\u0131karman\u0131za olanak tan\u0131r. Ancak bazen belirli bir ba\u015flang\u0131\u00e7 ve biti\u015f karakterine g\u00f6re ortadaki karakterleri \u00e7\u0131karmak isteyebilirsiniz. Bunu yapmak i\u00e7in MID i\u015flevini FIND i\u015fleviyle birlikte kullanabilirsiniz: =MID( A2 ,FIND(&#8220;char1&#8221;, A2 )+2,FIND(&#8220;char2&#8221;, A2,10 )-FIND(&#8220;char1&#8221;, A2 )-2) Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dizeden [&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-3743","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: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, de\u011fi\u015fken uzunluklu dizeler i\u00e7in Excel&#039;de MID i\u015flevinin nas\u0131l kullan\u0131laca\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-mi-islevi-degisken-uzunlugu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, de\u011fi\u015fken uzunluklu dizeler i\u00e7in Excel&#039;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T19:37:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/var1.jpg\" \/>\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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/\",\"name\":\"Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-15T19:37:31+00:00\",\"dateModified\":\"2023-07-15T19:37:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, de\u011fi\u015fken uzunluklu dizeler i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: de\u011fi\u015fken uzunluklu dizeler i\u00e7in mid i\u015flevi nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@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: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r - Statorials","description":"Bu e\u011fitimde, de\u011fi\u015fken uzunluklu dizeler i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\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-mi-islevi-degisken-uzunlugu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r - Statorials","og_description":"Bu e\u011fitimde, de\u011fi\u015fken uzunluklu dizeler i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/","og_site_name":"Statorials","article_published_time":"2023-07-15T19:37:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/var1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/","url":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/","name":"Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-15T19:37:31+00:00","dateModified":"2023-07-15T19:37:31+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, de\u011fi\u015fken uzunluklu dizeler i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: de\u011fi\u015fken uzunluklu dizeler i\u00e7in mid i\u015flevi nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/3743","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=3743"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3743\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}