SPLIT<\/strong> i\u015flevinden kaynaklanan ilk \u00f6\u011feyi elde etmek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel \u00f6rnek, A2<\/strong> h\u00fccresindeki metni s\u0131n\u0131rlay\u0131c\u0131 olarak bir bo\u015fluk kullanarak b\u00f6lecek ve ard\u0131ndan yaln\u0131zca b\u00f6lmeden kaynaklanan ilk \u00f6\u011feyi d\u00f6nd\u00fcrecektir.<\/span><\/p>\n \u00d6rne\u011fin, A2<\/strong> h\u00fccresindeki dize Andy Bernard<\/strong> ise bu form\u00fcl Andy de\u011ferini<\/strong> d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n Diyelim ki Google E-Tablolar’da a\u015fa\u011f\u0131daki ad s\u00fctununa sahibiz:<\/span> <\/p>\n Adlar\u0131, bo\u015flu\u011fun g\u00f6r\u00fcnd\u00fc\u011f\u00fc yere g\u00f6re b\u00f6lmek istedi\u011fimizi ve ard\u0131ndan yaln\u0131zca b\u00f6lmeden kaynaklanan ilk \u00f6\u011feyi elde etmek istedi\u011fimizi varsayal\u0131m.<\/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 Form\u00fcl, A s\u00fctunundaki adlar\u0131 bo\u015flu\u011fun bulundu\u011fu yere g\u00f6re b\u00f6ler ve ard\u0131ndan b\u00f6l\u00fcm\u00fcn yaln\u0131zca ilk \u00f6\u011fesini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Bu \u00f6zel \u00f6rnek i\u00e7in, A s\u00fctunundaki her ki\u015finin ad\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/span><\/p>\n Bunun yerine ikinci \u00f6\u011feyi d\u00f6nd\u00fcrmek istiyorsan\u0131z form\u00fclde Col1’i<\/strong> Col2<\/strong> ile de\u011fi\u015ftirebilece\u011finizi unutmay\u0131n:<\/span><\/span><\/p>\n 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 Bu sefer form\u00fcl b\u00f6lmenin ikinci eleman\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Col3, Col4, Col5 vb. kullanmaktan \u00e7ekinmeyin. bunun yerine \u00fc\u00e7\u00fcnc\u00fc, d\u00f6rd\u00fcnc\u00fc, be\u015finci \u00f6\u011feyi vb. d\u00f6nd\u00fcrmek i\u00e7in. SPLIT<\/strong> fonksiyonunun<\/span><\/p>\n Metni b\u00f6lmek i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fc hat\u0131rlay\u0131n ve elde edilen b\u00f6l\u00fcm\u00fcn ilk \u00f6\u011fesini elde edin:<\/span><\/p>\n Bu form\u00fcl\u00fcn i\u015fleyi\u015fi \u015f\u00f6yle:<\/span><\/p>\n \u0130lk olarak SPLIT<\/b> i\u015flevi, A2<\/strong> h\u00fccresindeki metni alan\u0131n konumuna g\u00f6re b\u00f6ler.<\/span><\/p>\n \u00d6rne\u011fin, Andy Bernard<\/strong> ad\u0131, Andy’yi<\/strong> i\u00e7eren bir s\u00fctuna ve Bernard’\u0131<\/strong> i\u00e7eren ikinci bir s\u00fctuna b\u00f6l\u00fcnm\u00fc\u015ft\u00fcr.<\/span><\/p>\n Daha sonra QUERY<\/strong> i\u015flevi \u00e7\u0131kt\u0131n\u0131n yaln\u0131zca ilk s\u00fctununu se\u00e7er.<\/span><\/p>\n Sonu\u00e7ta b\u00f6lmenin yaln\u0131zca ilk eleman\u0131n\u0131, yani Andy’yi<\/strong> elde edebiliyoruz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar’da di\u011fer yayg\u0131n g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Google E-Tablolar: metin sat\u0131rlara nas\u0131l b\u00f6l\u00fcn\u00fcr<\/a> Google E-Tablolar’daki SPLIT i\u015flevi, metni belirli bir s\u0131n\u0131rlay\u0131c\u0131ya g\u00f6re b\u00f6lmek i\u00e7in kullan\u0131labilir. SPLIT i\u015flevinden kaynaklanan ilk \u00f6\u011feyi elde etmek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: =QUERY(SPLIT( A2 , ” ” ), ” SELECT Col1 ” ) Bu \u00f6zel \u00f6rnek, A2 h\u00fccresindeki metni s\u0131n\u0131rlay\u0131c\u0131 olarak bir bo\u015fluk kullanarak b\u00f6lecek ve ard\u0131ndan yaln\u0131zca b\u00f6lmeden kaynaklanan ilk \u00f6\u011feyi d\u00f6nd\u00fcrecektir. \u00d6rne\u011fin, […]<\/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-4648","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =QUERY(SPLIT( A2<\/span> , \" \"<\/span> ), \" SELECT Col1<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n \u00d6rnek: SPLIT i\u015flevi nas\u0131l kullan\u0131l\u0131r ve Google E-Tablolar’daki ilk \u00f6\u011fe nas\u0131l al\u0131n\u0131r?<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/splitfirst1.png\")
<\/p>\n =QUERY(SPLIT( A2<\/span> , \" \"<\/span> ), \" SELECT Col1<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/splitfirst2.png\")
<\/p>\n =QUERY(SPLIT( A2<\/span> , \" \"<\/span> ), \" SELECT Col2<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/splitfirst3.png\")
<\/p>\n Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/span><\/h2>\n
=QUERY(SPLIT( A2<\/span> , \" \"<\/span> ), \" SELECT Col1<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Google E-Tablolar: tarih ve saat nas\u0131l b\u00f6l\u00fcn\u00fcr<\/a>
Google E-Tablolar: SPLIT birden \u00e7ok s\u0131n\u0131rlay\u0131c\u0131yla nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"