{"id":3605,"date":"2023-07-16T14:17:54","date_gmt":"2023-07-16T14:17:54","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/"},"modified":"2023-07-16T14:17:54","modified_gmt":"2023-07-16T14:17:54","slug":"google-sheet-ganti-spasi-dengan-tanda-hubung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/","title":{"rendered":"Google spreadsheet: cara mengganti spasi dengan dash"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk mengganti spasi dengan tanda hubung di Google Sheets adalah dengan menggunakan fungsi <strong>Temukan dan Ganti<\/strong> di tab <strong>Edit<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Ganti spasi dengan tanda hubung di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan berbagai perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29702 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret1.jpg\" alt=\"\" width=\"503\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mengganti sel kosong di kolom Perusahaan dengan tanda hubung.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot rentang sel <strong>A2:A10<\/strong> sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29703 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret2.jpg\" alt=\"\" width=\"519\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Edit<\/strong> , lalu klik <strong>Temukan dan Ganti<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29704 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret3.jpg\" alt=\"\" width=\"465\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, ketikkan spasi di kotak <strong>Temukan<\/strong> , lalu ketikkan tanda hubung di kotak <strong>Ganti<\/strong> dengan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29705 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret4.jpg\" alt=\"\" width=\"656\" height=\"582\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Ganti Semua<\/strong> , lalu klik <strong>Selesai<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap spasi pada kolom Perusahaan secara otomatis akan digantikan oleh tanda hubung:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29706 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret5.jpg\" alt=\"\" width=\"507\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Pastikan untuk mengklik <strong>Ganti Semua<\/strong> sebelum mengklik tombol <strong>Selesai<\/strong> . Ini adalah kesalahan umum yang dilakukan orang yang mengakibatkan spasi tidak diganti dengan tanda hubung.<\/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 tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti teks di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti sel kosong dengan nol di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk mengganti spasi dengan tanda hubung di Google Sheets adalah dengan menggunakan fungsi Temukan dan Ganti di tab Edit . Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Ganti spasi dengan tanda hubung di Google Spreadsheet Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan berbagai perusahaan: Katakanlah kita ingin [&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 Sheets: Cara mengganti spasi dengan Dash - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti spasi dengan tanda hubung di Google Sheets, 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\/google-sheet-ganti-spasi-dengan-tanda-hubung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: Cara mengganti spasi dengan Dash - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti spasi dengan tanda hubung di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T14:17:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret1.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=\"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-ganti-spasi-dengan-tanda-hubung\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/\",\"name\":\"Google Sheets: Cara mengganti spasi dengan Dash - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T14:17:54+00:00\",\"dateModified\":\"2023-07-16T14:17:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti spasi dengan tanda hubung di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara mengganti spasi dengan dash\"}]},{\"@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 Sheets: Cara mengganti spasi dengan Dash - Statorials","description":"Tutorial ini menjelaskan cara mengganti spasi dengan tanda hubung di Google Sheets, 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\/google-sheet-ganti-spasi-dengan-tanda-hubung\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: Cara mengganti spasi dengan Dash - Statorials","og_description":"Tutorial ini menjelaskan cara mengganti spasi dengan tanda hubung di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/","og_site_name":"Statorials","article_published_time":"2023-07-16T14:17:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tiret1.jpg"}],"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-ganti-spasi-dengan-tanda-hubung\/","url":"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/","name":"Google Sheets: Cara mengganti spasi dengan Dash - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T14:17:54+00:00","dateModified":"2023-07-16T14:17:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti spasi dengan tanda hubung di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-ganti-spasi-dengan-tanda-hubung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara mengganti spasi dengan dash"}]},{"@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\/3605"}],"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=3605"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3605\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}