{"id":1743,"date":"2023-11-07T22:26:40","date_gmt":"2023-11-07T22:26:40","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/"},"modified":"2023-12-10T05:59:41","modified_gmt":"2023-12-10T05:59:41","slug":"joker-karakterler-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/","title":{"rendered":"Excel joker karakterleri \u2013 y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3160975882\"><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>Bazen verilerle \u00e7al\u0131\u015fmak o kadar kolay olmuyor, bazen de karma\u015f\u0131k sorunlarla kar\u015f\u0131la\u015f\u0131yoruz.<\/p><div class=\"gb-container gb-container-ab70ac7a\"><p> Verilerde &#8220;Delhi&#8221; metnini aramak istedi\u011finizi varsayal\u0131m. Ancak bu verilerde &#8220;Delhi&#8221; de\u011fil &#8220;Yeni Delhi&#8221; kelimesi var. Art\u0131k bu durumda e\u015fle\u015ftiremez veya arama yapamazs\u0131n\u0131z. Burada, ger\u00e7ek de\u011feri (Yeni Delhi) e\u015fle\u015ftirmek veya aramak i\u00e7in yaln\u0131zca mevcut de\u011feri veya k\u0131smi de\u011feri (Delhi) kullanman\u0131za olanak tan\u0131yan bir yola ihtiyac\u0131n\u0131z var.<\/p><p> Excel joker karakterleri bunun i\u00e7in tasarlanm\u0131\u015ft\u0131r. Bu joker karakterler, k\u0131smi e\u015fle\u015fme i\u00e7eren metni araman\u0131za\/bulman\u0131za olanak tan\u0131r. Excel&#8217;de bu karakterlerin en b\u00fcy\u00fck faydas\u0131 arama ve metin fonksiyonlar\u0131ndad\u0131r. Bu, de\u011fer bilinmedi\u011finde veya k\u0131smen mevcut oldu\u011funda size daha fazla esneklik sa\u011flar.<\/p><\/div><p> O y\u00fczden bug\u00fcn bu yaz\u0131mda size joker karakterlerin ne oldu\u011funu, nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, t\u00fcrlerini ve farkl\u0131 i\u015flevlerle kullanma \u00f6rneklerini anlatmak istiyorum. Ba\u015flayal\u0131m.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Excel joker karakterleri nelerdir?<\/h2><p> Excel joker karakterleri, bir veya daha fazla karakteri temsil eden \u00f6zel karakter t\u00fcrleridir. D\u00fczenli ifadelerde, bilinmeyen karakterlerle de\u011fi\u015ftirilerek kullan\u0131l\u0131r. Basit\u00e7e s\u00f6ylemek gerekirse, hangi karakterin kullan\u0131laca\u011f\u0131ndan emin de\u011filseniz orada joker karakter kullanabilirsiniz.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Excel Joker Karakter T\u00fcrleri<\/h2><p> Excel&#8217;de <strong><span style=\"background-color: #fff44f;\">Y\u0131ld\u0131z \u0130\u015fareti, Soru \u0130\u015fareti ve Tilde olmak \u00fczere<\/span><\/strong> 3 farkl\u0131 joker karakteriniz vard\u0131r. Ve her birinin kendi anlam\u0131 ve kullan\u0131m\u0131 vard\u0131r.<\/p><p> \u0130leride bu karakterlerin her birini farkl\u0131 durumlarda kullanabilmeniz i\u00e7in ayr\u0131nt\u0131l\u0131 olarak tart\u0131\u015faca\u011f\u0131z.<\/p><h3 id=\"tab-con-5\" class=\"wp-block-heading\"> 1. Y\u0131ld\u0131z(*)<\/h3><p> Y\u0131ld\u0131z i\u015fareti en pop\u00fcler joker karakterlerden biridir. Bir metinden istenilen say\u0131da karakteri (s\u0131rayla) bulabilir. \u00d6rne\u011fin Pi* kullan\u0131rsan\u0131z size Pivot, Image, Picnic vb. kelimeleri verecektir.<\/p><p> Dikkat ederseniz bu kelimelerin hepsinin ba\u015f\u0131nda Pi, daha sonra farkl\u0131 karakterler var. Bir \u00f6rnekle nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlayal\u0131m. A\u015fa\u011f\u0131da tek bir h\u00fccrede \u015fehir adlar\u0131n\u0131n ve s\u0131n\u0131fland\u0131rmalar\u0131n\u0131n bulundu\u011fu verileriniz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"excel1'de y\u0131ld\u0131z joker karakterleri ile kullan\u0131lacak \u015fehir verileri\"><\/figure><\/div><p> \u015eimdi buradan her s\u0131n\u0131fland\u0131rmadaki \u015fehir say\u0131s\u0131n\u0131 sayman\u0131z gerekiyor. ve bunun i\u00e7in COUNTIF ile y\u0131ld\u0131z i\u015fareti kullanabilirsiniz.<\/p><p> =E\u011eERSAY(\u015eehir,S\u0131n\u0131fland\u0131rma&amp;\u201d*\u201d) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-a-utiliser-avec-les-caracteres-generiques-asterisque-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de y\u0131ld\u0131z i\u015fareti joker karakterleri ile kullan\u0131lacak form\u00fcl\"><\/figure><\/div><p> Bu form\u00fclde h\u00fccre s\u0131n\u0131fland\u0131rma metnini y\u0131ld\u0131z i\u015faretiyle birle\u015ftirdiniz. Yani form\u00fcl yaln\u0131zca h\u00fccredeki s\u0131n\u0131fland\u0131rma metniyle e\u015fle\u015fir ve y\u0131ld\u0131z i\u015fareti di\u011fer karakterler gibi \u00e7al\u0131\u015f\u0131r. Ve sonunda s\u0131n\u0131fland\u0131rmaya g\u00f6re \u015fehir say\u0131s\u0131n\u0131 elde edersiniz.<\/p><h3 class=\"wp-block-heading\"> 2. Soru i\u015fareti<\/h3><p> Soru i\u015faretiyle metindeki tek bir karakteri de\u011fi\u015ftirebilirsiniz. Basit\u00e7e s\u00f6ylemek gerekirse, k\u0131smi e\u015fle\u015ftirmeyi kullanarak daha hassas olman\u0131za yard\u0131mc\u0131 olur. \u00d6rne\u011fin, kamplar\u0131 kullan\u0131rsan\u0131z verilerden \u015fampiyonlar\u0131 ve \u015fempanzeleri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> 3. Tild\u00e9 (~)<\/h3><p> Yakla\u015f\u0131k i\u015faretinin ger\u00e7ek kullan\u0131m\u0131, joker karakterin etkisini geri almakt\u0131r. \u00d6rne\u011fin, pivot* ifadesinin tamam\u0131n\u0131 bulmak istedi\u011finizi varsayal\u0131m. Pivot*&#8217;u bir dize olarak kullan\u0131rsan\u0131z, bu size ba\u015f\u0131nda alanlar\u0131 olan herhangi bir kelimeyi verecektir (pivot tablo veya pivot tablo gibi).<\/p><p> \u00d6zellikle pivot* dizesi i\u00e7in ~ kullanmal\u0131s\u0131n\u0131z. Yani kanal\u0131n\u0131z pivot olacak~*. Burada ~, Excel&#8217;in sonraki karakteri joker karakter olarak de\u011fil, oldu\u011fu gibi okumas\u0131n\u0131 sa\u011flar.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Excel i\u015flevlerine sahip joker karakterler<\/h2><p> \u00dc\u00e7 joker karakteri t\u00fcm <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\">ana i\u015flevlerle<\/a> kolayca kullanabiliriz. D\u00dc\u015eEYARA, YATAYARA, TOPLAM, \u00c7OKETOPLA, COUNTIF, COUNTIFS, ARAMA, BUL ve <a href=\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\">Ters ARAMA<\/a> gibi i\u015flevler.<\/p><p> Bu listeyi, bir de\u011feri e\u015fle\u015ftirmek, arama yapmak veya metin bulmak i\u00e7in kulland\u0131\u011f\u0131n\u0131z i\u015flevlerle geni\u015fletebilirsiniz. Daha \u00f6nce sizlerle i\u015flevler + bul ve de\u011fi\u015ftir se\u00e7enekleri + ko\u015fullu bi\u00e7imlendirme + say\u0131larla ilgili baz\u0131 \u00f6rnekler payla\u015faca\u011f\u0131m.<\/p><h3 class=\"wp-block-heading\"> 1. ETOPLA ile<\/h3><p> A\u015fa\u011f\u0131da fatura numaralar\u0131n\u0131z\u0131n ve tutarlar\u0131n\u0131n bulundu\u011fu verileriniz bulunmaktad\u0131r. Fatura numaralar\u0131n\u0131n \u201c\u00dcr\u00fcn-A\u201d ile ba\u015flad\u0131\u011f\u0131 tutarlar\u0131 da toplamam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-utiliser-des-caracteres-generiques-avec-sumif-excel.png\" sizes=\"\" srcset=\"\" alt=\"sumif excel ile joker karakterleri kullanmak i\u00e7in veriler\"><\/figure><\/div><p> Bunu yapmak i\u00e7in SUMIF&#8217;i joker karakterlerle kullanabiliriz. Ve form\u00fcl \u015f\u00f6yle olacak:<\/p><p> =TOPLA(F2:F11,\u201d\u00c7arp\u0131m-A*\u201d,G2:G11) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-pour-utiliser-des-caracteres-generiques-avec-sumif-excel.png\" sizes=\"\" srcset=\"\" alt=\"sumif excel ile joker karakterleri kullanma form\u00fcl\u00fc\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, sonunda kriterlerin yer ald\u0131\u011f\u0131 bir y\u0131ld\u0131z i\u015fareti kulland\u0131k. \u00d6\u011frendi\u011fimiz gibi, y\u0131ld\u0131z i\u015fareti herhangi bir say\u0131da s\u0131ra karakteri i\u00e7eren k\u0131smi metni bulabilir.<\/p><p> Ve burada onu \u201c\u00dcr\u00fcn-A\u201d ile kulland\u0131k. Yani de\u011ferin ba\u015f\u0131nda \u201c\u00dcr\u00fcn-A\u201dn\u0131n oldu\u011fu de\u011ferlerle e\u015fle\u015fecektir.<\/p><h3 id=\"tab-con-7\" class=\"wp-block-heading\"> 2. <a href=\"https:\/\/exceladvisor.org\/tr\/vlookup-ozellikli-joker-karakterler\/\">VOKUP ile<\/a><\/h3><p> Diyelim ki tam adlar\u0131n\u0131 ve notlar\u0131n\u0131 i\u00e7eren bir \u00f6\u011frenci listeniz var. Art\u0131k yaln\u0131zca adlar\u0131n\u0131n bulundu\u011fu ba\u015fka bir listede i\u015faret almak i\u00e7in D\u00dc\u015eEYARA&#8217;y\u0131 kullanmak istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utilisation-de-caracteres-generiques-Excel-avec-des-donnees-vlookup.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Ve bunun i\u00e7in form\u00fcl \u015f\u00f6yle olacakt\u0131r:<\/p><p> = <a href=\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\" target=\"_blank\" rel=\"noopener\">D\u00dc\u015eEYARA<\/a> (ad_ad&amp;\u201d*\u201d,marks_table,2,0) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utilisation-de-caracteres-generiques-Excel-avec-la-formule-vlookup.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, yaln\u0131zca ad\u0131 kullanarak not almak i\u00e7in y\u0131ld\u0131z i\u015faretli vlookup&#8217;\u0131 kulland\u0131n\u0131z.<\/p><h3 id=\"tab-con-8\" class=\"wp-block-heading\"> 3. Bulmak ve de\u011fi\u015ftirmek i\u00e7in<\/h3><p> Bul ve De\u011fi\u015ftir ile joker karakterlerin kullan\u0131lmas\u0131, verileriniz i\u00e7in harikalar yaratabilir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-caracteres-generiques-Excel-avec-les-options-de-remplacement-de-recherche.gif\" sizes=\"\" srcset=\"\" alt=\"Arama de\u011fi\u015ftirme se\u00e7enekleriyle Excel joker karakterlerini kullan\u0131n\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, aras\u0131nda farkl\u0131 karakterler bulunan \u201cExceladvisor\u201d kelimesi bulunmaktad\u0131r.<\/p><p> Ve bu karakterleri tek bo\u015flukla de\u011fi\u015ftirmek istiyorsunuz. Hatta bunu de\u011fi\u015ftir se\u00e7ene\u011fini kullanarak da yapabilirsiniz ancak bu durumda her karakteri tek tek de\u011fi\u015ftirmeniz gerekir. Ancak di\u011fer t\u00fcm karakterleri bo\u015flukla de\u011fi\u015ftirmek i\u00e7in soru i\u015faretini (?) kullanabilirsiniz.<\/p><p> T\u00fcm istenmeyen karakterleri kald\u0131rmak i\u00e7in \u201cExcel?Advisor\u201d\u0131 bulun ve \u201cExcel Advisor\u201d olarak de\u011fi\u015ftirin.<\/p><h3 id=\"tab-con-9\" class=\"wp-block-heading\"> 4. Ko\u015fullu bi\u00e7imlendirmede<\/h3><p> Bu joker karakterleri ko\u015fullu bi\u00e7imlendirmeyle de kullanabilirsiniz. Diyelim ki bir listede A harfiyle ba\u015flayan \u015fehirlerin adlar\u0131n\u0131 vurgulamak istiyorsunuz.<\/p><ul><li> \u00d6ncelikle listedeki ilk giri\u015fi se\u00e7in ve ard\u0131ndan Ana Sayfa \u2192 Stiller \u2192 Ko\u015fullu Bi\u00e7imlendirme&#8217;ye gidin.<\/li><li> \u015eimdi \u201cYeni Kural\u201d se\u00e7ene\u011fine t\u0131klay\u0131n ve \u201cHangi h\u00fccrelerin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in form\u00fcl kullan\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> Form\u00fcl giri\u015f kutusuna =E\u011eER(E\u011eERSAY(E2,&#8221;A*&#8221;),DO\u011eRU,YANLI\u015e) de\u011ferini girin.<\/li><li> Vurgulamak i\u00e7in kullanmak istedi\u011finiz format\u0131 ayarlay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Caracteres-generiques-dans-Excel-8-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> \u015eimdi listenin ilk h\u00fccresinde ko\u015fullu bi\u00e7imlendirme kulland\u0131m ve bunu listenin tamam\u0131na uygulamam gerekiyor.<\/li><li> Bi\u00e7imlendirme kural\u0131n\u0131z\u0131 uygulad\u0131\u011f\u0131n\u0131z ilk h\u00fccreyi se\u00e7in.<\/li><li> Ana Sayfa \u2192 Pano \u2192 Format Boyac\u0131s\u0131&#8217;na gidin.<\/li><li> Listenin tamam\u0131n\u0131 se\u00e7ti\u011finizde A harfiyle ba\u015flayan t\u00fcm isimler vurgulanacakt\u0131r. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Caracteres-generiques-dans-Excel-9-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h3 id=\"tab-con-10\" class=\"wp-block-heading\"> 5. Filtre de\u011ferleri<\/h3><p> Joker karakterler filtrelerde sihir gibi \u00e7al\u0131\u015f\u0131r. Diyelim ki bir \u015fehir listeniz var ve A, B, C veya ba\u015fka bir harfle ba\u015flayan \u015fehir adlar\u0131n\u0131 filtrelemek istiyorsunuz. Bunun i\u00e7in A* veya B* veya C* kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-caracteres-generiques-Excel-avec-des-filtres.gif\" sizes=\"\" srcset=\"\" alt=\"filtrelerle Excel joker karakterlerini kullanma\"><\/figure><\/div><p> Bu size o harfle ba\u015flayan \u015fehirlerin tam ad\u0131n\u0131 verecektir. Ayr\u0131ca, belirli bir harfle biten bir karakteri aramak istiyorsan\u0131z, onu o harften \u00f6nce kullanabilirsiniz (*A, *B,*C vb.).<\/p><h3 id=\"tab-con-11\" class=\"wp-block-heading\"> 6. Say\u0131larla<\/h3><p> Bu joker karakterleri say\u0131larla birlikte kullanabilirsiniz ancak bu say\u0131lar\u0131 metne d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-caracteres-generiques-dans-Excel-lorsque-vous-navez-que-des-chiffres.png\" sizes=\"\" srcset=\"\" alt=\"Yaln\u0131zca say\u0131lar\u0131n\u0131z oldu\u011funda Excel'de joker karakterler kullan\u0131n\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, k\u0131smi e\u015fle\u015fme ger\u00e7ekle\u015ftirmek i\u00e7in e\u015fle\u015fme i\u015flevini ve metin i\u015flevini kulland\u0131n\u0131z. Text fonksiyonu t\u00fcm aral\u0131\u011f\u0131 metne d\u00f6n\u00fc\u015ft\u00fcrerek bir dizi d\u00f6nd\u00fcr\u00fcr ve bu e\u015fle\u015ftirme fonksiyonundan sonra 98&#8217;den ba\u015flayan bir de\u011fer arar.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> Daha fazla bilgi edinmek i\u00e7in <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/caracteres-generiques.xlsx\" rel=\"nofollow\">bu \u00f6rnek dosyay\u0131 buradan indirin<\/a> .<\/p><h2 id=\"tab-con-12\" class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Joker karakterlerle, verileriniz do\u011fru formatta olmad\u0131\u011f\u0131nda i\u015flevlerin g\u00fcc\u00fcn\u00fc art\u0131rabilirsiniz.<\/p><p> Bu karakterler, d\u00fczensiz metin de\u011ferleriyle ba\u015fa \u00e7\u0131kma g\u00fcc\u00fc veren k\u0131smi e\u015fle\u015ftirmeyi kullanarak bir de\u011feri bulman\u0131za veya e\u015fle\u015ftirmenize yard\u0131mc\u0131 olur. Ve en iyi yan\u0131, kullanabilece\u011finiz \u00fc\u00e7 farkl\u0131 karakterinizin olmas\u0131.<\/p><p> <strong>Bu joker karakterleri daha \u00f6nce hi\u00e7 kulland\u0131n\u0131z m\u0131?<\/strong><\/p><p> D\u00fc\u015f\u00fcncelerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/p><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/referans-3d\/\">Excel&#8217;de 3 boyutlu referans<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/formulu-gizle\/\">Excel&#8217;de form\u00fcl\u00fc gizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/r1c1\/\">Excel&#8217;de R1C1 referans stili<\/a><\/li><\/ul><\/div><\/div><\/div><\/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-1743","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 Joker Karakterleri - Y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?<\/title>\n<meta name=\"description\" content=\"K\u0131smi e\u015fle\u015fmeye sahip metni bulmak i\u00e7in Excel&#039;de joker karakterleri nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.\" \/>\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\/joker-karakterler-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Joker Karakterleri - Y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?\" \/>\n<meta property=\"og:description\" content=\"K\u0131smi e\u015fle\u015fmeye sahip metni bulmak i\u00e7in Excel&#039;de joker karakterleri nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.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\/joker-karakterler-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\",\"name\":\"Excel Joker Karakterleri - Y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png\",\"datePublished\":\"2023-11-07T22:26:40+00:00\",\"dateModified\":\"2023-12-10T05:59:41+00:00\",\"description\":\"K\u0131smi e\u015fle\u015fmeye sahip metni bulmak i\u00e7in Excel&#39;de joker karakterleri nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel joker karakterleri \u2013 y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?\"}]},{\"@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 Joker Karakterleri - Y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?","description":"K\u0131smi e\u015fle\u015fmeye sahip metni bulmak i\u00e7in Excel&#39;de joker karakterleri nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.","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\/joker-karakterler-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel Joker Karakterleri - Y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?","og_description":"K\u0131smi e\u015fle\u015fmeye sahip metni bulmak i\u00e7in Excel&#39;de joker karakterleri nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.","og_url":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.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\/joker-karakterler-2\/","url":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/","name":"Excel Joker Karakterleri - Y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png","datePublished":"2023-11-07T22:26:40+00:00","dateModified":"2023-12-10T05:59:41+00:00","description":"K\u0131smi e\u015fle\u015fmeye sahip metni bulmak i\u00e7in Excel&#39;de joker karakterleri nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-ville-a-utiliser-avec-des-caracteres-generiques-asterisque-dans-Excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel joker karakterleri \u2013 y\u0131ld\u0131z i\u015fareti*, soru i\u015fareti?"}]},{"@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\/1743","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=1743"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1743\/revisions"}],"predecessor-version":[{"id":2345,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1743\/revisions\/2345"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}