{"id":1705,"date":"2023-11-10T14:56:44","date_gmt":"2023-11-10T14:56:44","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/"},"modified":"2023-12-10T05:59:32","modified_gmt":"2023-12-10T05:59:32","slug":"excel-dize-islevleri","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/","title":{"rendered":"Excel dize (metin) i\u0307\u015flevleri"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2235461146\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel&#8217;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\u0131r. Bu i\u015flevler metni d\u00fczenlemenize, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf de\u011fi\u015ftirmenize, bir dize bulman\u0131za, dize uzunlu\u011funu sayman\u0131za vb. yard\u0131mc\u0131 olabilir. Bu yaz\u0131m\u0131zda ana metin fonksiyonlar\u0131n\u0131 ele ald\u0131k. <strong><em>( <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/exemples_de_fichiers_de_fonctions_texte_excel.zip\" target=\"_blank\" rel=\"noreferrer noopener\">\u00d6rnek dosyalar<\/a> )<\/em><\/strong><\/p><h2 class=\"wp-block-heading\"> 1. UZUNLUK i\u015flevi<\/h2><p> <strong>UZUNLUK i\u015flevi, de\u011ferdeki karakter say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir deyi\u015fle, UZUNLUK i\u015fleviyle de\u011ferdeki karakter say\u0131s\u0131n\u0131 sayabilirsiniz. Bir h\u00fccreye ba\u015fvurabilir veya de\u011feri do\u011frudan i\u015fleve ekleyebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>UZUNLUK(metin)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>metin:<\/strong> karakterlerini saymak istedi\u011finiz bir dize.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte h\u00fccredeki harfleri saymak i\u00e7in LEN&#8217;i kulland\u0131k. \u201cMerhaba D\u00fcnya\u201d bo\u015flukla ayr\u0131lm\u0131\u015f 10 karakterden olu\u015fuyor ve sonu\u00e7ta 11 karakter var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37122\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-len-fonksiyonu-\u00f6rnek-1\" width=\"412\" height=\"305\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte &#8220;22-Ocak-2016&#8221; 11 karakter i\u00e7erir ancak LEN 5 de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37123\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-len-fonksiyonu-\u00f6rnek-2\" width=\"435\" height=\"296\"><\/figure><\/div><p> Bunun nedeni, LEN i\u015flevinin bir h\u00fccrenin de\u011ferindeki karakterleri saymas\u0131 ve bi\u00e7imlendirmeyle ilgilenmemesidir.<\/p><p> <strong>\u0130lgili:<\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/kelimeleri-say\/\">Excel&#8217;de Kelimeleri COUNT Etme<\/a><\/p><h2 class=\"wp-block-heading\"> 2. BUL i\u015flevi<\/h2><p> FIND i\u015flevi, bir dize i\u00e7indeki bir alt dizenin ba\u015flang\u0131\u00e7 konumu olan bir say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, arama fonksiyonunu kullanarak bir dizenin ba\u015fka bir dizedeki ba\u015flang\u0131\u00e7 konumunu (b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131) bulabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>BUL(metin_bul,metin i\u00e7inde,[ba\u015flang\u0131\u00e7_numaras\u0131])<\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>find_text<\/strong> : Di\u011fer metinden bulmak istedi\u011finiz metin.<\/li><li> <strong>inside_text<\/strong> : Metni bulmak istedi\u011finiz metin.<\/li><li> <strong>[ba\u015flang\u0131\u00e7_num]<\/strong> : Say\u0131, araman\u0131n ba\u015flang\u0131\u00e7 konumunu temsil eder.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte \u201c:\u201d harfini bulmak i\u00e7in FIND kulland\u0131k ve ard\u0131ndan MID ve LEN yard\u0131m\u0131yla h\u00fccre ad\u0131n\u0131 \u00e7\u0131kard\u0131k.<\/p><h2 class=\"wp-block-heading\"> 3. ARAMA i\u015flevi<\/h2><p> SEARCH i\u015flevi, bir dize i\u00e7indeki bir alt dizenin ba\u015flang\u0131\u00e7 konumu olan bir say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr. Basit\u00e7e s\u00f6ylemek gerekirse, SEARCH i\u015fleviyle, ba\u015fka bir dizedeki bir metin dizesinin ba\u015flang\u0131\u00e7 konumunu (b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 olmayan) arayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ARAMA(metin_bul,metin i\u00e7inde,[ba\u015flang\u0131\u00e7_numaras\u0131])<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>bul_metin:<\/strong> ba\u015fka bir metinden bulmak istedi\u011finiz metin.<\/li><li> <strong>inside_text:<\/strong> Metnini yerelle\u015ftirmek istedi\u011finiz metin. Bir h\u00fccreye ba\u015fvurabilir veya i\u015flevinize metin girebilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte \u201cP\u201d alfabesini ar\u0131yoruz ve aramam\u0131za ba\u015flamak i\u00e7in ba\u015flang\u0131\u00e7_numunu 1 olarak belirledik. Form\u00fcl\u00fcm\u00fcz metin konumu olarak 1 de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37315\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fonction-de-recherche-excel-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-arama-fonksiyonu-\u00f6rnek-1\" width=\"468\" height=\"300\"><\/figure><\/div><p> Ancak kelimeye bakarsan\u0131z 6. s\u0131rada bir de &#8220;P&#8221; harfi var. Bu, SEARCH i\u015flevinin yaln\u0131zca bir metnin ilk ge\u00e7ti\u011fi konumu veya ba\u015flang\u0131\u00e7 konumunu buna g\u00f6re belirtmeniz durumunda d\u00f6nd\u00fcrebilece\u011fi anlam\u0131na gelir.<\/p><h2 class=\"wp-block-heading\"> 4. SOL i\u015flevi<\/h2><p> <strong>LEFT i\u015flevleri, sol taraftan (ba\u015flang\u0131\u00e7tan) ba\u015flayarak bir dizedeki s\u0131ral\u0131 karakterleri d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, LEFT i\u015fleviyle bir dizenin sol taraf\u0131ndaki karakterleri \u00e7\u0131karabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>SOL(metin,karakter_say\u0131s\u0131)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>metin:<\/strong> karakterlerini \u00e7\u0131karmak istedi\u011finiz metin veya say\u0131.<\/li><li> <strong>[num_char]:<\/strong> \u00e7\u0131karmak istedi\u011finiz karakter say\u0131s\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, \u00e7\u0131kar\u0131lacak karakter say\u0131s\u0131n\u0131 belirterek SOL&#8217;u kullanarak bir metin dizesinden ilk be\u015f rakam\u0131 \u00e7\u0131kard\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37119\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-gauche-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sol-i\u015flev-\u00f6rnek-1\" width=\"644\" height=\"255\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, <a href=\"https:\/\/exceladvisor.org\/tr\/ilk-son-kelimeyi-al\/\">h\u00fccre ad\u0131n\u0131 \u00e7\u0131karan<\/a> bir form\u00fcl olu\u015fturmak i\u00e7in LEFT ile birlikte LEN ve FIND&#8217;\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37120\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-gauche-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sol-i\u015flev-\u00f6rnek-2\" width=\"636\" height=\"359\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 5. SA\u011e i\u015flev<\/h2><p> RIGHT i\u015flevi, bir dizenin sa\u011f (son) taraf\u0131ndan ba\u015flayarak s\u0131ral\u0131 karakterleri d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, RIGHT i\u015fleviyle bir dizenin sol taraf\u0131ndaki karakterleri \u00e7\u0131karabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>SA\u011e(metin,karakter_say\u0131s\u0131)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>metin:<\/strong> karakterlerini \u00e7\u0131karmak istedi\u011finiz metin veya say\u0131.<\/li><li> <strong>[num_char]:<\/strong> \u00e7\u0131karmak istedi\u011finiz karakter say\u0131s\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte do\u011fru fonksiyonu kullanarak 6 karakteri \u00e7\u0131kard\u0131k. Dizeden ka\u00e7 karakter \u00e7\u0131karman\u0131z gerekti\u011fini biliyorsan\u0131z, bunlar\u0131 bir say\u0131 kullanarak kolayca \u00e7\u0131karabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37255\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-droite-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sa\u011f-i\u015flev-\u00f6rnek-1\" width=\"599\" height=\"271\"><\/figure><\/div><p> \u015eimdi a\u015fa\u011f\u0131daki \u00f6rne\u011fe bakarsan\u0131z, h\u00fccreden soyad\u0131n\u0131 \u00e7\u0131karmam\u0131z gerekiyor, ancak soyad\u0131ndaki karakter say\u0131s\u0131 konusunda onaylanmad\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37256\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-droite-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sa\u011f-i\u015flev-\u00f6rnek-2\" width=\"612\" height=\"337\"><\/figure><\/div><p> Yani ismi almak i\u00e7in LEN ve FIND kullan\u0131yoruz. Bunu nas\u0131l yapt\u0131\u011f\u0131m\u0131z\u0131 size g\u00f6stereyim.<\/p><p> \u00d6ncelikle t\u00fcm bu metin dizisinin uzunlu\u011funu elde etmek i\u00e7in LEN&#8217;i kulland\u0131k, ard\u0131ndan ad ile soyad\u0131 aras\u0131ndaki bo\u015flu\u011fun konum numaras\u0131n\u0131 almak i\u00e7in FIND&#8217;\u0131 kulland\u0131k. Ve sonunda soyad\u0131n\u0131 almak i\u00e7in iki rakam\u0131 kulland\u0131k.<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer1:<\/strong> do\u011frudan i\u015fleve girilen bir h\u00fccre ba\u015fvurusu, dizi veya say\u0131.<\/li><li> <strong>[de\u011fer2]:<\/strong> do\u011frudan fonksiyona girilen bir h\u00fccre referans\u0131, dizi veya say\u0131.<\/li><\/ul><h2 class=\"wp-block-heading\"> 6.MID i\u015flevi<\/h2><p> MID, belirli bir konum ve karakter say\u0131s\u0131n\u0131 kullanarak bir dizeden bir alt dize d\u00f6nd\u00fcr\u00fcr. Basit\u00e7e s\u00f6ylemek gerekirse, MID ile ba\u015flang\u0131\u00e7 karakterini ve \u00e7\u0131karmak istedi\u011finiz karakter say\u0131s\u0131n\u0131 belirterek bir dizeden bir alt dize \u00e7\u0131karabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>MID(metin,ba\u015flang\u0131\u00e7_numaras\u0131,karakter_say\u0131s\u0131)<\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>metin:<\/strong> Karakterleri \u00e7\u0131karmak istedi\u011finiz metin veya say\u0131.<\/li><li> <strong>start_char:<\/strong> karakter \u00e7\u0131karmak istedi\u011finiz karakterin konumu i\u00e7in bir say\u0131.<\/li><li> <strong>say\u0131_karakterler:<\/strong> ba\u015flang\u0131\u00e7_karakterden \u00e7\u0131karmak istedi\u011finiz karakter say\u0131s\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte farkl\u0131 de\u011ferler kulland\u0131k:<\/p><ul><li> 6. karakterden sonraki 6 karaktere kadar.<\/li><li> 6. karakterden sonraki 10 karaktere kadar.<\/li><li> Negatif bir karakterle ba\u015flamay\u0131 kulland\u0131k ve bu bir hata d\u00f6nd\u00fcrd\u00fc.<\/li><li> \u00c7\u0131kar\u0131lacak karakter say\u0131s\u0131 i\u00e7in 0 kullan\u0131ld\u0131\u011f\u0131nda bo\u015fluk d\u00f6nd\u00fcr\u00fcld\u00fc.<\/li><li> \u00c7\u0131kar\u0131lacak karakter say\u0131s\u0131 i\u00e7in negatif bir say\u0131 ile hata d\u00f6nd\u00fcrd\u00fc.<\/li><li> Ba\u015flang\u0131\u00e7 numaras\u0131 s\u0131f\u0131rd\u0131r ve bir hata d\u00f6nd\u00fcrm\u00fc\u015ft\u00fcr.<\/li><li> Do\u011frudan fonksiyondaki metin dizesi. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37134\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-mid-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-orta-i\u015flev-\u00f6rnek-1\" width=\"582\" height=\"427\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 7.ALT Fonksiyonu<\/h2><p> LOWER, t\u00fcm harfleri k\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrd\u00fckten sonra dizeyi d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, sahip oldu\u011funuz t\u00fcm harflerin k\u00fc\u00e7\u00fck harf oldu\u011fu, say\u0131lar\u0131n de\u011fi\u015fmeden kalaca\u011f\u0131 bir metin dizesini d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ALT(metin)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>text:<\/strong> K\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz metin.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte k\u00fc\u00e7\u00fck harf, b\u00fcy\u00fck harf, \u00f6zel harf ve <a href=\"https:\/\/exceladvisor.org\/tr\/cumle-durumu\/\">c\u00fcmle durumunu<\/a> birbiriyle kar\u015f\u0131la\u015ft\u0131rd\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37125\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-inferieure-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-alt-i\u015flev-\u00f6rnek-1\" width=\"503\" height=\"419\"><\/figure><\/div><p> K\u00fc\u00e7\u00fck harfli metinde t\u00fcm harfler di\u011ferlerine g\u00f6re k\u00fc\u00e7\u00fck harfle yaz\u0131l\u0131r.<\/p><h2 class=\"wp-block-heading\"> 8. Do\u011fru i\u015flev<\/h2><p> PROPER i\u015flevi, uygun durumdaki metin dizesini d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, kelimenin ilk harfinin b\u00fcy\u00fck oldu\u011fu ve k\u00fc\u00e7\u00fck harf olarak kald\u0131\u011f\u0131 (uygun harf) PROPER i\u015fleviyle.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>KEND\u0130(metin)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>metin:<\/strong> B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz metin.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir kelimenin ilk harfinin b\u00fcy\u00fck oldu\u011fu ve di\u011fer iki harfin k\u00fc\u00e7\u00fck ve b\u00fcy\u00fck harfle kar\u015f\u0131la\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda geri kalan harflerin k\u00fc\u00e7\u00fck oldu\u011fu uygun bir durumumuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37229\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-propre-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-kendi-fonksiyonu-\u00f6rnek-1\" width=\"535\" height=\"329\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, ad\u0131 ve soyad\u0131n\u0131 do\u011fru harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in PROPER i\u015flevini kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37230\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-propre-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-kendi-fonksiyonu-\u00f6rnek-2\" width=\"495\" height=\"407\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 9. \u00dcST\u00dcN Fonksiyon<\/h2><p> UPPER i\u015flevi, t\u00fcm harfleri b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrd\u00fckten sonra dizeyi d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, sahip oldu\u011funuz t\u00fcm harflerin b\u00fcy\u00fck harf oldu\u011fu ve say\u0131lar\u0131n de\u011fi\u015fmeden kalaca\u011f\u0131 bir metin dizesini d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>B\u00dcY\u00dcK HARF (metin)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>text:<\/strong> B\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz metin.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, ad metnini, karakterlerin farkl\u0131 durumda oldu\u011fu metinden b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in UPPER&#8217;\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37361\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-superieure-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-fonksiyonu-\u00fcst\u00fcn-\u00f6rnek-1\" width=\"450\" height=\"331\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 10. REPT i\u015flevi<\/h2><p> REPT i\u015flevi bir metin de\u011ferini birden \u00e7ok kez d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle REPT i\u015fleviyle bir metin ve bu metnin tekrarlanaca\u011f\u0131 bir say\u0131 belirtebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>REPT(de\u011fer1; [de\u011fer2], \u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte REPT kullanarak tekrarlama i\u00e7in farkl\u0131 metin t\u00fcrleri kulland\u0131k. \u0130\u015flevde belirtti\u011finiz her t\u00fcrl\u00fc metin veya say\u0131y\u0131 ve hatta simgeleri tekrarlayabilir ve REPT i\u015flevinin ana kullan\u0131m\u0131 h\u00fccrelerde grafikler olu\u015fturmakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37236\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-rept-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-rept-fonksiyonu-\u00f6rnek-1\" width=\"504\" height=\"367\"><\/figure><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1705","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel String Fonksiyonlar\u0131 (Metin) \u00d6rnekleri + \u00d6rnek Dosyalar<\/title>\n<meta name=\"description\" content=\"Excel&#039;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\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:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel String Fonksiyonlar\u0131 (Metin) \u00d6rnekleri + \u00d6rnek Dosyalar\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\",\"name\":\"Excel String Fonksiyonlar\u0131 (Metin) \u00d6rnekleri + \u00d6rnek Dosyalar\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png\",\"datePublished\":\"2023-11-10T14:56:44+00:00\",\"dateModified\":\"2023-12-10T05:59:32+00:00\",\"description\":\"Excel&#39;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel dize (metin) i\u0307\u015flevleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel String Fonksiyonlar\u0131 (Metin) \u00d6rnekleri + \u00d6rnek Dosyalar","description":"Excel&#39;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\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:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel String Fonksiyonlar\u0131 (Metin) \u00d6rnekleri + \u00d6rnek Dosyalar","og_description":"Excel&#39;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\u0131r.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/","url":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/","name":"Excel String Fonksiyonlar\u0131 (Metin) \u00d6rnekleri + \u00d6rnek Dosyalar","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png","datePublished":"2023-11-10T14:56:44+00:00","dateModified":"2023-12-10T05:59:32+00:00","description":"Excel&#39;de metin verilerini i\u015flemenize yard\u0131mc\u0131 olabilecek \u00e7e\u015fitli dize (metin) i\u015flevleri vard\u0131r.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-len-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel dize (metin) i\u0307\u015flevleri"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1705"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1705\/revisions"}],"predecessor-version":[{"id":2331,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1705\/revisions\/2331"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}