{"id":4379,"date":"2023-07-11T13:52:32","date_gmt":"2023-07-11T13:52:32","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/"},"modified":"2023-07-11T13:52:32","modified_gmt":"2023-07-11T13:52:32","slug":"vba-menghapus-spasi-tambahan-di-depan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/","title":{"rendered":"Vba: cara menghapus spasi awal dan akhir"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghapus spasi di depan dan di belakang string menggunakan VBA:<\/span><\/p>\n

 Sub<\/span> RemoveLeadingTrailingSpaces()\n\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 7\n    Range(\" B<\/span> \" & i) = Trim(Range(\" A<\/span> \" & i))\n    Next<\/span> i\n    \nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini menghilangkan spasi di awal dan akhir dari setiap string dalam rentang A2:A7<\/strong> dan menampilkan hasilnya dalam rentang B2:B7<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Menggunakan VBA untuk Menghapus Spasi Awal dan Akhir dari String<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar string berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa banyak string memiliki spasi di awal atau di akhir.<\/span><\/p>\n
 Misalkan kita ingin menghapus spasi di awal dan akhir dari setiap string.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> RemoveLeadingTrailingSpaces()\n\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 7\n    Range(\" B<\/span> \" & i) = Trim(Range(\" A<\/span> \" & i))\n    Next<\/span> i\n    \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom B menampilkan masing-masing string di kolom A dengan spasi di depan dan di belakangnya dihilangkan.<\/span><\/p>\n
 Perhatikan bahwa jika Anda hanya ingin menghapus spasi awal dan akhir dari string, Anda dapat menggunakan fungsi LTrim<\/strong> atau RTrim<\/strong> masing-masing.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk masing-masing fungsi VBA Trim<\/b> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya menggunakan VBA:<\/span><\/p>\n
 VBA: Cara menghitung kemunculan karakter dalam sebuah string<\/a>
 VBA: cara memeriksa apakah suatu string berisi string lain<\/a>
 VBA: Cara menghitung sel dengan teks tertentu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghapus spasi di depan dan di belakang string menggunakan VBA: Sub RemoveLeadingTrailingSpaces() Dim i As Integer For i = 2 To 7 Range(” B ” & i) = Trim(Range(” A ” & i)) Next i End Sub Contoh khusus ini menghilangkan spasi di awal dan akhir dari setiap […]<\/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":"\nVBA: Cara menghapus spasi awal dan akhir - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus spasi awal dan akhir sel di Excel menggunakan VBA, 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\/vba-menghapus-spasi-tambahan-di-depan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghapus spasi awal dan akhir - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus spasi awal dan akhir sel di Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T13:52:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture1.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\/vba-menghapus-spasi-tambahan-di-depan\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/\",\"name\":\"VBA: Cara menghapus spasi awal dan akhir - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T13:52:32+00:00\",\"dateModified\":\"2023-07-11T13:52:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus spasi awal dan akhir sel di Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghapus spasi awal dan akhir\"}]},{\"@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":"VBA: Cara menghapus spasi awal dan akhir - Statologi","description":"Tutorial ini menjelaskan cara menghapus spasi awal dan akhir sel di Excel menggunakan VBA, 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\/vba-menghapus-spasi-tambahan-di-depan\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghapus spasi awal dan akhir - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus spasi awal dan akhir sel di Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/","og_site_name":"Statorials","article_published_time":"2023-07-11T13:52:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture1.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\/vba-menghapus-spasi-tambahan-di-depan\/","url":"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/","name":"VBA: Cara menghapus spasi awal dan akhir - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T13:52:32+00:00","dateModified":"2023-07-11T13:52:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus spasi awal dan akhir sel di Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghapus-spasi-tambahan-di-depan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghapus spasi awal dan akhir"}]},{"@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\/4379"}],"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=4379"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4379\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}