{"id":9840,"date":"2025-01-03T16:11:50","date_gmt":"2025-01-03T16:11:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/tim-hieu-ve-cong-thuc-bo-khoang-trong-thua-trong-excel-hieu-qua-nhat\/"},"modified":"2025-01-03T16:11:50","modified_gmt":"2025-01-03T16:11:50","slug":"tim-hieu-ve-cong-thuc-bo-khoang-trong-thua-trong-excel-hieu-qua-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/tim-hieu-ve-cong-thuc-bo-khoang-trong-thua-trong-excel-hieu-qua-nhat\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 c\u00f4ng th\u1ee9c b\u1ecf kho\u1ea3ng tr\u1ed1ng th\u1eeba trong Excel hi\u1ec7u qu\u1ea3 nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi b\u1ea1n d\u00e1n d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n b\u00ean ngo\u00e0i v\u00e0o trang trang t\u00ednh Excel nh\u01b0 c\u00e1c b\u1ea3ng report, s\u1ed1 li\u1ec7u web, b\u1ea1n s\u1ebd th\u01b0\u1eddng g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p c\u00f3 qu\u00e1 nhi\u1ec1u k\u00ed t\u1ef1 tr\u1eafng th\u1eeba khi\u1ebfn c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean kh\u00f3 kh\u0103n h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00f4ng th\u1ee9c b\u1ecf kho\u1ea3ng tr\u1ed1ng th\u1eeba trong Excel.<\/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-67780c45b6f25\" 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\/cong-thuc-bo-khoang-trong-thua-trong-excel.html#Ham_SUBSTITUTE_thay_the_ki_tu_trang\" title=\"H\u00e0m SUBSTITUTE thay th\u1ebf k\u00ed t\u1ef1 tr\u1eafng\">H\u00e0m SUBSTITUTE thay th\u1ebf k\u00ed t\u1ef1 tr\u1eafng<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-bo-khoang-trong-thua-trong-excel.html#Ung_dung_ham_SUBSTITUTE\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m SUBSTITUTE\">\u1ee8ng d\u1ee5ng h\u00e0m SUBSTITUTE<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-bo-khoang-trong-thua-trong-excel.html#Ham_TRIM_dua_so_luong_khoang_trong_giua_cac_tu_ve_bang_1\" title=\"H\u00e0m TRIM \u0111\u01b0a s\u1ed1 l\u01b0\u1ee3ng kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb v\u1ec1 b\u1eb1ng 1\">H\u00e0m TRIM \u0111\u01b0a s\u1ed1 l\u01b0\u1ee3ng kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb v\u1ec1 b\u1eb1ng 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-bo-khoang-trong-thua-trong-excel.html#Su_dung_ket_hop_cac_ham_xu_li_ki_tu_Ham_TRIM_va_ham_SUBSTITUTE_ham_CHAR_ham_CODE\" title=\"S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m x\u1eed l\u00ed k\u00ed t\u1ef1. H\u00e0m TRIM v\u00e0 h\u00e0m SUBSTITUTE, h\u00e0m CHAR, h\u00e0m CODE\">S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m x\u1eed l\u00ed k\u00ed t\u1ef1. H\u00e0m TRIM v\u00e0 h\u00e0m SUBSTITUTE, h\u00e0m CHAR, h\u00e0m CODE<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUBSTITUTE_thay_the_ki_tu_trang\"><\/span>H\u00e0m SUBSTITUTE thay th\u1ebf k\u00ed t\u1ef1 tr\u1eafng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0<strong>SUBSTITUTE<\/strong> s\u1ebd thay th\u1ebf m\u1ed9t \u0111o\u1ea1n k\u00ed t\u1ef1 trong m\u1ed9t chu\u1ed7i b\u1eb1ng \u0111o\u1ea1n k\u00ed t\u1ef1 kh\u00e1c.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong> nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=SUBSTITUTE(text, old_text, new_text, [instance_num])<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>text<\/strong> l\u00e0 chu\u1ed7i k\u00ed t\u1ef1 \u0111\u01b0a v\u00e0o<\/p>\n<p><strong>old_text\u00a0<\/strong>l\u00e0 \u0111o\u1ea1n k\u00ed t\u1ef1 n\u1eb1m trong chu\u1ed7i mu\u1ed1n thay th\u1ebf<\/p>\n<p><strong>new_text<\/strong> l\u00e0 \u0111o\u1ea1n k\u00ed t\u1ef1 m\u1edbi thay th\u1ebf cho\u00a0<strong>old_text<\/strong><\/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-100.gif\" title=\"ex101_92019-nho-100\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>instance_num<\/strong> (kh\u00f4ng b\u1eaft bu\u1ed9c) l\u00e0\u00a0v\u1ecb tr\u00ed thay. VD c\u00f3 3 \u0111o\u1ea1n\u00a0<strong>old_text<\/strong>, n\u1ebfu \u0111\u1ec3\u00a0<strong>instance_num<\/strong> b\u1eb1ng 2, \u0111o\u1ea1n\u00a0<strong>old_text 1\u00a0<\/strong>v\u00e0\u00a0<strong>3<\/strong> s\u1ebd kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng. N\u1ebfu kh\u00f4ng nh\u1eadp, h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong> m\u1eb7c \u0111\u1ecbnh s\u1ebd thay th\u1ebf h\u1ebft.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ung_dung_ham_SUBSTITUTE\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m SUBSTITUTE<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ta s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong> \u0111\u1ec3 l\u00e0m li\u1ec1n kho\u1ea3ng c\u00e1ch c\u1ee7a c\u00e1c s\u1ed1 trong m\u1ed9t s\u1ed1 \u0111i\u1ec7n tho\u1ea1i nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23236\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-sub-1.png\" width=\"525\" height=\"328\" title=\"ct-xoa-sub-1\"><\/p>\n<p><em>=SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d)<\/em><\/p>\n<p>\u0110\u1ec3 chuy\u1ec3n s\u1ed1 sau khi x\u1eed l\u00ed kho\u1ea3ng tr\u1ed1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng number, ta nh\u1eadp:<\/p>\n<p><em>=\u2013SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d) ho\u1eb7c\u00a0=VALUE(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d))<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_TRIM_dua_so_luong_khoang_trong_giua_cac_tu_ve_bang_1\"><\/span>H\u00e0m TRIM \u0111\u01b0a s\u1ed1 l\u01b0\u1ee3ng kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb v\u1ec1 b\u1eb1ng 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>H\u00e0m TRIM s\u1ebd x\u00f3a t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1eafng trong chu\u1ed7i k\u00ed t\u1ef1 ngo\u1ea1i tr\u1eeb d\u1ea5u c\u00e1ch n\u1eb1m gi\u1eefa 2 t\u1eeb.<\/strong><\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<blockquote>\n<p><strong>=TRIM(text)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>text<\/strong> l\u00e0 chu\u1ed7i k\u00ed t\u1ef1 b\u1ea1n mu\u1ed1n x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba<\/p>\n<p>Ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 x\u00f3a c\u00e1c k\u00ed t\u1ef1 th\u1eeba trong v\u00ed d\u1ee5 tr\u00ean. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23234\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-2.png\" width=\"403\" height=\"187\" title=\"ct-xoa-2\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3\u2026<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23235\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-3.png\" width=\"437\" height=\"280\" title=\"ct-xoa-3\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ea5y\u00a0 \u0111i\u1ec1u g\u00ec b\u1ea5t th\u01b0\u1eddng \u1edf \u0111\u00e2y kh\u00f4ng? \u0110\u00f3 l\u00e0 \u00f4 B3, m\u1eb7c d\u00f9 h\u00e0m TRIM t\u01b0\u1edfng r\u1eb1ng \u0111\u00e3 x\u1eed l\u00ed \u0111\u01b0\u1ee3c chu\u1ed7i, nh\u01b0ng t\u1ea1i sao kho\u1ea3ng c\u00e1ch gi\u1eefa\u00a0<strong>\u0110\u00ecnh\u00a0<\/strong>v\u00e0\u00a0<strong>Nam<\/strong> v\u1eabn c\u00f2n l\u1edbn v\u1eady?<\/p>\n<p>H\u00e3y \u0111\u1ecdc l\u1eddi gi\u1ea3i \u0111\u00e1p \u1edf ph\u1ea7n d\u01b0\u1edbi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_cac_ham_xu_li_ki_tu_Ham_TRIM_va_ham_SUBSTITUTE_ham_CHAR_ham_CODE\"><\/span>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m x\u1eed l\u00ed k\u00ed t\u1ef1. H\u00e0m TRIM v\u00e0 h\u00e0m SUBSTITUTE, h\u00e0m CHAR, h\u00e0m CODE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong th\u1ef1c t\u1ebf, c\u00f3 nh\u1eefng \u201ck\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t\u201d gi\u1ed1ng v\u1edbi d\u1ea5u c\u00e1ch, c\u0169ng l\u00e0 kho\u1ea3ng tr\u1eafng, nh\u01b0ng l\u1ea1i kh\u00f4ng ph\u1ea3i d\u1ea5u c\u00e1ch. C\u1ee5 th\u1ec3 l\u00e0 nh\u1eefng kho\u1ea3ng tr\u1ed1ng gi\u1eefa\u00a0<strong>\u0110\u00ecnh\u00a0<\/strong>v\u00e0\u00a0<strong>Nam<\/strong> trong h\u00ecnh.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u m\u1ed9t c\u00e1ch t\u01b0\u1eddng t\u1eadn h\u01a1n, H\u1ecdc Excel Online khuy\u00ean c\u00e1c b\u1ea1n n\u00ean t\u00ecm hi\u1ec3u v\u1ec1\u00a0<strong>b\u1ed9 k\u00ed t\u1ef1 ANSI v\u00e0 Macintosh<\/strong>. V\u00ec sao, ch\u00fang ta h\u00e3y \u0111\u1ebfn v\u1edbi c\u00fa ph\u00e1p c\u1ee7a 2 h\u00e0m: H\u00e0m\u00a0<strong>CHAR\u00a0<\/strong>v\u00e0 h\u00e0m\u00a0<strong>CODE<\/strong><\/p>\n<p>H\u00e0m\u00a0<strong>CHAR<\/strong>\u00a0tr\u1ea3 v\u1ec1 k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng s\u1ed1 m\u00e3. V\u1edbi m\u1ed7i m\u00f4i tr\u01b0\u1eddng kh\u00e1c nhau h\u00e0m tr\u1ea3 v\u1ec1 b\u1ed9 k\u00ed t\u1ef1 kh\u00e1c nhau:<\/p>\n<ul>\n<li>N\u1ebfu m\u00f4i tr\u01b0\u1eddng ho\u1ea1t \u0111\u1ed9ng l\u00e0\u00a0<strong>Macintosh<\/strong>\u00a0-&gt; h\u00e0m tr\u1ea3 v\u1ec1 b\u1ed9 k\u00fd t\u1ef1\u00a0<strong>Macintosh<\/strong>.<\/li>\n<li>N\u1ebfu m\u00f4i tr\u01b0\u1eddng ho\u1ea1t \u0111\u1ed9ng l\u00e0\u00a0<strong>Windows<\/strong>\u00a0-&gt; h\u00e0m tr\u1ea3 v\u1ec1 b\u1ed9 k\u00fd t\u1ef1\u00a0<strong>ANSI<\/strong>.<\/li>\n<\/ul>\n<p>H\u00e0m\u00a0<strong>CHAR\u00a0<\/strong>c\u00f3 c\u00fa ph\u00e1p:<\/p>\n<blockquote>\n<p><strong>=CHAR(number)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>number\u00a0<\/strong>l\u00e0 s\u1ed1 t\u1eeb 1-255 \u0111\u1ea1i di\u1ec7n cho c\u00e1c k\u00ed t\u1ef1 quy \u0111\u1ecbnh trong b\u1ea3ng m\u00e3.<\/p>\n<p>Ng\u01b0\u1ee3c l\u1ea1i v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tra-cuu-ki-tu-voi-ham-char-va-code-trong-excel.html\">h\u00e0m\u00a0<strong>CHAR<\/strong><\/a>, h\u00e0m\u00a0<strong>CODE<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0s\u1ed1 t\u1eeb 1-255 t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng m\u00e3 cho\u00a0<strong>k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean<\/strong> c\u1ee7a chu\u1ed7i.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m\u00a0<strong>CODE:<\/strong><\/p>\n<blockquote>\n<p><strong>=CODE(Text)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>Text<\/strong> l\u00e0 chu\u1ed7i k\u00ed t\u1ef1 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm code. Code s\u1ebd hi\u1ec3n th\u1ecb cho ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong chu\u1ed7i.<\/p>\n<p>\u00a0<\/p>\n<p>Quay tr\u1edf l\u1ea1i b\u00e0i to\u00e1n. Vi\u1ec7c \u0111\u1ea7u ti\u00ean, ta s\u1ebd t\u00ecm xem kho\u1ea3ng tr\u1eafng c\u1ee7a\u00a0<strong>\u0110\u00ecnh<\/strong> v\u00e0\u00a0<strong>Nam<\/strong> l\u00e0 k\u00ed t\u1ef1 n\u00e0o qua c\u00e1c b\u01b0\u1edbc:<\/p>\n<p>1.S\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong> l\u1ecdc kho\u1ea3ng tr\u1eafng \u0111\u1ec3 ch\u1eafc ch\u1eafn kh\u00f4ng b\u1ecb l\u1eabn c\u00e1c k\u00ed t\u1ef1 trong chu\u1ed7i tr\u1ed1ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23238\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-5.png\" width=\"605\" height=\"277\" title=\"ct-xoa-5\"><\/p>\n<p>\u00a0<\/p>\n<p>2.Ta s\u1ebd th\u1ef1c hi\u1ec7n\u00a0<strong>Copy<\/strong> v\u00e0\u00a0<strong>Paste value.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-4.png\" width=\"594\" height=\"368\" title=\"ct-xoa-4\"><\/p>\n<p>3.B\u00f4i \u0111en v\u00f9ng k\u00ed t\u1ef1 tr\u1eafng v\u00e0 sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>CODE<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23239\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-6.png\" width=\"602\" height=\"277\" title=\"ct-xoa-6\"><\/p>\n<p><em>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 160<\/em><\/p>\n<p>Nh\u01b0ng \u0111\u1eebng v\u1ed9i, t\u1ea5t c\u1ea3 nh\u1eefng b\u01b0\u1edbc di\u1ec5n gi\u1ea3i tr\u00ean \u0111\u00e2y ch\u1ec9 \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 k\u00ed t\u1ef1 tr\u1eafng. B\u00e2y gi\u1edd, h\u00e3y\u00a0<strong>Undo\u00a0<\/strong>v\u00e0 ta s\u1ebd ti\u1ebfn h\u00e0nh thay th\u1ebf b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p nh\u1eefng h\u00e0m \u1edf tr\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23241\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ct-xoa-7.png\" width=\"597\" height=\"278\" title=\"ct-xoa-7\"><\/p>\n<blockquote>\n<p>=TRIM(SUBSTITUTE(A3,CHAR(160),\u201d \u201c))<\/p>\n<\/blockquote>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp kho\u1ea3ng c\u00e1ch\u00a0<strong>\u201d \u201c<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 thay b\u1eb1ng\u00a0<strong>CHAR(32)<\/strong> v\u1edbi 32 l\u00e0 con s\u1ed1 \u0111\u1ea1i di\u1ec7n.<\/p>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html\">X\u00f3a b\u1ecf kho\u1ea3ng tr\u1eafng, l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u trong Excel<\/a><\/p>\n<p>Sau khi \u0111\u00e3 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i t\u01b0\u1eddng t\u1eadn, vi\u1ec7c x\u00f3a kho\u1ea3ng tr\u1ed1ng b\u1eb1ng h\u00e0m \u0111\u00e3 kh\u00f4ng c\u00f2n qu\u00e1 kh\u00f3 hi\u1ec3u n\u1eefa ph\u1ea3i kh\u00f4ng n\u00e0o? Tuy nhi\u00ean, 160 ch\u1ec9 l\u00e0 m\u1ed9t trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p, b\u1edfi v\u1eady \u0111\u1eebng qu\u00ean luy\u1ec7n t\u1eadp, t\u00ecm t\u00f2i \u0111\u1ec3 ph\u00e1t hi\u1ec7n ra nh\u1eefng v\u1ea5n \u0111\u1ec1 m\u1edbi v\u00e0 gi\u1ea3i quy\u1ebft ch\u00fang nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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-100.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9841,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9840","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\/9840","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=9840"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9840\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9841"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}