{"id":3744,"date":"2023-07-15T19:29:34","date_gmt":"2023-07-15T19:29:34","guid":{"rendered":"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/"},"modified":"2023-07-15T19:29:34","modified_gmt":"2023-07-15T19:29:34","slug":"dizenin-sonunda-excel-mi-islevi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/","title":{"rendered":"Excel: dizeyi sonland\u0131rmak 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 dizenin sonundaki belirli bir ba\u015flang\u0131\u00e7 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 <b>LEN<\/b> i\u015fleviyle birlikte kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MID( <span style=\"color: #3366ff;\">A2,3<\/span> ,LEN( <span style=\"color: #3366ff;\">A2<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel form\u00fcl, <strong>A2<\/strong> h\u00fccresindeki dizedeki her karakteri, dizenin 3. karakterinden son karakterine kadar \u00e7\u0131kar\u0131r.<\/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 bir dizeyi sonland\u0131rmak i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 isimleri listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30492 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.jpg\" alt=\"\" width=\"498\" height=\"453\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Diyelim ki her tak\u0131mdan 3. karakterden sonuncuya kadar karakter \u00e7\u0131karmak istiyoruz.<\/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,3<\/span> ,LEN( <span style=\"color: #3366ff;\">A2<\/span> ))<\/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=\" wp-image-30506 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu3.jpg\" alt=\"\" width=\"513\" height=\"500\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">S\u00fctun B art\u0131k her tak\u0131m\u0131n karakterlerini 3. karakterden son karaktere kadar g\u00f6steriyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Excel&#8217;deki <strong>LEN()<\/strong> i\u015flevinin bir dizenin uzunlu\u011funu bulmak i\u00e7in kullan\u0131ld\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yani form\u00fcl\u00fcm\u00fcz Excel&#8217;e, 3. karakterden dizenin t\u00fcm uzunlu\u011funu temsil eden karaktere kadar her dizedeki karakterleri \u00e7\u0131karmas\u0131n\u0131 s\u00f6yler.<\/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\/excel-mi-islevi-degisken-uzunlugu\/\">Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/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><\/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 dizenin sonundaki belirli bir ba\u015flang\u0131\u00e7 karakterine g\u00f6re ortadaki karakterleri \u00e7\u0131karmak isteyebilirsiniz. Bunu yapmak i\u00e7in MID i\u015flevini LEN i\u015fleviyle birlikte kullanabilirsiniz: =MID( A2,3 ,LEN( A2 )) Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dizedeki her karakteri, dizenin 3. [&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-3744","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: Bir dize i\u015flevinin sonuna kadar MID nas\u0131l kullan\u0131l\u0131r - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, karakterleri belirli bir konumdan bir dizenin sonuna \u00e7\u0131karmak i\u00e7in Excel&#039;de MID i\u015flevinin nas\u0131l kullan\u0131laca\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\/dizenin-sonunda-excel-mi-islevi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Bir dize i\u015flevinin sonuna kadar MID nas\u0131l kullan\u0131l\u0131r - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, karakterleri belirli bir konumdan bir dizenin sonuna \u00e7\u0131karmak i\u00e7in Excel&#039;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T19:29:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.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\/dizenin-sonunda-excel-mi-islevi\/\",\"url\":\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/\",\"name\":\"Excel: Bir dize i\u015flevinin sonuna kadar MID nas\u0131l kullan\u0131l\u0131r - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-15T19:29:34+00:00\",\"dateModified\":\"2023-07-15T19:29:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, karakterleri belirli bir konumdan bir dizenin sonuna \u00e7\u0131karmak i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: dizeyi sonland\u0131rmak 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: Bir dize i\u015flevinin sonuna kadar MID nas\u0131l kullan\u0131l\u0131r - Statoryaller","description":"Bu e\u011fitimde, karakterleri belirli bir konumdan bir dizenin sonuna \u00e7\u0131karmak i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\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\/dizenin-sonunda-excel-mi-islevi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Bir dize i\u015flevinin sonuna kadar MID nas\u0131l kullan\u0131l\u0131r - Statoryaller","og_description":"Bu e\u011fitimde, karakterleri belirli bir konumdan bir dizenin sonuna \u00e7\u0131karmak i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/","og_site_name":"Statorials","article_published_time":"2023-07-15T19:29:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.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\/dizenin-sonunda-excel-mi-islevi\/","url":"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/","name":"Excel: Bir dize i\u015flevinin sonuna kadar MID nas\u0131l kullan\u0131l\u0131r - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-15T19:29:34+00:00","dateModified":"2023-07-15T19:29:34+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, karakterleri belirli bir konumdan bir dizenin sonuna \u00e7\u0131karmak i\u00e7in Excel&#39;de MID i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: dizeyi sonland\u0131rmak 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\/3744","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=3744"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3744\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}