{"id":1744,"date":"2023-11-08T00:26:59","date_gmt":"2023-11-08T00:26:59","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/"},"modified":"2023-12-06T06:18:11","modified_gmt":"2023-12-06T06:18:11","slug":"mengubah-huruf-besarkecil-teks","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/","title":{"rendered":"Bagaimana cara mengubah huruf besar\/kecil di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1981952016\"><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>Di Excel, ada tiga fungsi utama yang bisa Anda gunakan untuk mengubah huruf besar\/kecil string.<\/p><ul><li> UPPER untuk mengubah huruf besar\/kecil menjadi atas.<\/li><li> LOWER untuk mengubah housing menjadi lebih rendah.<\/li><li> SENDIRI untuk mengubah kapitalisasi huruf pertama setiap kata.<\/li><\/ul><p> Dalam tutorial ini, kita akan mempelajari cara menggunakan semua fungsi ini untuk menulis rumus kita.<\/p><h2 class=\"wp-block-heading\"> HURUF BESAR<\/h2><p> Di Excel, ada fungsi yang disebut UPPER CASE yang memungkinkan Anda mengubah huruf besar\/kecil string menjadi UPPER CASE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84417\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png\" sizes=\"auto, \" srcset=\"\" alt=\"huruf kapital\" width=\"409\" height=\"380\"><\/figure><\/div><p> Pada contoh di atas, kolom A berisi string (nilai teks) yang berbeda. Dan saat Anda menggunakan UPPER dan merujuk ke sel, nilai tersebut akan diubah menjadi teks huruf besar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=UPPER(A1)<\/code><\/pre><h2 class=\"wp-block-heading\"> HURUF BAWAH<\/h2><p> Demikian pula, Anda juga memiliki fungsi bernama Lower untuk mengonversi teks 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-84418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-minuscules.png\" sizes=\"auto, \" srcset=\"\" alt=\"kecil\" width=\"391\" height=\"367\"><\/figure><\/div><p> Dalam contoh di atas, ketika kita menggunakan fungsi \u201cHuruf Kecil\u201d dan mendapatkan semua karakter dalam nilai hasil sebagai huruf kecil. Fungsi ini bekerja persis berlawanan dengan fungsi \u201cAtas\u201d yang kita gunakan pada contoh pertama.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LOWER(A1)<\/code><\/pre><h2 class=\"wp-block-heading\"> KASUS YANG BAIK<\/h2><p> Dan kemudian kita memiliki fungsi PROPER, yang mengubah teks menjadi huruf besar di mana huruf pertama setiap kata menggunakan huruf kapital dan sisanya menggunakan huruf kecil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84419\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-bon-cas.png\" sizes=\"auto, \" srcset=\"\" alt=\"kasus sendiri\" width=\"423\" height=\"395\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=PROPER(A1)<\/code><\/pre><p> Anda dapat melihat pada contoh di atas; Huruf pertama pada kata tersebut menggunakan huruf kapital dan huruf lainnya menggunakan huruf kecil. Dan jika Anda memiliki dua kata, cara kerjanya sama.<\/p><p> Dan jika Anda ingin huruf pertama dari kata pertama menggunakan huruf kapital, dan sisa huruf serta kata lainnya menjadi huruf kecil, Anda dapat menggunakan rumus di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=UPPER(LEFT(A1,1))&amp;LOWER(RIGHT(A1,LEN(A1)-1))<\/code><\/pre><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\/11\/changer-de-cas.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\/menggunakan-huruf-kapital-pada-huruf-pertama\/\">Gunakan huruf besar pada huruf pertama di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\">Ubah kolom ke 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><\/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-1744","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 mengubah huruf besar\/kecil di Excel? (Panduan 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis beberapa rumus Excel untuk mengubah huruf besar\/kecil teks menggunakan tiga fungsi utama.\" \/>\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\/mengubah-huruf-besarkecil-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengubah huruf besar\/kecil di Excel? (Panduan 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis beberapa rumus Excel untuk mengubah huruf besar\/kecil teks menggunakan tiga fungsi utama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\",\"name\":\"Bagaimana cara mengubah huruf besar\/kecil di Excel? (Panduan 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png\",\"datePublished\":\"2023-11-08T00:26:59+00:00\",\"dateModified\":\"2023-12-06T06:18:11+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis beberapa rumus Excel untuk mengubah huruf besar\/kecil teks menggunakan tiga fungsi utama.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah huruf besar\/kecil 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 mengubah huruf besar\/kecil di Excel? (Panduan 2023)","description":"Tutorial ini akan mengajarkan Anda cara menulis beberapa rumus Excel untuk mengubah huruf besar\/kecil teks menggunakan tiga fungsi utama.","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\/mengubah-huruf-besarkecil-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengubah huruf besar\/kecil di Excel? (Panduan 2023)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis beberapa rumus Excel untuk mengubah huruf besar\/kecil teks menggunakan tiga fungsi utama.","og_url":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/","url":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/","name":"Bagaimana cara mengubah huruf besar\/kecil di Excel? (Panduan 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png","datePublished":"2023-11-08T00:26:59+00:00","dateModified":"2023-12-06T06:18:11+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis beberapa rumus Excel untuk mengubah huruf besar\/kecil teks menggunakan tiga fungsi utama.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-majuscule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah huruf besar\/kecil 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\/1744","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=1744"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1744\/revisions"}],"predecessor-version":[{"id":2693,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1744\/revisions\/2693"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}