Bunu yapmak i\u00e7in SA\u011e<\/b> i\u015flevini UZUNLUK<\/b> i\u015fleviyle birlikte kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, A2<\/strong> h\u00fccresindeki dizenin ilk 3 karakterini kald\u0131r\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n A\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 isimleri listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki her tak\u0131m\u0131n ad\u0131ndan ilk \u00fc\u00e7 karakteri kald\u0131rmak istiyoruz.<\/span><\/p>\n Bunu yapmak i\u00e7in B2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n B S\u00fctunu art\u0131k A s\u00fctunundaki tak\u0131m adlar\u0131n\u0131, her tak\u0131m ad\u0131ndan ilk \u00fc\u00e7 karakter \u00e7\u0131kar\u0131lm\u0131\u015f olarak g\u00f6r\u00fcnt\u00fcl\u00fcyor.<\/span><\/p>\n Excel’deki RIGHT()<\/strong> i\u015flevi, bir dizenin sa\u011f taraf\u0131ndan belirli say\u0131da karakteri \u00e7\u0131kar\u0131r.<\/span><\/p>\n Excel’deki LEN()<\/strong> i\u015flevi bir dizenin uzunlu\u011funu bulmak i\u00e7in kullan\u0131l\u0131r.<\/span><\/p>\n Yani form\u00fcl\u00fcm\u00fcz Excel’e dizenin uzunlu\u011fu eksi \u00fc\u00e7 karaktere e\u015fit olan karakter say\u0131s\u0131n\u0131 \u00e7\u0131karmas\u0131n\u0131 s\u00f6yler.<\/span><\/p>\n Yani form\u00fcl\u00fcm\u00fcz dizenin tamam\u0131n\u0131, ilk \u00fc\u00e7 karakteri kald\u0131r\u0131lm\u0131\u015f \u015fekilde g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n Not<\/strong> : Bir dizenin ba\u015f\u0131ndaki bo\u015fluklar karakter olarak say\u0131l\u0131r. \u0130stedi\u011finiz sonucu elde etmek i\u00e7in \u00f6nce bo\u015f alanlar\u0131 kald\u0131rman\u0131z gerekebilir.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: H\u00fccrelerden Belirli Metin Nas\u0131l Kald\u0131r\u0131l\u0131r<\/a> Genellikle Excel’deki bir dizenin ilk 3 karakterini kald\u0131rmak isteyebilirsiniz. Bunu yapmak i\u00e7in SA\u011e i\u015flevini UZUNLUK i\u015fleviyle birlikte kullanabilirsiniz: =RIGHT( A2 ,LEN( A2 )-3) Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dizenin ilk 3 karakterini kald\u0131r\u0131r. A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir. \u00d6rnek: Excel’deki bir dizenin ilk 3 karakterini kald\u0131r\u0131n A\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 isimleri listesine sahip […]<\/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-3745","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =RIGHT( A2<\/span> ,LEN( A2<\/span> )-3)\n<\/strong><\/pre>\n \u00d6rnek: Excel’deki bir dizenin ilk 3 karakterini kald\u0131r\u0131n<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.jpg\")
<\/p>\n =RIGHT( A2<\/span> ,LEN( A2<\/span> )-3)<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/re1.jpg\")
<\/p>\n Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/span><\/h2>\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: sa\u011fdan MID form\u00fcl\u00fc<\/a>
Excel: De\u011fi\u015fken uzunluklu dizeler i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"