Bunu yapmak i\u00e7in SOL<\/b> i\u015flevini UZUNLUK<\/b> i\u015fleviyle birlikte kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, A2<\/strong> h\u00fccresindeki dizenin son 4 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 ad\u0131ndan son 4 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 son 4 karakter \u00e7\u0131kar\u0131lm\u0131\u015f olarak g\u00f6steriyor.<\/span><\/p>\n A2<\/strong> h\u00fccresindeki dizenin son 4 karakterini kald\u0131rmak i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fc hat\u0131rlay\u0131n:<\/span><\/p>\n Excel’deki LEFT()<\/strong> i\u015flevi, bir dizenin sol 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 sol taraf\u0131ndan ba\u015flayarak dizenin uzunlu\u011funa e\u015fit say\u0131da karakter eksi 4 karakter \u00e7\u0131karmas\u0131n\u0131 s\u00f6yler.<\/span><\/p>\n Yani form\u00fcl\u00fcm\u00fcz dizenin tamam\u0131n\u0131, son 4 karakteri \u00e7\u0131kar\u0131lm\u0131\u015f \u015fekilde g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n Not<\/strong> : Bir dizedeki bo\u015f alanlar 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’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: Belirli bir metin h\u00fccrelerden nas\u0131l kald\u0131r\u0131l\u0131r<\/a> Genellikle Excel’deki bir dizenin son 4 karakterini kald\u0131rmak isteyebilirsiniz. Bunu yapmak i\u00e7in SOL i\u015flevini UZUNLUK i\u015fleviyle birlikte kullanabilirsiniz: =LEFT( A2 ,LEN( A2 )-4) Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dizenin son 4 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 son 4 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-5081","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =LEFT( A2<\/span> ,LEN( A2<\/span> )-4)\n<\/strong><\/pre>\n \u00d6rnek: Excel’deki bir dizenin son 4 karakterini kald\u0131r\u0131n<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rdernier1.png\")
<\/p>\n =LEFT( A2<\/span> ,LEN( A2<\/span> )-4)<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rdernier3.png\")
<\/p>\n Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/span><\/h2>\n
=LEFT( A2<\/span> ,LEN( A2<\/span> )-4)<\/strong><\/pre>\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><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"