{"id":2348,"date":"2023-07-22T16:23:55","date_gmt":"2023-07-22T16:23:55","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/"},"modified":"2023-07-22T16:23:55","modified_gmt":"2023-07-22T16:23:55","slug":"google-sheet-menggantikan-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/","title":{"rendered":"Cara mengganti teks di google sheets (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Tutorial ini menjelaskan cara menggunakan Temukan dan Ganti<\/strong> untuk mengganti teks tertentu di Google Spreadsheet.<\/span><\/p>\n

Contoh: Cara mengganti teks di Google Sheets<\/strong><\/span><\/h3>\n

Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n

\"\"<\/p>\n

Katakanlah kita ingin mengubah teks dari “Barat” menjadi “W” dan “Timur” menjadi “E” di kolom Konferensi.<\/span><\/p>\n

Untuk melakukan ini, sorot kolom Konferensi:<\/span> <\/p>\n

\"\"<\/p>\n

Kemudian klik pada tab Edit<\/strong> dan klik Temukan dan Ganti<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela Temukan dan Ganti<\/strong> yang muncul, ketik “Barat” di kotak Temukan<\/strong> dan “W” di kotak Ganti dengan<\/strong> , lalu klik Ganti Semua<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Masing-masing nilai \u201cBarat\u201d secara otomatis akan digantikan dengan \u201cW\u201d pada kolom Konferensi:<\/span> <\/p>\n

\"\"<\/p>\n

Kemudian, di jendela Temukan dan Ganti<\/strong> , ketik “Is” di kotak Temukan<\/strong> dan “E” di kotak Ganti dengan<\/strong> , lalu klik Ganti Semua<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Setiap nilai \u201cTimur\u201d otomatis akan tergantikan dengan \u201cE\u201d pada kolom Konferensi:<\/span> <\/p>\n

\"\"<\/p>\n

Anda dapat menggunakan proses yang sama persis untuk menemukan dan mengganti sejumlah nilai yang Anda inginkan dalam spreadsheet.<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n

Bagaimana cara mengganti sel kosong dengan nol di Google Sheets<\/a>
Bagaimana cara memeriksa apakah nilainya dalam jangkauan di Google Sheets<\/a>
Cara menambah nilai secara otomatis di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Tutorial ini menjelaskan cara menggunakan Temukan dan Ganti untuk mengganti teks tertentu di Google Spreadsheet. Contoh: Cara mengganti teks di Google Sheets Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai tim bola basket: Katakanlah kita ingin mengubah teks dari “Barat” menjadi “W” dan “Timur” menjadi “E” di kolom Konferensi. […]<\/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 Mengganti Teks di Google Sheets (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti teks 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-menggantikan-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengganti Teks di Google Sheets (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti teks di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T16:23:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacertexte1.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\/google-sheet-menggantikan-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/\",\"name\":\"Cara Mengganti Teks di Google Sheets (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T16:23:55+00:00\",\"dateModified\":\"2023-07-22T16:23:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti teks di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengganti teks di google sheets (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 Mengganti Teks di Google Sheets (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengganti teks 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-menggantikan-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengganti Teks di Google Sheets (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengganti teks di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-22T16:23:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacertexte1.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\/google-sheet-menggantikan-teks\/","url":"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/","name":"Cara Mengganti Teks di Google Sheets (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T16:23:55+00:00","dateModified":"2023-07-22T16:23:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti teks di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengganti teks di google sheets (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\/2348"}],"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=2348"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2348\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}