{"id":5059,"date":"2023-07-04T09:48:45","date_gmt":"2023-07-04T09:48:45","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/"},"modified":"2023-07-04T09:48:45","modified_gmt":"2023-07-04T09:48:45","slug":"excel-hapus-2-digit-pertama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/","title":{"rendered":"Cara menghapus 2 digit pertama sel di excel"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin menghapus 2 digit pertama dari sel di Excel.<\/span><\/p>\n

Anda dapat menggunakan fungsi RIGHT<\/b> yang dikombinasikan dengan fungsi LEN<\/b> untuk melakukan hal ini:<\/span><\/p>\n

 =RIGHT( A2<\/span> ,LEN( A2<\/span> )-2)\n<\/strong><\/pre>\n
 Rumus khusus ini menghilangkan 2 digit pertama dari sel A2<\/strong> .<\/span><\/p>\n
 Misalnya, jika sel A2<\/strong> berisi AA4506<\/strong> , rumus ini hanya akan mengembalikan 4506<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: menghapus 2 digit pertama sel di Excel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar ID karyawan berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menghapus dua digit pertama dari setiap ID karyawan.<\/span><\/p>\n
 Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel B2<\/strong> :<\/span><\/p>\n
 =RIGHT( A2<\/span> ,LEN( A2<\/span> )-2)<\/strong><\/pre>\n
 Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n
\"Excel<\/p>\n
 Kolom B sekarang menampilkan ID karyawan di kolom A dengan dua digit pertama dihapus dari setiap ID karyawan.<\/span><\/p>\n
 Bagaimana cara kerja rumus ini?<\/strong><\/span><\/h2>\n
 Fungsi RIGHT()<\/strong> di Excel mengekstrak sejumlah karakter tertentu dari sisi kanan string.<\/span><\/p>\n
 Fungsi LEN()<\/strong> di Excel digunakan untuk mencari panjang string.<\/span><\/p>\n
 Jadi rumus kami memberitahu Excel untuk mengekstrak jumlah karakter yang sama dengan panjang string dikurangi dua karakter.<\/span><\/p>\n
 Jadi rumus kami menampilkan seluruh string dengan dua digit pertama dihilangkan.<\/span><\/p>\n
 Catatan<\/strong> : Spasi kosong di awal string dihitung sebagai karakter. Anda mungkin perlu menghapus ruang kosong terlebih dahulu untuk mencapai hasil yang diinginkan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n
 Cara menghapus teks tertentu dari sel di Excel<\/a>
 Cara menghilangkan tanda kurung di excel<\/a>
Cara menghapus karakter khusus di excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin ingin menghapus 2 digit pertama dari sel di Excel. Anda dapat menggunakan fungsi RIGHT yang dikombinasikan dengan fungsi LEN untuk melakukan hal ini: =RIGHT( A2 ,LEN( A2 )-2) Rumus khusus ini menghilangkan 2 digit pertama dari sel A2 . Misalnya, jika sel A2 berisi AA4506 , rumus ini hanya akan mengembalikan 4506 […]<\/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":"\nCara menghapus 2 digit pertama sel di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus 2 digit pertama sel di Excel, beserta contohnya.\" \/>\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-hapus-2-digit-pertama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghapus 2 digit pertama sel di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus 2 digit pertama sel di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T09:48:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remo1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/\",\"name\":\"Cara menghapus 2 digit pertama sel di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T09:48:45+00:00\",\"dateModified\":\"2023-07-04T09:48:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus 2 digit pertama sel di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus 2 digit pertama sel di excel\"}]},{\"@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 2 digit pertama sel di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghapus 2 digit pertama sel di Excel, beserta contohnya.","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-hapus-2-digit-pertama\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghapus 2 digit pertama sel di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus 2 digit pertama sel di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/","og_site_name":"Statorials","article_published_time":"2023-07-04T09:48:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remo1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/","url":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/","name":"Cara menghapus 2 digit pertama sel di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T09:48:45+00:00","dateModified":"2023-07-04T09:48:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus 2 digit pertama sel di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hapus-2-digit-pertama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus 2 digit pertama sel di excel"}]},{"@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\/5059"}],"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=5059"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5059\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}