{"id":5123,"date":"2023-07-03T05:47:30","date_gmt":"2023-07-03T05:47:30","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-onek-ekle\/"},"modified":"2023-07-03T05:47:30","modified_gmt":"2023-07-03T05:47:30","slug":"excel-onek-ekle","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-onek-ekle\/","title":{"rendered":"Excel'de h\u00fccrelere \u00f6nek nas\u0131l eklenir (\u00f6rneklerle)"},"content":{"rendered":"

<\/p>\n

\n

Excel’de bir h\u00fccreye \u00f6nek eklemek i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n

 =\"Mr. \"& A2<\/span><\/strong><\/pre>\n
 Bu \u00f6zel \u00f6rnek \u201cM\u201d \u00f6nekini ekleyecektir. A2<\/strong> h\u00fccresindeki mevcut metne.<\/span><\/p>\n
 \u00d6rne\u011fin, A2<\/strong> h\u00fccresinde Andy Miller<\/strong> bulunuyorsa bu form\u00fcl Bay Andy Miller 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
 \u00d6rnek: Excel’de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir?<\/strong><\/span><\/h2>\n
 Excel’de a\u015fa\u011f\u0131daki ad s\u00fctununa sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 Diyelim ki “Bay” \u00f6nekini eklemek istiyoruz. her ismin \u00f6n\u00fcnde.<\/span><\/p>\n
 Bunu yapmak i\u00e7in B2<\/b> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =\"Mr. \"& A2<\/span><\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 B s\u00fctunu art\u0131k A s\u00fctunundaki “Bay” \u00f6nekiyle birlikte her ad\u0131 i\u00e7eriyor. ondan \u00f6nce eklendi.<\/span><\/p>\n
 \u0130stedi\u011finiz herhangi bir \u00f6neki eklemek i\u00e7in tam olarak ayn\u0131 s\u00f6zdizimini kullanabilece\u011finizi unutmay\u0131n.<\/span><\/p>\n
 \u00d6rne\u011fin bunun yerine \u201cDr.\u201d ekleyebilirsiniz. A\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanarak her ad\u0131n \u00f6n\u00fcne:<\/span><\/p>\n
 =\"Dr.\"& A2<\/span><\/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
 Veya her ad\u0131n \u00f6n\u00fcne “Ad:” \u00f6nekini eklemek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n
 =\"Name: \"& A2<\/span><\/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
 Belirli bir aral\u0131ktaki her h\u00fccreye istedi\u011finiz \u00f6neki eklemek i\u00e7in bu genel form\u00fcl\u00fc kullanmaktan \u00e7ekinmeyin.<\/span><\/p>\n
 Not<\/strong> : Excel’deki &<\/strong> sembol\u00fc, de\u011ferleri bir araya getirmenin h\u0131zl\u0131 ve kolay bir yolunu sa\u011flar.<\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h2>\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: H\u00fccrelerden Belirli Metin Nas\u0131l Kald\u0131r\u0131l\u0131r<\/a>
 Excel: \u00f6zel karakterler nas\u0131l kald\u0131r\u0131l\u0131r<\/a>
 Excel: Bir dizeye karakter nas\u0131l eklenir<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Excel’de bir h\u00fccreye \u00f6nek eklemek i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz: =”Mr. “& A2 Bu \u00f6zel \u00f6rnek \u201cM\u201d \u00f6nekini ekleyecektir. A2 h\u00fccresindeki mevcut metne. \u00d6rne\u011fin, A2 h\u00fccresinde Andy Miller bulunuyorsa bu form\u00fcl Bay Andy Miller de\u011ferini d\u00f6nd\u00fcr\u00fcr. A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir. \u00d6rnek: Excel’de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir? Excel’de a\u015fa\u011f\u0131daki ad s\u00fctununa 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-5123","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir (\u00d6rneklerle) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel'de belirli bir aral\u0131ktaki t\u00fcm h\u00fccrelere nas\u0131l \u00f6nek eklenece\u011fi 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-onek-ekle\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir (\u00d6rneklerle) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel'de belirli bir aral\u0131ktaki t\u00fcm h\u00fccrelere nas\u0131l \u00f6nek eklenece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-onek-ekle\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T05:47:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pree1.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-onek-ekle\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-onek-ekle\/\",\"name\":\"Excel'de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir (\u00d6rneklerle) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-03T05:47:30+00:00\",\"dateModified\":\"2023-07-03T05:47:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir \u00f6rnekle Excel'de belirli bir aral\u0131ktaki t\u00fcm h\u00fccrelere nas\u0131l \u00f6nek eklenece\u011fi a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-onek-ekle\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-onek-ekle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-onek-ekle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de h\u00fccrelere \u00f6nek nas\u0131l eklenir (\u00f6rneklerle)\"}]},{\"@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 H\u00fccrelere \u00d6nek Nas\u0131l Eklenir (\u00d6rneklerle) - Statorials","description":"Bu e\u011fitimde, bir \u00f6rnekle Excel'de belirli bir aral\u0131ktaki t\u00fcm h\u00fccrelere nas\u0131l \u00f6nek eklenece\u011fi 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-onek-ekle\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir (\u00d6rneklerle) - Statorials","og_description":"Bu e\u011fitimde, bir \u00f6rnekle Excel'de belirli bir aral\u0131ktaki t\u00fcm h\u00fccrelere nas\u0131l \u00f6nek eklenece\u011fi a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-onek-ekle\/","og_site_name":"Statorials","article_published_time":"2023-07-03T05:47:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pree1.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-onek-ekle\/","url":"https:\/\/statorials.org\/tr\/excel-onek-ekle\/","name":"Excel'de H\u00fccrelere \u00d6nek Nas\u0131l Eklenir (\u00d6rneklerle) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-03T05:47:30+00:00","dateModified":"2023-07-03T05:47:30+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir \u00f6rnekle Excel'de belirli bir aral\u0131ktaki t\u00fcm h\u00fccrelere nas\u0131l \u00f6nek eklenece\u011fi a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-onek-ekle\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-onek-ekle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-onek-ekle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de h\u00fccrelere \u00f6nek nas\u0131l eklenir (\u00f6rneklerle)"}]},{"@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\/5123","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=5123"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/5123\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=5123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=5123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=5123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}