{"id":3746,"date":"2023-07-15T19:17:48","date_gmt":"2023-07-15T19:17:48","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/"},"modified":"2023-07-15T19:17:48","modified_gmt":"2023-07-15T19:17:48","slug":"excel-karaktere-kaldi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/","title":{"rendered":"Excel: belirli bir karaktere kadar sol i\u00e7in bir form\u00fcl"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Excel&#8217;in <b>SOL<\/b> i\u015flevi, bir dizenin sol taraf\u0131ndan bir dizi karakteri \u00e7\u0131karmak i\u00e7in kullan\u0131l\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ancak, belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar bir dizenin sol taraf\u0131ndaki t\u00fcm karakterleri \u00e7\u0131karmak amac\u0131yla <strong>SOL<\/strong> i\u015flevini kullanmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT(cell, FIND(\"specific_character\", cell)-1)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, <strong>A2<\/strong> h\u00fccresindeki dizenin sol taraf\u0131ndaki t\u00fcm karakterleri alt \u00e7izgiyle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar \u00e7\u0131karmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #3366ff;\">A2<\/span> , FIND(\"_\", <span style=\"color: #3366ff;\">A2<\/span> )-1)<\/strong><\/pre>\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 SOL&#8217;u belirli bir karaktere kadar kullanma<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de a\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 adlar\u0131 listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30518 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jusquau-1.jpg\" alt=\"\" width=\"468\" height=\"448\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>A2<\/strong> h\u00fccresindeki tak\u0131m ad\u0131ndan alt \u00e7izgiyle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar t\u00fcm karakterleri \u00e7\u0131karmak 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>=LEFT( <span style=\"color: #3366ff;\">A2<\/span> , FIND(\"_\", <span style=\"color: #3366ff;\">A2<\/span> )-1)<\/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-30519 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jusqua-2.jpg\" alt=\"\" width=\"525\" height=\"480\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">S\u00fctun B art\u0131k adda bir alt \u00e7izgi g\u00f6r\u00fcnene kadar her tak\u0131m ad\u0131ndaki t\u00fcm karakterleri g\u00f6r\u00fcnt\u00fcl\u00fcyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Tak\u0131m ad\u0131nda alt \u00e7izgi bulunmazsa form\u00fcl\u00fcn <strong>#DE\u011eER d\u00f6nd\u00fcrece\u011fini l\u00fctfen unutmay\u0131n!<\/strong> \u00d6yleyse.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Farkl\u0131 bir de\u011fer d\u00f6nd\u00fcrmek i\u00e7in <strong>IFERROR()<\/strong> i\u015flevini kullanman\u0131z yeterlidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, belirli bir tak\u0131m ad\u0131nda alt \u00e7izgi bulunmazsa &#8220;Hi\u00e7biri Bulunamad\u0131&#8221; sonucunu d\u00f6nd\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki <strong>IFERROR()<\/strong> i\u015flevini kullanabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR(LEFT( <span style=\"color: #3366ff;\">A2<\/span> ,FIND(\"_\", <span style=\"color: #3366ff;\">A2<\/span> )-1),\"None Found\")\n<\/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-30520 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jusquau-3.jpg\" alt=\"\" width=\"612\" height=\"482\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>IFERROR()<\/strong> i\u015flevinde &#8220;Hi\u00e7biri bulunamad\u0131&#8221; ifadesini ba\u015fka bir de\u011ferle de\u011fi\u015ftirerek de farkl\u0131 bir de\u011fer d\u00f6nd\u00fcrebilece\u011finizi unutmay\u0131n.<\/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 genel g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/\" target=\"_blank\" rel=\"noopener\">Excel: Dizeyi sonland\u0131rmak i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/\" target=\"_blank\" rel=\"noopener\">Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-ilk-3-karakteri-sil\/\" target=\"_blank\" rel=\"noopener\">Excel: Bir dizeden ilk 3 karakter nas\u0131l kald\u0131r\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;in SOL i\u015flevi, bir dizenin sol taraf\u0131ndan bir dizi karakteri \u00e7\u0131karmak i\u00e7in kullan\u0131l\u0131r. Ancak, belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar bir dizenin sol taraf\u0131ndaki t\u00fcm karakterleri \u00e7\u0131karmak amac\u0131yla SOL i\u015flevini kullanmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =LEFT(cell, FIND(&#8220;specific_character&#8221;, cell)-1) \u00d6rne\u011fin, A2 h\u00fccresindeki dizenin sol taraf\u0131ndaki t\u00fcm karakterleri alt \u00e7izgiyle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar \u00e7\u0131karmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =LEFT( [&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-3746","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: Belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir dizede belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar Excel&#039;de SOL 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-karaktere-kaldi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir dizede belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar Excel&#039;de SOL 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-karaktere-kaldi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T19:17:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jusquau-1.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=\"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-karaktere-kaldi\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/\",\"name\":\"Excel: Belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-15T19:17:48+00:00\",\"dateModified\":\"2023-07-15T19:17:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir dizede belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar Excel&#39;de SOL i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: belirli bir karaktere kadar sol i\u00e7in bir form\u00fcl\"}]},{\"@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: Belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl - Statoryaller","description":"Bu e\u011fitimde, bir dizede belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar Excel&#39;de SOL 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-karaktere-kaldi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl - Statoryaller","og_description":"Bu e\u011fitimde, bir dizede belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar Excel&#39;de SOL i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/","og_site_name":"Statorials","article_published_time":"2023-07-15T19:17:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jusquau-1.jpg"}],"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-karaktere-kaldi\/","url":"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/","name":"Excel: Belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-15T19:17:48+00:00","dateModified":"2023-07-15T19:17:48+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir dizede belirli bir karakterle kar\u015f\u0131la\u015f\u0131l\u0131ncaya kadar Excel&#39;de SOL i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: belirli bir karaktere kadar sol i\u00e7in bir form\u00fcl"}]},{"@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\/3746","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=3746"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3746\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}