{"id":2728,"date":"2023-07-20T23:49:18","date_gmt":"2023-07-20T23:49:18","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/"},"modified":"2023-07-20T23:49:18","modified_gmt":"2023-07-20T23:49:18","slug":"google-sheet-mengubah-teks-menjadi-angka","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/","title":{"rendered":"Google spreadsheet: cara mengonversi teks menjadi angka (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mengonversi teks menjadi angka di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ubah Teks menjadi Angka<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=VALUE( <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ubah Mata Uang menjadi Angka<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=TO_PURE_NUMBER( <span style=\"color: #ff6600;\">A1<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Ekstrak angka dari teks<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=SPLIT( <span style=\"color: #ff6600;\">A1<\/span> ,CONCATENATE(SPLIT( <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">.0123456789<\/span> \"<\/span> )))\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Ubah teks menjadi angka<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengubah teks di sel <strong>A2<\/strong> menjadi angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=VALUE( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa menyalin dan menempelkan rumus ini ke sel lainnya di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24020\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-1.jpg\" alt=\"Google Spreadsheet mengubah teks menjadi angka\" width=\"472\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semua sel di kolom B sekarang berupa angka.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memeriksanya, kita dapat mengetikkan <strong>=ISNUMBER(B2)<\/strong> di sel <strong>C2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24021 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-2.jpg\" alt=\"\" width=\"478\" height=\"443\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai di sel <strong>B2<\/strong> adalah angka karena fungsi <strong>ISNUMBER()<\/strong> mengembalikan <strong>TRUE<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Ubah mata uang menjadi angka<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengonversi nilai moneter di sel <strong>A2<\/strong> menjadi angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=TO_PURE_NUMBER( <span style=\"color: #ff6600;\">A2<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa menyalin dan menempelkan rumus ini ke sel lainnya di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24022 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-3.jpg\" alt=\"\" width=\"503\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semua sel di kolom B sekarang berupa angka.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memeriksanya, kita dapat mengetikkan <strong>=ISNUMBER(B2)<\/strong> di sel <strong>C2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24023 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-4.jpg\" alt=\"\" width=\"501\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai di sel <strong>B2<\/strong> adalah angka karena fungsi <strong>ISNUMBER()<\/strong> mengembalikan <strong>TRUE<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: mengekstrak angka dari teks<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengekstrak angka dari teks di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=SPLIT( <span style=\"color: #ff6600;\">A2<\/span> ,CONCATENATE(SPLIT( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">.0123456789<\/span> \"<\/span> )))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa menyalin dan menempelkan rumus ini ke sel lainnya di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24024 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-5.jpg\" alt=\"\" width=\"537\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semua sel di kolom B sekarang berupa angka.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memeriksanya, kita dapat mengetikkan <strong>=ISNUMBER(B2)<\/strong> di sel <strong>C2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24025 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero6.jpg\" alt=\"\" width=\"487\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai di sel <strong>B2<\/strong> adalah angka karena fungsi <strong>ISNUMBER()<\/strong> mengembalikan <strong>TRUE<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak substring di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-tanggal-menjadi-string\/\" target=\"_blank\" rel=\"noopener\">Cara mengonversi tanggal menjadi string di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengkonversi antara nama bulan dan nomor di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mengonversi teks menjadi angka di Google Spreadsheet: Metode 1: Ubah Teks menjadi Angka =VALUE( A1 ) Metode 2: Ubah Mata Uang menjadi Angka =TO_PURE_NUMBER( A1 ) Metode 3: Ekstrak angka dari teks =SPLIT( A1 ,CONCATENATE(SPLIT( A1 , &#8221; .0123456789 &#8221; ))) Contoh berikut menunjukkan cara menggunakan setiap rumus dalam [&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>Google Spreadsheet: Cara mengonversi teks menjadi angka (3 contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah teks menjadi angka di Google Sheets, 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\/google-sheet-mengubah-teks-menjadi-angka\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengonversi teks menjadi angka (3 contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah teks menjadi angka di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T23:49:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-1.jpg\" \/>\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\/google-sheet-mengubah-teks-menjadi-angka\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/\",\"name\":\"Google Spreadsheet: Cara mengonversi teks menjadi angka (3 contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T23:49:18+00:00\",\"dateModified\":\"2023-07-20T23:49:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah teks menjadi angka di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara mengonversi teks menjadi angka (3 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":"Google Spreadsheet: Cara mengonversi teks menjadi angka (3 contoh) - Statorial","description":"Tutorial ini menjelaskan cara mengubah teks menjadi angka di Google Sheets, 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\/google-sheet-mengubah-teks-menjadi-angka\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengonversi teks menjadi angka (3 contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara mengubah teks menjadi angka di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/","og_site_name":"Statorials","article_published_time":"2023-07-20T23:49:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numero-1.jpg"}],"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\/google-sheet-mengubah-teks-menjadi-angka\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/","name":"Google Spreadsheet: Cara mengonversi teks menjadi angka (3 contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T23:49:18+00:00","dateModified":"2023-07-20T23:49:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah teks menjadi angka di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengubah-teks-menjadi-angka\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara mengonversi teks menjadi angka (3 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\/2728"}],"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=2728"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2728\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}