{"id":4668,"date":"2023-07-09T03:48:09","date_gmt":"2023-07-09T03:48:09","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/"},"modified":"2023-07-09T03:48:09","modified_gmt":"2023-07-09T03:48:09","slug":"excel-birlestirme-sifirlari-aklinizda-tutun","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/","title":{"rendered":"Excel: de\u011ferleri birle\u015ftirme ve ba\u015ftaki s\u0131f\u0131rlar\u0131 tutma"},"content":{"rendered":"

<\/p>\n

\n

De\u011ferleri birle\u015ftirmek ve de\u011ferler birle\u015ftirildikten sonra ba\u015ftaki s\u0131f\u0131rlar\u0131 korumak i\u00e7in Excel’de a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =TEXT( A2<\/span> ,\"0000\") & B2<\/span><\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl, A2<\/strong> ve B2<\/strong> h\u00fccrelerindeki de\u011ferleri birle\u015ftirir ve A2<\/strong> h\u00fccresindeki de\u011ferin, uzunlu\u011fun d\u00f6rde e\u015fit olmas\u0131 i\u00e7in gerekti\u011fi kadar ba\u015fta s\u0131f\u0131ra sahip olmas\u0131n\u0131 sa\u011flar.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n
 \u00d6rnek: Excel’de De\u011ferleri Birle\u015ftirin ve Ba\u015ftaki S\u0131f\u0131rlar\u0131 Tutun<\/span><\/strong><\/h2>\n
 Excel’de, bir \u015firketin \u00e7e\u015fitli \u00e7al\u0131\u015fanlar\u0131n\u0131n ma\u011faza numaras\u0131n\u0131 ve kimlik numaras\u0131n\u0131 temsil eden say\u0131sal de\u011ferleri i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 Not<\/strong> : Excel, h\u00fccrelere girdi\u011finizde ba\u015ftaki s\u0131f\u0131rlar\u0131 otomatik olarak kald\u0131r\u0131rsa, ilgilendi\u011finiz h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulaman\u0131z ve ard\u0131ndan Giri\u015f<\/strong> sekmesindeki Say\u0131<\/strong> grubunun sa\u011f alt k\u00f6\u015fesindeki k\u00fc\u00e7\u00fck oka t\u0131klaman\u0131z yeterlidir.<\/span><\/p>\n
 G\u00f6r\u00fcnt\u00fclenen pencerede, Kategori<\/strong> listesinde \u00d6zel’i<\/strong> t\u0131klay\u0131n ve T\u00fcr<\/strong> kutusuna 0000<\/strong> yaz\u0131n ve ard\u0131ndan Tamam’\u0131<\/strong> t\u0131klay\u0131n.<\/span> <\/p>\n
\"\"<\/p>\n
 Bu, h\u00fccrelerde ba\u015ftaki s\u0131f\u0131rlar\u0131n g\u00f6r\u00fcnmesini sa\u011flayacakt\u0131r.<\/span><\/p>\n
 A2<\/strong> ve B2<\/strong> h\u00fccrelerinin de\u011ferlerini birle\u015ftirmek i\u00e7in CONCAT<\/strong> i\u015flevini kullanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z\u0131 varsayal\u0131m:<\/span><\/p>\n
 =CONCAT( A2<\/span> , B2<\/span> )\n<\/strong><\/pre>\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
\"\"<\/p>\n
 Varsay\u0131lan olarak Excel, birle\u015ftirilmi\u015f de\u011ferin ba\u015f\u0131ndaki s\u0131f\u0131rlar\u0131 kald\u0131racakt\u0131r.<\/span><\/p>\n
 Ba\u015ftaki s\u0131f\u0131rlar\u0131 korumak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n
 =TEXT( A2<\/span> ,\"0000\") & B2<\/span><\/strong><\/pre>\n
 Bu form\u00fcl\u00fc C2<\/strong> h\u00fccresine yazabilir, ard\u0131ndan t\u0131klay\u0131p C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n
\"Excel<\/p>\n
 Ba\u015ftaki s\u0131f\u0131rlar\u0131n son birle\u015ftirilmi\u015f de\u011ferde tutuldu\u011funu unutmay\u0131n.<\/span><\/p>\n
 Not<\/strong> : Ba\u015ftaki s\u0131f\u0131rlar\u0131n say\u0131s\u0131n\u0131 farkl\u0131 tutmak istiyorsan\u0131z, TEXT<\/strong> i\u015flevinde kullan\u0131lan s\u0131f\u0131rlar\u0131n say\u0131s\u0131n\u0131 de\u011fi\u015ftirmekten \u00e7ekinmeyin.<\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h2>\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: Belirli bir metin h\u00fccrelerden nas\u0131l kald\u0131r\u0131l\u0131r<\/a>
 Excel: belirli bir metin i\u00e7eren sat\u0131rlar nas\u0131l silinir<\/a>
 Excel: h\u00fccrenin k\u0131smi metin i\u00e7erip i\u00e7ermedi\u011fini kontrol etme<\/a>
 Excel: h\u00fccrenin liste metni i\u00e7erip i\u00e7ermedi\u011fini kontrol etme<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
De\u011ferleri birle\u015ftirmek ve de\u011ferler birle\u015ftirildikten sonra ba\u015ftaki s\u0131f\u0131rlar\u0131 korumak i\u00e7in Excel’de a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =TEXT( A2 ,”0000″) & B2 Bu \u00f6zel form\u00fcl, A2 ve B2 h\u00fccrelerindeki de\u011ferleri birle\u015ftirir ve A2 h\u00fccresindeki de\u011ferin, uzunlu\u011fun d\u00f6rde e\u015fit olmas\u0131 i\u00e7in gerekti\u011fi kadar ba\u015fta s\u0131f\u0131ra sahip olmas\u0131n\u0131 sa\u011flar. A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir. \u00d6rnek: Excel’de De\u011ferleri […]<\/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-4668","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel: De\u011ferler nas\u0131l birle\u015ftirilir ve ba\u015ftaki s\u0131f\u0131rlar nas\u0131l tutulur - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel'deki h\u00fccrelerdeki de\u011ferlerin nas\u0131l birle\u015ftirilece\u011fi ve ba\u015ftaki s\u0131f\u0131rlar\u0131n nas\u0131l tutulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\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:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: De\u011ferler nas\u0131l birle\u015ftirilir ve ba\u015ftaki s\u0131f\u0131rlar nas\u0131l tutulur - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel'deki h\u00fccrelerdeki de\u011ferlerin nas\u0131l birle\u015ftirilece\u011fi ve ba\u015ftaki s\u0131f\u0131rlar\u0131n nas\u0131l tutulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T03:48:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatzero0.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/\",\"name\":\"Excel: De\u011ferler nas\u0131l birle\u015ftirilir ve ba\u015ftaki s\u0131f\u0131rlar nas\u0131l tutulur - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-09T03:48:09+00:00\",\"dateModified\":\"2023-07-09T03:48:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel'deki h\u00fccrelerdeki de\u011ferlerin nas\u0131l birle\u015ftirilece\u011fi ve ba\u015ftaki s\u0131f\u0131rlar\u0131n nas\u0131l tutulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: de\u011ferleri birle\u015ftirme ve ba\u015ftaki s\u0131f\u0131rlar\u0131 tutma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: De\u011ferler nas\u0131l birle\u015ftirilir ve ba\u015ftaki s\u0131f\u0131rlar nas\u0131l tutulur - Statorials","description":"Bu e\u011fitimde, Excel'deki h\u00fccrelerdeki de\u011ferlerin nas\u0131l birle\u015ftirilece\u011fi ve ba\u015ftaki s\u0131f\u0131rlar\u0131n nas\u0131l tutulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\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:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: De\u011ferler nas\u0131l birle\u015ftirilir ve ba\u015ftaki s\u0131f\u0131rlar nas\u0131l tutulur - Statorials","og_description":"Bu e\u011fitimde, Excel'deki h\u00fccrelerdeki de\u011ferlerin nas\u0131l birle\u015ftirilece\u011fi ve ba\u015ftaki s\u0131f\u0131rlar\u0131n nas\u0131l tutulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/","og_site_name":"Statorials","article_published_time":"2023-07-09T03:48:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatzero0.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/","url":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/","name":"Excel: De\u011ferler nas\u0131l birle\u015ftirilir ve ba\u015ftaki s\u0131f\u0131rlar nas\u0131l tutulur - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-09T03:48:09+00:00","dateModified":"2023-07-09T03:48:09+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel'deki h\u00fccrelerdeki de\u011ferlerin nas\u0131l birle\u015ftirilece\u011fi ve ba\u015ftaki s\u0131f\u0131rlar\u0131n nas\u0131l tutulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-birlestirme-sifirlari-aklinizda-tutun\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: de\u011ferleri birle\u015ftirme ve ba\u015ftaki s\u0131f\u0131rlar\u0131 tutma"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4668"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4668\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}