{"id":1608,"date":"2023-11-15T12:20:42","date_gmt":"2023-11-15T12:20:42","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/"},"modified":"2023-12-06T06:18:23","modified_gmt":"2023-12-06T06:18:23","slug":"menggunakan-huruf-kapital-pada-huruf-pertama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/","title":{"rendered":"Bagaimana cara menggunakan huruf kapital pada huruf pertama di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-820418663\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Katakanlah Anda memiliki daftar nilai teks dan Anda ingin menggunakan huruf besar pada huruf pertama setiap teks.<\/p><p> Hal ini dapat dengan mudah dilakukan dengan menggunakan rumus sederhana. Dan dalam tutorial ini, kita akan belajar bagaimana menulis rumus ini untuk menggunakan huruf kapital pada huruf pertama sebuah kata.<\/p><h2 id=\"proper-function-to-capitalize-first-letter\" class=\"wp-block-heading\"> PROPER berfungsi untuk menggunakan huruf kapital pada huruf pertama<\/h2><p> Dalam contoh berikut, Anda memiliki daftar nama, dan semua nama tersebut menggunakan huruf kecil. Sekarang Anda perlu mengubah huruf pertama menjadi huruf besar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64150\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png\" sizes=\"auto, \" srcset=\"\" alt=\"huruf kapital pertama\" width=\"230\" height=\"299\"><\/figure><\/div><p> Gunakan langkah-langkah berikut untuk menggunakan huruf besar pada huruf pertama.<\/p><ol type=\"1\"><li> Ketik sama dengan di sel B2.<\/li><li> Masuk ke fungsi TEXT dan ketikkan tanda kurung di depannya.<\/li><li> Lihat sel A2 di mana Anda memiliki teks yang huruf pertamanya menggunakan huruf kapital.<\/li><li> Terakhir, masukkan tanda kurung tutup dan tekan Enter untuk melihat hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64151\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-bon-fonctionnement.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi sendiri\" width=\"463\" height=\"404\"><\/figure><\/div><h2 id=\"only-capitalize-first-letter-of-the-first-word\" class=\"wp-block-heading\"> Gunakan huruf kapital hanya pada huruf pertama pada kata pertama<\/h2><p> Sekarang mari kita ambil situasi lain di mana Anda hanya perlu menggunakan huruf kapital pada huruf pertama dari kata pertama dan bukan kata lainnya. Anda dapat menggunakan rumus berikut untuk ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=UPPER(LEFT(A2,1))&amp;LOWER(RIGHT(A2,LEN(A2)-1))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64152\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ne-mettre-en-majuscule-que-la-premiere-lettre.png\" sizes=\"auto, \" srcset=\"\" alt=\"hanya menggunakan huruf kapital pada huruf pertama\" width=\"536\" height=\"377\"><\/figure><\/div><p> Untuk memahami rumus ini, kita perlu membaginya menjadi dua bagian.<\/p><p> Bagian pertama rumus menggunakan fungsi UPPER dan LEFT yang mengekstrak huruf pertama dari teks dan mengubahnya menjadi huruf besar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64153\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-superieure.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi unggul\" width=\"259\" height=\"61\"><\/figure><\/div><p> Dan rumus bagian kedua menggunakan fungsi RIGHT, DOWN dan LEFT. Fungsi-fungsi ini mengambil sisa bagian teks dan mengubah bagian tersebut menjadi teks huruf kecil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64154\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fonction-inferieure.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi yang lebih rendah\" width=\"392\" height=\"62\"><\/figure><\/div><p> Namun jika Anda ingin menggunakan huruf pertama menggunakan huruf kapital dan ingin membiarkan sisa bagiannya seperti semula, Anda dapat mengubah rumus di atas. Lihat yang berikut ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=UPPER(LEFT(A2,1))&amp;RIGHT(A2,LEN(A2)-1)<\/code><\/pre><p> Rumus ini tidak akan melakukan perubahan apa pun pada teks selain huruf pertama dari kata pertama. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-la-premiere-lettre-en-majuscule-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\">Ubah Kolom menjadi Baris (Sebaliknya) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kasus-kalimat\/\">Beralih ke Kasus Kalimat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/\">Kembalikan nama depan dan belakang dan tambahkan koma di antaranya<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\">Mengubah huruf besar\/kecil (huruf besar, huruf kecil, benar)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1608","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggunakan huruf kapital pada huruf pertama di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara menggunakan huruf besar pada huruf pertama teks dalam sel menggunakan kombinasi fungsi.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan huruf kapital pada huruf pertama di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara menggunakan huruf besar pada huruf pertama teks dalam sel menggunakan kombinasi fungsi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/\",\"name\":\"Bagaimana cara menggunakan huruf kapital pada huruf pertama di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png\",\"datePublished\":\"2023-11-15T12:20:42+00:00\",\"dateModified\":\"2023-12-06T06:18:23+00:00\",\"description\":\"Dalam tutorial rumus ini, Anda akan mempelajari cara menggunakan huruf besar pada huruf pertama teks dalam sel menggunakan kombinasi fungsi.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan huruf kapital pada huruf pertama di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan huruf kapital pada huruf pertama di Excel?","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menggunakan huruf besar pada huruf pertama teks dalam sel menggunakan kombinasi fungsi.","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:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan huruf kapital pada huruf pertama di Excel?","og_description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menggunakan huruf besar pada huruf pertama teks dalam sel menggunakan kombinasi fungsi.","og_url":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:23+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/","url":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/","name":"Bagaimana cara menggunakan huruf kapital pada huruf pertama di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png","datePublished":"2023-11-15T12:20:42+00:00","dateModified":"2023-12-06T06:18:23+00:00","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menggunakan huruf besar pada huruf pertama teks dalam sel menggunakan kombinasi fungsi.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-premiere-lettre-en-majuscule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan huruf kapital pada huruf pertama di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1608"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1608\/revisions"}],"predecessor-version":[{"id":2717,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1608\/revisions\/2717"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}