{"id":1388,"date":"2017-10-29T11:59:27","date_gmt":"2017-10-29T03:59:27","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=1388"},"modified":"2017-10-29T11:59:48","modified_gmt":"2017-10-29T03:59:48","slug":"trim-menghapuskan-ruangan-kosong-whitespace-pada-microsoft-excel","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/trim-menghapuskan-ruangan-kosong-whitespace-pada-microsoft-excel\/","title":{"rendered":"Trim &#8211; Menghapuskan ruangan kosong (whitespace) pada microsoft excel"},"content":{"rendered":"<p>Kali ini kita kongsi cara menghapuskan ruangan kosong yang terdapat di permulaan atau penghujung teks\/nombor pada Microsoft Excel.<\/p>\n<ol>\n<li>Kita boleh pilih (highlight) satu row atau column dan menggunakan fungsi find and replace.<\/li>\n<li>Kita boleh menggunakan formula trim iaitu =trim(text) atau =trim(A2), A2 adalah contoh posisi kandungan di dalam cell excel.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/rais.my\/blog\/wp-content\/uploads\/2017\/10\/microsoft-excel-trim.jpg\"><img  title=\"\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1390 size-full\" src=\"http:\/\/rais.my\/blog\/wp-content\/uploads\/2017\/10\/microsoft-excel-trim.jpg\"  alt=\"microsoft-excel-trim Trim - Menghapuskan ruangan kosong (whitespace) pada microsoft excel\"  width=\"388\" height=\"361\" srcset=\"https:\/\/rais.my\/blog\/wp-content\/uploads\/2017\/10\/microsoft-excel-trim.jpg 388w, https:\/\/rais.my\/blog\/wp-content\/uploads\/2017\/10\/microsoft-excel-trim-300x279.jpg 300w, https:\/\/rais.my\/blog\/wp-content\/uploads\/2017\/10\/microsoft-excel-trim-50x47.jpg 50w\" sizes=\"auto, (max-width: 388px) 100vw, 388px\" \/><\/a><\/p>\n<p>Satu lagi sekiranya formula trim gagal menghapuskan ruangan kosong tersebut, formula seperti di bawah boleh dicuba.<\/p>\n<p>=TRIM(SUBSTITUTE(A2, CHAR(160), &#8221; &#8220;))<\/p>\n<p>&nbsp;<\/p>\n<p>Selamat mencuba<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kali ini kita kongsi cara menghapuskan ruangan kosong yang terdapat di permulaan atau penghujung teks\/nombor pada Microsoft Excel. Kita boleh pilih (highlight) satu row atau column dan menggunakan fungsi find and replace. Kita boleh menggunakan formula trim iaitu =trim(text) atau =trim(A2), A2 adalah contoh posisi kandungan di dalam cell excel. Satu lagi sekiranya formula trim [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1389,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cybocfi_hide_featured_image":"","footnotes":""},"categories":[739,532],"tags":[520,519,370,741,692,740],"class_list":["post-1388","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-komputer","category-tip","tag-excel","tag-microsoft","tag-remove","tag-tips","tag-trick","tag-whotespace"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/comments?post=1388"}],"version-history":[{"count":2,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1388\/revisions"}],"predecessor-version":[{"id":1392,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1388\/revisions\/1392"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media\/1389"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=1388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=1388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=1388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}