{"id":9826,"date":"2025-01-03T14:48:25","date_gmt":"2025-01-03T14:48:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/tim-hieu-2-cach-bo-khoang-trang-thua-trong-excel-thong-dung-nhat\/"},"modified":"2025-01-03T14:48:25","modified_gmt":"2025-01-03T14:48:25","slug":"tim-hieu-2-cach-bo-khoang-trang-thua-trong-excel-thong-dung-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/tim-hieu-2-cach-bo-khoang-trang-thua-trong-excel-thong-dung-nhat\/","title":{"rendered":"T\u00ecm hi\u1ec3u 2 c\u00e1ch b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba trong excel th\u00f4ng d\u1ee5ng nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 2 c\u00e1ch b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba trong excel th\u00f4ng d\u1ee5ng \u0111\u01a1n gi\u1ea3n \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi \u00e1p d\u1ee5ng nh\u1ea5t.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6777f8b91d31c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/2-cach-bo-khoang-trang-thua-trong-excel-thong-dung.html#Su_dung_chuc_nang_Find_Replace_thay_the_ki_tu_trang_trong_Excel\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Find &amp; Replace\u00a0thay th\u1ebf k\u00ed t\u1ef1\u00a0tr\u1eafng trong Excel\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Find &amp; Replace\u00a0thay th\u1ebf k\u00ed t\u1ef1\u00a0tr\u1eafng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/2-cach-bo-khoang-trang-thua-trong-excel-thong-dung.html#Su_dung_ham_bo_khoang_trang_thua_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m b\u1ecf\u00a0kho\u1ea3ng\u00a0tr\u1eafng th\u1eeba trong Excel\">S\u1eed d\u1ee5ng h\u00e0m b\u1ecf\u00a0kho\u1ea3ng\u00a0tr\u1eafng th\u1eeba trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_Find_Replace_thay_the_ki_tu_trang_trong_Excel\"><\/span>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Find &amp; Replace\u00a0thay th\u1ebf k\u00ed t\u1ef1\u00a0tr\u1eafng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ee9c n\u0103ng\u00a0<strong>Find<\/strong> gi\u00fap ta t\u00ecm \u0111\u01b0\u1ee3c k\u00ed t\u1ef1 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n nh\u1eadp v\u00e0o thu\u1ed9c v\u00f9ng d\u1eef li\u1ec7u, trong khi ch\u1ee9c n\u0103ng\u00a0<strong>Replace<\/strong> cho ph\u00e9p ta thay th\u1ebf k\u00ed t\u1ef1 \u0111\u00f3 b\u1eb1ng k\u00ed t\u1ef1 kh\u00e1c.<\/p>\n<p>\u00a0<\/p>\n<p>V\u00ed d\u1ee5, ta s\u1ebd s\u1eed d\u1ee5ng\u00a0<strong>Find &amp; Replace (ph\u00edm t\u1eaft: Ctrl + H)\u00a0<\/strong>\u0111\u1ec3 thay th\u1ebf c\u00e1c k\u00ed t\u1ef1 tr\u1eafng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-23347\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-1-1024x377-1.gif\" width=\"1024\" height=\"377\" title=\"xoa-1-1024x377-1\"><\/p>\n<p>Tuy nhi\u00ean, ch\u1ee9c n\u0103ng\u00a0<strong>Find &amp; Replace\u00a0<\/strong>s\u1ebd g\u1eb7p m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf. C\u1ee5 th\u1ec3 nh\u1eefng h\u1ea1n ch\u1ebf ra sao, h\u00e3y \u0111\u1ecdc ph\u1ea7n b\u00ean d\u01b0\u1edbi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_bo_khoang_trang_thua_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m b\u1ecf\u00a0kho\u1ea3ng\u00a0tr\u1eafng th\u1eeba trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e3y \u0111\u1ebfn v\u1edbi 2 tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-98.gif\" title=\"ex101_92019-nho-98\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23342\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-khoang-trang-2.png\" width=\"620\" height=\"439\" title=\"xoa-khoang-trang-2\"><\/p>\n<p>R\u1ed3i, b\u00e2y gi\u1edd h\u00e3y th\u1eed t\u01b0\u1edfng t\u01b0\u1ee3ng xem, n\u1ebfu 1 \u00f4 k\u1ebft h\u1ee3p c\u1ea3 3 tr\u01b0\u1eddng h\u1ee3p tr\u00ean, ta s\u1ebd ph\u1ea3i thao t\u00e1c Find &amp; Replace t\u1edbi 3 l\u1ea7n, m\u00e0 ch\u01b0a k\u1ec3 m\u1ed7i \u00f4 1 ki\u1ec3u kh\u00e1c nhau ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 m\u1ed9t gi\u1ea3i ph\u00e1p thay th\u1ebf:<\/p>\n<p>Tr\u01b0\u1edbc ti\u00ean, ta s\u1ebd d\u00f9ng h\u00e0m\u00a0<strong>CODE<\/strong> x\u00e1c \u0111\u1ecbnh lo\u1ea1i k\u00ed t\u1ef1 tr\u1eafng l\u00e0 g\u00ec.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23343\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-khoang-trang-3.png\" width=\"803\" height=\"438\" title=\"xoa-khoang-trang-3\"><\/p>\n<p>Sau khi c\u00f3 k\u00ed t\u1ef1, ta ti\u1ebfn h\u00e0nh thay th\u1ebf b\u1eb1ng h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23344\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-khoang-trang-4.png\" width=\"878\" height=\"430\" title=\"xoa-khoang-trang-4\"><\/p>\n<blockquote>\n<p><strong>Xem th\u00eam:<\/strong><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-bo-khoang-trong-thua-trong-excel.html\">C\u00f4ng th\u1ee9c b\u1ecf kho\u1ea3ng tr\u1ed1ng th\u1eeba trong Excel hi\u1ec7u qu\u1ea3<\/a><\/p>\n<\/blockquote>\n<p>Kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o? Tuy nhi\u00ean \u0111\u00e2y ch\u1ec9 l\u00e0 nh\u1eefng v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t, m\u00e0 trong th\u1ef1c t\u1ebf s\u1ebd c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u k\u0129 n\u0103ng c\u0169ng nh\u01b0 v\u1eadn d\u1ee5ng cao h\u01a1n. B\u1edfi v\u1eady, \u0111\u1eebng qu\u00ean vi\u1ec7c t\u00ecm t\u00f2i v\u00e0 luy\u1ec7n t\u1eadp kh\u00f4ng ng\u1eebng \u0111\u1ec3 tr\u1edf n\u00ean th\u00e0nh th\u1ea1o h\u01a1n nh\u00e9!<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-98.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9827,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9826","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9826"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9826\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9827"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}