{"id":5006,"date":"2023-07-05T05:58:12","date_gmt":"2023-07-05T05:58:12","guid":{"rendered":"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/"},"modified":"2023-07-05T05:58:12","modified_gmt":"2023-07-05T05:58:12","slug":"ekstrak-alamat-email-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/","title":{"rendered":"Excel: cara mengekstrak alamat email dari string teks"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk mengekstrak alamat email dari string teks di Excel:<\/span><\/p>\n

 =IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT( A2<\/span> ,FIND(\" \", A2<\/span> &\" \",FIND(\"@\", A2<\/span> ))-1),\" \",REPT(\" \",LEN( A2<\/span> ))) ,LEN( A2<\/span> ))), \"\")\n<\/span><\/span><\/strong><\/pre>\n
 Rumus khusus ini mengekstrak alamat email dari string teks di sel A2<\/strong> .<\/span><\/p>\n
 Jika tidak ada alamat email yang ditemukan di sel A2<\/strong> , rumusnya hanya mengembalikan kosong.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Cara mengekstrak alamat email dari string teks di Excel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kolom string teks berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin mengekstrak alamat email dari setiap string teks.<\/span><\/p>\n
 Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel B2<\/strong> :<\/span><\/p>\n
 =IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT( A2<\/span> ,FIND(\" \", A2<\/span> &\" \",FIND(\"@\", A2<\/span> ))-1),\" \",REPT(\" \",LEN( A2<\/span> ))) ,LEN( A2<\/span> ))), \"\")\n<\/span><\/span><\/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 berisi alamat email untuk setiap string teks di kolom A.<\/span><\/p>\n
 Perhatikan bahwa sel A5<\/strong> tidak berisi alamat email, jadi rumusnya hanya mengembalikan nilai kosong.<\/span><\/p>\n
 Catatan<\/strong> : Jika sel berisi beberapa alamat email, rumus ini hanya akan mengembalikan alamat email pertama.<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n
 Excel: Cara mengekstrak URL dari hyperlink<\/a>
Excel: Cara mengekstrak tanggal dari string teks<\/a>
 Excel: Cara mengekstrak teks di antara dua koma<\/a>
 Excel: Cara mengekstrak angka dari string<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut untuk mengekstrak alamat email dari string teks di Excel: =IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT( A2 ,FIND(” “, A2 &” “,FIND(“@”, A2 ))-1),” “,REPT(” “,LEN( A2 ))) ,LEN( A2 ))), “”) Rumus khusus ini mengekstrak alamat email dari string teks di sel A2 . Jika tidak ada alamat email yang ditemukan di sel A2 , […]<\/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":"\nExcel: Cara mengekstrak alamat email dari string teks - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak alamat email dari string teks di Excel, dengan sebuah 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\/ekstrak-alamat-email-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengekstrak alamat email dari string teks - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak alamat email dari string teks di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T05:58:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/email1.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\/ekstrak-alamat-email-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/\",\"name\":\"Excel: Cara mengekstrak alamat email dari string teks - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T05:58:12+00:00\",\"dateModified\":\"2023-07-05T05:58:12+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak alamat email dari string teks di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengekstrak alamat email dari string teks\"}]},{\"@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":"Excel: Cara mengekstrak alamat email dari string teks - Statologi","description":"Tutorial ini menjelaskan cara mengekstrak alamat email dari string teks di Excel, dengan sebuah 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\/ekstrak-alamat-email-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengekstrak alamat email dari string teks - Statologi","og_description":"Tutorial ini menjelaskan cara mengekstrak alamat email dari string teks di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-05T05:58:12+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/email1.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\/ekstrak-alamat-email-excel\/","url":"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/","name":"Excel: Cara mengekstrak alamat email dari string teks - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T05:58:12+00:00","dateModified":"2023-07-05T05:58:12+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak alamat email dari string teks di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ekstrak-alamat-email-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengekstrak alamat email dari string teks"}]},{"@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\/5006"}],"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=5006"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5006\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}