{"id":4762,"date":"2023-07-08T05:15:23","date_gmt":"2023-07-08T05:15:23","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/"},"modified":"2023-07-08T05:15:23","modified_gmt":"2023-07-08T05:15:23","slug":"excel-menghapus-awalan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/","title":{"rendered":"Cara menghapus awalan di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan salah satu rumus berikut untuk menghapus awalan dari sel di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Formula 1: Gunakan RIGHT dan LEN untuk menghilangkan awalan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RIGHT( <span style=\"color: #3366ff;\">A2<\/span> ,LEN( <span style=\"color: #3366ff;\">A2<\/span> )-3)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan menghapus 3 karakter pertama teks di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini berguna ketika 3 karakter pertama mewakili awalan yang ingin Anda hapus, namun awalan mungkin berbeda untuk setiap sel dalam suatu rentang.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Gunakan TEXTAFTER untuk menghilangkan awalan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> , \"EMP\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini hanya akan mengekstrak teks setelah string &#8220;EMP&#8221; di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini berguna ketika setiap sel dalam suatu rentang memiliki awalan yang sama (misalnya &#8220;EMP&#8221;) dan Anda hanya ingin mengekstrak teks setelah awalan tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan RIGHT dan LEN untuk menghilangkan awalan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang berisi nomor identifikasi beserta total penjualan berbagai karyawan suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37182 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prefixe3.png\" alt=\"\" width=\"500\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap ID karyawan memiliki awalan tiga huruf sebelum nomor ID.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk menghapus awalan ini dari sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RIGHT( <span style=\"color: #3366ff;\">A2<\/span> ,LEN( <span style=\"color: #3366ff;\">A2<\/span> )-3)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37183 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prefixe4.png\" alt=\"\" width=\"552\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sekarang berisi setiap nilai ID karyawan di kolom A dengan awalan dihapus.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan TEXTAFTER untuk menghapus awalan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang berisi nomor identifikasi beserta total penjualan berbagai karyawan suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37180 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prefixe1.png\" alt=\"\" width=\"502\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap ID karyawan memiliki awalan &#8220;EMP&#8221; yang sama sebelum nomor ID.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk menghapus awalan \u201cEMP\u201d ini dari sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> , \"EMP\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37181\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prefixe2.png\" alt=\"Excel menghapus awalan menggunakan fungsi TEXTAFTER\" width=\"516\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa awalan &#8220;EMP&#8221; telah dihapus dari setiap sel di kolom C.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <b>TEXTAFTER<\/b> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menghapus teks tertentu dari sel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghapus karakter khusus<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menyisipkan-karakter-ke-dalam-string\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara memasukkan karakter ke dalam string<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan salah satu rumus berikut untuk menghapus awalan dari sel di Excel: Formula 1: Gunakan RIGHT dan LEN untuk menghilangkan awalan =RIGHT( A2 ,LEN( A2 )-3) Contoh khusus ini akan menghapus 3 karakter pertama teks di sel A2 . Rumus ini berguna ketika 3 karakter pertama mewakili awalan yang ingin Anda hapus, namun [&hellip;]<\/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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menghapus Awalan di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus awalan dari sel di Excel, dengan beberapa contoh.\" \/>\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\/id\/excel-menghapus-awalan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Awalan di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus awalan dari sel di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T05:15:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prefixe3.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/\",\"name\":\"Cara Menghapus Awalan di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T05:15:23+00:00\",\"dateModified\":\"2023-07-08T05:15:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus awalan dari sel di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus awalan di excel (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menghapus Awalan di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus awalan dari sel di Excel, dengan beberapa contoh.","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\/id\/excel-menghapus-awalan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Awalan di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus awalan dari sel di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/","og_site_name":"Statorials","article_published_time":"2023-07-08T05:15:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prefixe3.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/","url":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/","name":"Cara Menghapus Awalan di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T05:15:23+00:00","dateModified":"2023-07-08T05:15:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus awalan dari sel di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghapus-awalan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghapus-awalan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus awalan di excel (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4762"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4762"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4762\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}