{"id":8406,"date":"2024-12-22T14:29:01","date_gmt":"2024-12-22T14:29:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/cach-lam-sach-du-lieu-trong-excel-don-gian-de-thuc-hien\/"},"modified":"2024-12-22T14:29:01","modified_gmt":"2024-12-22T14:29:01","slug":"cach-lam-sach-du-lieu-trong-excel-don-gian-de-thuc-hien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/cach-lam-sach-du-lieu-trong-excel-don-gian-de-thuc-hien\/","title":{"rendered":"C\u00e1ch l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u trong Excel \u0110\u01a1n Gi\u1ea3n, D\u1ec5 Th\u1ef1c Hi\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, ch\u1eafc ch\u1eafn \u0111\u00e3 c\u00f3 l\u00fac b\u1ea1n t\u00ecm ki\u1ebfm nh\u1eefng l\u1ed7i sai c\u1ee7a c\u00e1c h\u00e0m d\u00f2 t\u00ecm <a href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-tra-cuu-tra-ve-nhieu-gia-tri.html\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP n\u00e2ng cao<\/a>, v\u1ea5t v\u1ea3 \u0111i t\u00ecm l\u1ed7i khi <a href=\"https:\/\/blog.hocexcel.online\/ham-sumif-tinh-tong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">t\u1ed5ng k\u1ebft b\u00e1o c\u00e1o d\u1eef li\u1ec7u v\u1edbi SUMIFS ho\u1eb7c SUMPRODUCT<\/a>. Cu\u1ed1i c\u00f9ng, b\u1ea1n ph\u00e1t hi\u1ec7n ra l\u00fd do cho vi\u1ec7c c\u00f4ng th\u1ee9c kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng l\u00e0 nh\u1eefng kho\u1ea3ng tr\u1eafng trong d\u1eef li\u1ec7u. Trong b\u00e0i n\u00e0y, H.E.O s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd nh\u1eefng d\u1eef li\u1ec7u c\u00f3 l\u1eabn kho\u1ea3ng tr\u1eafng n\u00e0y, \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng k\u0129 thu\u1eadt Excel n\u00e2ng cao khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u.<\/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-6768222d15cf5\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html#Cac_truong_hop_ki_tu_dau_cach_bi_lan_trong_du_lieu\" title=\"C\u00e1c tr\u01b0\u1eddng h\u1ee3p k\u00ed t\u1ef1 d\u1ea5u c\u00e1ch b\u1ecb l\u1eabn trong d\u1eef li\u1ec7u\">C\u00e1c tr\u01b0\u1eddng h\u1ee3p k\u00ed t\u1ef1 d\u1ea5u c\u00e1ch b\u1ecb l\u1eabn trong d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html#So_sanh_du_lieu_de_phat_hien_phat_hien_dau_cach_hoac_ki_tu_khong_thay_duoc\" title=\"So s\u00e1nh d\u1eef li\u1ec7u \u0111\u1ec3 ph\u00e1t hi\u1ec7n ph\u00e1t hi\u1ec7n d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng th\u1ea5y \u0111\u01b0\u1ee3c\">So s\u00e1nh d\u1eef li\u1ec7u \u0111\u1ec3 ph\u00e1t hi\u1ec7n ph\u00e1t hi\u1ec7n d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng th\u1ea5y \u0111\u01b0\u1ee3c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html#Cach_loai_bo_khoang_trang_ki_tu_khoang_trang_trong_du_lieu\" title=\"C\u00e1ch lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng, k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng trong d\u1eef li\u1ec7u\">C\u00e1ch lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng, k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng trong d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html#Xoa_khoang_trang_roi_nhung_van_loi\" title=\"Xo\u00e1 kho\u1ea3ng tr\u1eafng r\u1ed3i nh\u01b0ng v\u1eabn l\u1ed7i\">Xo\u00e1 kho\u1ea3ng tr\u1eafng r\u1ed3i nh\u01b0ng v\u1eabn l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html#Ket_hop_ham_CLEAN_va_TRIM_roi_nhung_van_co_loi\" title=\"K\u1ebft h\u1ee3p h\u00e0m CLEAN v\u00e0 TRIM r\u1ed3i nh\u01b0ng v\u1eabn c\u00f3 l\u1ed7i\">K\u1ebft h\u1ee3p h\u00e0m CLEAN v\u00e0 TRIM r\u1ed3i nh\u01b0ng v\u1eabn c\u00f3 l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html#Copy_du_lieu_tu_Web_vao_Excel_bi_loi\" title=\"Copy d\u1eef li\u1ec7u t\u1eeb Web v\u00e0o Excel b\u1ecb l\u1ed7i\">Copy d\u1eef li\u1ec7u t\u1eeb Web v\u00e0o Excel b\u1ecb l\u1ed7i<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_truong_hop_ki_tu_dau_cach_bi_lan_trong_du_lieu\"><\/span>C\u00e1c tr\u01b0\u1eddng h\u1ee3p k\u00ed t\u1ef1 d\u1ea5u c\u00e1ch b\u1ecb l\u1eabn trong d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u t\u1eeb 1 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n tr\u01b0\u1edbc.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-14-at-14-38-08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1014\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-14-at-14-38-08.png\" alt=\"screen-shot-2016-12-14-at-14-38-08\" width=\"320\" height=\"122\" title=\"screen-shot-2016-12-14-at-14-38-08\"><\/a><\/p>\n<p>Qua v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta ph\u00e2n bi\u1ec7t 3 tr\u01b0\u1eddng h\u1ee3p l\u1eabn d\u1ea5u c\u00e1ch \u1edf trong d\u1eef li\u1ec7u<\/p>\n<ol>\n<li>Tr\u01b0\u1eddng h\u1ee3p 1: d\u1ea5u c\u00e1ch \u1edf cu\u1ed1i n\u1ed9i dung (Trailing space) \u2013 \u00f4 A2<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p 2: d\u1ea5u c\u00e1ch \u1edf \u0111\u1ea7u n\u1ed9i dung (Leading space) \u2013 \u00f4 A5<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p 3: d\u1ea5u c\u00e1ch \u1edf gi\u1eefa n\u1ed9i dung (in-between space) \u2013 \u00f4 C2<\/li>\n<\/ol>\n<blockquote data-secret=\"XxIieGZaAQ\" class=\"wp-embedded-content\"><p><a href=\"http:\/\/www.hocexcel.online\/vba101-landing.html\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a><\/p><\/blockquote>\n\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_du_lieu_de_phat_hien_phat_hien_dau_cach_hoac_ki_tu_khong_thay_duoc\"><\/span>So s\u00e1nh d\u1eef li\u1ec7u \u0111\u1ec3 ph\u00e1t hi\u1ec7n ph\u00e1t hi\u1ec7n d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng th\u1ea5y \u0111\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 ph\u00e1t hi\u1ec7n v\u00e0 so s\u00e1nh 2 \u00f4 d\u1eef li\u1ec7u A1, A2 c\u00f3 gi\u1ed1ng nhau hay kh\u00f4ng, c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p>=A1=A2<\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p so s\u00e1nh n\u00e0y l\u00e0 <strong>FALSE <\/strong>c\u00f3 ngh\u0129a l\u00e0 d\u1eef li\u1ec7u 2 \u00f4 n\u00e0y kh\u00f4ng ho\u00e0n to\u00e0n gi\u1ed1ng nhau, tuy ch\u00fang tr\u00f4ng gi\u1ed1ng nhau. Ki\u1ec3m tra l\u1ea1i 1 l\u1ea7n n\u1eefa b\u1eb1ng h\u00e0m <strong>LEN\u00a0<\/strong>ch\u00fang ta th\u1ea5y \u0111\u01b0\u1ee3c r\u1eb1ng <strong>=LEN(A1)\u00a0<\/strong>cho k\u1ebft qu\u1ea3 l\u00e0 6, nh\u01b0ng <strong>=LEN(A2) <\/strong>cho k\u1ebft qu\u1ea3 l\u00e0 7.<\/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\/2024\/12\/ex101_92019-nho-769.gif\" title=\"ex101_92019-nho-769\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>Kh\u00f3a h\u1ecdc excel n\u00e2ng cao H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loai_bo_khoang_trang_ki_tu_khoang_trang_trong_du_lieu\"><\/span>C\u00e1ch lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng, k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng trong d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong Excel, c\u00f3 1 h\u00e0m s\u1ebd gi\u00fap ch\u00fang ta lo\u1ea1i kho\u1ea3ng tr\u1eafng \u1edf c\u1ea3 3 tr\u01b0\u1eddng h\u1ee3p: leading space, trailing space v\u00e0 in-between space, \u0111\u00f3 ch\u00ednh l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\"><strong>h\u00e0m TRIM<\/strong><\/a>. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TRIM nh\u01b0 sau:<\/p>\n<p>\u0110\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng c\u1ee7a d\u1eef li\u1ec7u trong \u00f4 A2, \u1edf trong 1 \u00f4 b\u1ea5t k\u00ec, nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p>=TRIM(A2)<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Xoa_khoang_trang_roi_nhung_van_loi\"><\/span>Xo\u00e1 kho\u1ea3ng tr\u1eafng r\u1ed3i nh\u01b0ng v\u1eabn l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi d\u1eef li\u1ec7u \u0111\u1ebfn t\u1eeb nh\u1eefng h\u1ec7 th\u1ed1ng, nh\u1eefng ngu\u1ed3n b\u00ean ngo\u00e0i Excel, ch\u00fang ta hay g\u1eb7p tr\u01b0\u1eddng h\u1ee3p, kh\u00f4ng ch\u1ec9 nh\u1eefng kho\u1ea3ng tr\u1eafng, m\u00e0 c\u00f2n nhi\u1ec1u lo\u1ea1i k\u00ed t\u1ef1 kh\u00f4ng nh\u00ecn th\u1ea5y ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c (non-printing characters) \u0111\u01b0\u1ee3c b\u1ecb l\u1eabn trong d\u1eef li\u1ec7u: k\u00ed t\u1ef1 xu\u1ed1ng d\u00f2ng, k\u00ed t\u1ef1 tab, v.v \u2026<\/p>\n<p>H\u00e0m TRIM ho\u1ea1t \u0111\u1ed9ng r\u1ea5t t\u1ed1t v\u1edbi nh\u1eefng k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng, nh\u01b0ng v\u1edbi nh\u1eefng k\u00ed t\u1ef1 kh\u00e1c, h\u00e0m TRIM kh\u00f4ng c\u00f3 t\u00e1c d\u1ee5ng. Nh\u1eb1m l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u, Excel \u0111\u00e3 cung c\u1ea5p cho ch\u00fang ta <strong>h\u00e0m CLEAN<\/strong>. V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1ef1 d\u1ee5ng h\u00e0m CLEAN nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-nonprinting-chars.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1017\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-nonprinting-chars.png\" alt=\"remove-nonprinting-chars\" width=\"322\" height=\"290\" title=\"remove-nonprinting-chars\"><\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta k\u1ebft h\u1ee3p h\u00e0m CLEAN v\u00e0 h\u00e0m TRIM \u0111\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd tri\u1ec7t \u0111\u1ec3 nh\u1eefng kho\u1ea3ng tr\u1eafng hay nh\u1eefng k\u00ed t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c ra kh\u1ecfi d\u1eef li\u1ec7u \u0111\u1ecba ch\u1ec9.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_ham_CLEAN_va_TRIM_roi_nhung_van_co_loi\"><\/span>K\u1ebft h\u1ee3p h\u00e0m CLEAN v\u00e0 TRIM r\u1ed3i nh\u01b0ng v\u1eabn c\u00f3 l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi k\u1ebft h\u1ee3p h\u00e0m CLEAN v\u00e0 h\u00e0m TRIM c\u00f3 th\u1ec3 b\u1ea1n v\u1eabn s\u1ebd g\u1eb7p l\u1ea1i <a href=\"https:\/\/blog.hocexcel.online\/xu-ly-loi-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">nh\u1eefng l\u1ed7i kh\u00f3 ch\u1ecbu nh\u01b0 #NAME?, #REF<\/a>. Ch\u00fang ta s\u1ebd ph\u1ea3i x\u1eed l\u00fd d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=SUBSTITUTE(SUBSTITUTE(A2, CHAR(13),\u201d \u201c), CHAR(10), \u201d \u201c)<\/p>\n<\/blockquote>\n<p>C\u00f4ng th\u1ee9c tr\u00ean gi\u00fap ch\u00fang ta thay th\u1ebf 2 lo\u1ea1i k\u00ed t\u1ef1 xu\u1ed1ng d\u00f2ng Carriage Return (Char(13)) v\u00e0 Line Feed (Char(10)) v\u1edbi k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Copy_du_lieu_tu_Web_vao_Excel_bi_loi\"><\/span>Copy d\u1eef li\u1ec7u t\u1eeb Web v\u00e0o Excel b\u1ecb l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n copy d\u1eef li\u1ec7u t\u1eeb Web v\u00e0o Excel v\u00e0 b\u1ecb l\u1ed7i kho\u1ea3ng tr\u1eafng, nhi\u1ec1u kh\u1ea3 n\u0103ng b\u1ea1n \u0111\u00e3 g\u1eb7p ph\u1ea3i nh\u1eefng kho\u1ea3ng tr\u1eafng g\u1ecdi l\u00e0 \u201cnon-breaking spaces\u201d (&nbsp;). \u0110\u1ec3 lo\u1ea1i b\u1ecf nh\u1eefng k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng t\u1eeb web n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=TRIM(SUBSTITUTE(A2, CHAR(160), \u201d \u201c))<\/p>\n<\/blockquote>\n<p>C\u00f4ng th\u1ee9c ph\u00eda tr\u00ean s\u1ebd thay nh\u1eefng k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng c\u00f3 m\u00e3 160 trong b\u1ea3ng m\u00e3 ASCII b\u1eb1ng kho\u1ea3ng tr\u1eafng, sau \u0111\u00f3, ch\u00fang ta s\u1ebd l\u1ea1i s\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 thay th\u1ebf nh\u1eefng kho\u1ea3ng tr\u1eafng b\u1ecb th\u1eeba.<\/p>\n<p>N\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a c\u00e1c b\u1ea1n c\u00f2n ch\u1ee9a nh\u1eefng k\u00ed t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m CLEAN c\u00f9ng v\u1edbi h\u00e0m TRIM v\u00e0 h\u00e0m SUBSTITUTE nh\u01b0 sau \u0111\u1ec3 lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 nh\u1eefng k\u00ed t\u1ef1 kh\u00f4ng n\u00ean c\u00f3 trong d\u1eef li\u1ec7u nh\u01b0 sau<\/p>\n<blockquote>\n<p>=TRIM(CLEAN((SUBSTITUTE(A2,CHAR(160),\u201d \u201c))))<\/p>\n<\/blockquote>\n<p>\u1ea2nh ch\u1ee5p sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c s\u1ef1 kh\u00e1c nhau khi k\u1ebft h\u1ee3p c\u00e1c h\u00e0m n\u00e0y<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-spaces-excel-heo.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1019\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-spaces-excel-heo.png\" alt=\"remove-spaces-excel-heo\" width=\"633\" height=\"292\" title=\"remove-spaces-excel-heo\"><\/a><\/p>\n<p>Nh\u01b0 v\u1eady, hi v\u1ecdng v\u1edbi c\u00e1c k\u0129 thu\u1eadt tr\u00ean, c\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u s\u1ea1ch, \u0111\u1eb9p \u0111\u1ec3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u <a href=\"http:\/\/bit.ly\/heoEDM05a\" target=\"_blank\" rel=\"noopener noreferrer\">t\u1ea1o nh\u1eefng b\u00e1o c\u00e1o \u0111\u1eb9p nh\u1ea5t<\/a><\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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\/2024\/12\/ex101_92019-nho-769.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8407,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8406","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8406","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=8406"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8406\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8407"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}