{"id":1708,"date":"2023-11-10T10:28:08","date_gmt":"2023-11-10T10:28:08","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/"},"modified":"2023-12-06T06:17:44","modified_gmt":"2023-12-06T06:17:44","slug":"menghitung-karakter-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/","title":{"rendered":"Bagaimana cara menghitung karakter di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3629427024\"><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>Dalam tutorial ini, kita akan mempelajari cara menulis berbagai rumus di Excel untuk menghitung jumlah karakter dalam sel atau rentang sel.<\/p><h2 class=\"wp-block-heading\"> Hitung karakter dalam satu sel<\/h2><p> Untuk menghitung karakter dalam sel, Anda harus memasukkan fungsi LEN di sel yang ingin Anda dapatkan nomornya. Setelah itu, lihat sel (A1). Pada akhirnya, tekan Enter untuk menghitung. Jika Anda memiliki beberapa sel, Anda juga bisa menerapkan rumus yang sama ke sel tersebut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LEN(B1)<\/code><\/pre><h2 class=\"wp-block-heading\"> Hitung karakter tanpa spasi<\/h2><p> Jika Anda memiliki satu spasi atau beberapa spasi dalam satu sel, dalam hal ini Anda dapat menggunakan rumus berikut dimana kami telah menggunakan kombinasi LEN dan SUBSTITUTE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79309\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung-karakter-tanpa spasi\" width=\"525\" height=\"269\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LEN(SUBSTITUTE(A1,\" \",\"\"))<\/code><\/pre><p> Dalam rumus ini, kami menggunakan SUBSTITUTE untuk menggantikan spasi antara &#8220;Halo&#8221; dan &#8220;Dunia!&#8221; \u00bb dengan nilai kosong.<\/p><h2 class=\"wp-block-heading\"> Hitung karakter dalam suatu rentang<\/h2><p> Jika Anda memiliki rentang sel dan ingin menghitung karakter di seluruh rentang tersebut, Anda dapat menggunakan kombinasi SUMPRODUK dan LEN.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(LEN(A1:A3))<\/code><\/pre><p> Saat Anda menggunakan SUMPRODUK, ini bisa mengambil tabel dalam satu sel. Dengan cara ini dibutuhkan nilai semua sel (3) dalam rentang tersebut. Dan di antara SUMPRODUK, LEN mendapatkan jumlah karakter.<\/p><p> Jika Anda memiliki sel atau beberapa sel yang memiliki spasi pada nilainya dan Anda tidak ingin menghitung spasi tersebut saat menghitung karakter. Anda harus membuat kombinasi SUMPRODUK, LEN dan SUBSTITUTE.<\/p><p> Dalam contoh di atas, kita memiliki angka 36 ketika Anda memasukkan spasi sambil mendapatkan jumlah karakter. Namun bila kita menggunakan rumus (SUMPRODUK, SUBSTITUTE dan LEN).<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(LEN(SUBSTITUTE(A1:A3,\" \",\"\")))<\/code><\/pre><h2 class=\"wp-block-heading\"> Hitung karakter tertentu dari sel atau rentang<\/h2><p> Misalkan Anda ingin mendapatkan jumlah karakter tertentu dari sebuah sel, Anda dapat melakukannya dengan menggabungkan LEN dan SUBSTITUTE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79312\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-compter-un-caractere-specifique.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung karakter tertentu\" width=\"593\" height=\"302\"><\/figure><\/div><p> Pada contoh di atas, kami menggunakan rumus untuk menghitung tanda bintang (*) dari sel. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LEN(A1)-LEN(SUBSTITUTE(A1,\"*\",\"\"))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79313\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-comprendre-len-et-remplacer-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"memahami-len-dan-fungsi pengganti\" width=\"549\" height=\"118\"><\/figure><\/div><p> Fungsi ini bekerja dalam dua bagian:<\/p><ul><li> Pada bagian pertama, Anda memiliki fungsi LEN yang mendapatkan jumlah total karakter dalam sel.<\/li><li> Di bagian kedua Anda memiliki SUBSTITUTE yang menggantikan (*) tanpa nilai. Setelah itu, LEN mengembalikan jumlah karakter tanpa tanda bintang.<\/li><\/ul><p> Pada akhirnya, Anda memiliki dua akun, satu dengan (*) dan yang lainnya tanpa (*). Dan ketika Anda mengurangi keduanya, Anda mendapatkan angka (*) pada hasilnya.<\/p><p> Demikian pula, jika Anda ingin menghitung karakter tertentu dari rentang sel dan Anda perlu menggabungkan rumus di atas dalam fungsi SUMPRODUK dan merujuk ke seluruh rentang, bukan satu sel. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(LEN(A1:A7)-LEN(SUBSTITUTE(A1:A7,\"*\",\"\")))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79314\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumproduct-et-fonction-len.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi sumproduct-dan-len\" width=\"574\" height=\"402\"><\/figure><\/div><p> Saat Anda menggunakan SUMPRODUK, ia mengambil seluruh rentang sebagai tabel dan menggunakan rumus untuk seluruh rentang, bukan hanya satu sel. Itu berarti:<\/p><p> Di bagian pertama Anda mendapatkan jumlah total karakter dari seluruh rentang, dan di bagian kedua, SUBSTITUTE, hapus (*) dan LEN mendapatkan nomornya. Dan setelah itu, dengan mengurangi kedua hitungan tersebut, Anda mendapatkan jumlah karakter tertentu pada hasilnya. <\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/compter-les-caracteres.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/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-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghasilkan-kelompok-acak\/\">Hasilkan grup acak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bandingkan-saluran-2\/\">Bandingkan dua string (teks)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mendapatkan-domain\/\">Dapatkan domain dari id email<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ekstrak-hanya-angka\/\">Ekstrak hanya angka dari teks (string)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/teks-setelah-sebelumnya\/\">Ekstrak teks setelah dan sebelum karakter di Excel<\/a><\/li><\/ul><\/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-1708","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 menghitung karakter di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung karakter dalam sel atau rentang sel.\" \/>\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\/menghitung-karakter-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghitung karakter di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung karakter dalam sel atau rentang sel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.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\/menghitung-karakter-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/\",\"name\":\"Bagaimana cara menghitung karakter di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\",\"datePublished\":\"2023-11-10T10:28:08+00:00\",\"dateModified\":\"2023-12-06T06:17:44+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung karakter dalam sel atau rentang sel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung karakter 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 menghitung karakter di Excel? (Tutorial 2023)","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung karakter dalam sel atau rentang sel.","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\/menghitung-karakter-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghitung karakter di Excel? (Tutorial 2023)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung karakter dalam sel atau rentang sel.","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.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\/menghitung-karakter-2\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/","name":"Bagaimana cara menghitung karakter di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png","datePublished":"2023-11-10T10:28:08+00:00","dateModified":"2023-12-06T06:17:44+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung karakter dalam sel atau rentang sel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-karakter-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung karakter 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\/1708","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=1708"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1708\/revisions"}],"predecessor-version":[{"id":2636,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1708\/revisions\/2636"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}