{"id":2704,"date":"2024-12-02T08:29:42","date_gmt":"2024-12-02T08:29:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/2-cach-de-loai-bo-dau-cach-khoang-trang-giua-cac-tu-cac-so-trong-o-tinh-excel\/"},"modified":"2024-12-02T08:29:42","modified_gmt":"2024-12-02T08:29:42","slug":"2-cach-de-loai-bo-dau-cach-khoang-trang-giua-cac-tu-cac-so-trong-o-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/2-cach-de-loai-bo-dau-cach-khoang-trang-giua-cac-tu-cac-so-trong-o-tinh-excel\/","title":{"rendered":"2 c\u00e1ch \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch, kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb, c\u00e1c s\u1ed1 trong \u00f4 t\u00ednh Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch lo\u1ea1i b\u1ecf kho\u1ea3ng c\u00e1ch th\u1eeba gi\u1eefa c\u00e1c t\u1eeb v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">x\u00f3a to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng<\/a> trong \u00f4 t\u00ednh Excel. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c TRIM v\u00e0 c\u00f4ng c\u1ee5 Find &amp; Replace<strong><em>.<\/em><\/strong><\/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-674d6ff5662bc\" 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\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#Bo_nhieu_khoang_trang_de_con_mot_khoang_trang_loai_bo_dau_cach_dau_dong_va_cuoi_dong\" title=\"B\u1ecf nhi\u1ec1u kho\u1ea3ng tr\u1eafng \u0111\u1ec3 c\u00f2n m\u1ed9t kho\u1ea3ng tr\u1eafng, lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng:\">B\u1ecf nhi\u1ec1u kho\u1ea3ng tr\u1eafng \u0111\u1ec3 c\u00f2n m\u1ed9t kho\u1ea3ng tr\u1eafng, lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng:<\/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\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#Su_dung_ham_TRIM_de_loai_bo_khoang_trang\" title=\"S\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng:\">S\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#Su_dung_Find_Replace_de_loai_bo_khoang_trang_du_thua_giua_cac_tu\" title=\"S\u1eed d\u1ee5ng Find &amp; Replace \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba gi\u1eefa c\u00e1c t\u1eeb:\">S\u1eed d\u1ee5ng Find &amp; Replace \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba gi\u1eefa c\u00e1c t\u1eeb:<\/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\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#Loai_bo_toan_bo_khoang_trang_giua_cac_so\" title=\"Lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c s\u1ed1:\">Lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c s\u1ed1:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#Su_dung_cong_thuc_de_loai_bo_toan_bo_khoang_trang\" title=\"S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng:\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng:<\/a><\/li>\n<\/ul>\n<\/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\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#XOA_KHOANG_TRANG_PHIA_TRUOC_TRONG_COT_SO\" title=\"XO\u00c1 KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC TRONG C\u1ed8T S\u1ed0\">XO\u00c1 KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC TRONG C\u1ed8T S\u1ed0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#CACH_XOA_KHOANG_TRANG_PHIA_TRUOC_LEFT_TRIM\" title=\"C\u00c1CH XO\u00c1 KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC (LEFT TRIM)\">C\u00c1CH XO\u00c1 KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC (LEFT TRIM)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html#DANH_DAU_O_CO_KHOANG_TRANG_THUA\" title=\"\u0110\u00c1NH D\u1ea4U \u00d4 C\u00d3 KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA\">\u0110\u00c1NH D\u1ea4U \u00d4 C\u00d3 KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Bo_nhieu_khoang_trang_de_con_mot_khoang_trang_loai_bo_dau_cach_dau_dong_va_cuoi_dong\"><\/span><strong>B\u1ecf nhi\u1ec1u kho\u1ea3ng tr\u1eafng \u0111\u1ec3 c\u00f2n m\u1ed9t kho\u1ea3ng tr\u1eafng, lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng bi\u1ec3u g\u1ed3m 2 c\u1ed9t. Trong c\u1ed9t Name, \u00f4 \u0111\u1ea7u ti\u00ean ch\u1ee9a \u2018John Doe\u2019 \u0111\u01b0\u1ee3c vi\u1ebft ch\u00ednh x\u00e1c. Nh\u1eefng \u00f4 t\u00ednh kh\u00e1c s\u1ebd c\u00f3 th\u00eam kho\u1ea3ng tr\u1eafng gi\u1eefa h\u1ecd v\u00e0 t\u00ean. \u0110\u1ed3ng th\u1eddi, nh\u1eefng \u00f4 t\u00ednh n\u00e0y ch\u1ee9a nh\u1eefng kho\u1ea3ng tr\u1eafng kh\u00f4ng c\u1ea7n thi\u1ebft tr\u01b0\u1edbc v\u00e0 sau h\u1ecd t\u00ean \u0111\u1ea7y \u0111\u1ee7 (<strong><em>leading and trailing spaces<\/em><\/strong>). C\u1ed9t th\u1ee9 hai \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Length v\u00e0 hi\u1ec3n th\u1ecb s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed7i t\u00ean.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excess-spaces-excel-cells.png\" alt=\"Excel table with leading and trailing spaces, spaces between words\" title=\"excess-spaces-excel-cells\"><\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-trong-word-don-gian.html\">x\u00f3a d\u00f2ng tr\u1eafng trong Word<\/a> v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_TRIM_de_loai_bo_khoang_trang\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\">H\u00e0m TRIM trong Excel<\/a> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00f3a nh\u1eefng kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba trong v\u0103n b\u1ea3n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 t\u1eebng b\u01b0\u1edbc \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u00e8n th\u00eam c\u1ed9t ph\u1ee5 v\u00e0o cu\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u1eb7t t\u00ean n\u00f3 l\u00e0 \u2018Trim\u2019<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Trong \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t ph\u1ee5 (C2), nh\u1eadp c\u00f4ng th\u1ee9c x\u00f3a kho\u1ea3ng tr\u1eafng <strong><em>=TRIM(A2)<\/em><\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-88.gif\" title=\"vba101_92019-nho-88\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-209.gif\" title=\"ex101_92019-nho-209\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-trim-formula-delete-spaces.png\" title=\"excel-trim-formula-delete-spaces\"><\/em><\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Sao ch\u00e9p c\u00f4ng th\u1ee9c sang kh\u00e1c \u00f4 t\u00ednh kh\u00e1c trong c\u1ed9t.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Thay th\u1ebf c\u1ed9t g\u1ed1c b\u1eb1ng c\u1ed9t ph\u1ee5. Ch\u1ecdn t\u1ea5t c\u1ea3 \u00f4 t\u00ednh trong c\u1ed9t ph\u1ee5, nh\u1ea5n <code class=\"excel-formula-inline\"><strong><em>Ctrl + C <\/em><\/strong><\/code>\u0111\u1ec3 sao ch\u00e9p ch\u00fang v\u00e0o <strong><em>clipboard<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t g\u1ed1c, nh\u1ea5n <code class=\"excel-formula-inline\"><strong><em>Shift + F10 <\/em><\/strong><\/code>ho\u1eb7c n\u00fat <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5805\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/menu-button.png\" width=\"20\" height=\"18\" title=\"menu-button\"><strong><em>. <\/em><\/strong>Sau \u0111\u00f3 nh\u1ea5n <strong><em>V<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-spaces-between-words-to-1.png\" alt=\"Replace the original column with the one that has the extra spaces removed\" title=\"remove-spaces-between-words-to-1\"><\/p>\n<p>B\u01b0\u1edbc 6: X\u00f3a c\u1ed9t ph\u1ee5.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 x\u00f3a to\u00e0n b\u1ed9 c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba b\u1eb1ng h\u00e0m <strong><em>TRIM. <\/em><\/strong>Tuy nhi\u00ean, n\u1ebfu b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u1edbn, c\u00e1ch n\u00e0y s\u1ebd kh\u00e1 t\u1ed1n th\u1eddi gian.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excess-spaces-removed.png\" alt=\"Remove spaces between words to 1, remove leading and trailing spaces\" title=\"excess-spaces-removed\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu sau khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, b\u1ea1n v\u1eabn th\u1ea5y nh\u1eefng kho\u1ea3ng tr\u1eafng, h\u00e3y xem b\u00e0i <strong><em>N\u1ebfu h\u00e0m TRIM kh\u00f4ng l\u00e0m vi\u1ec7c<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam: T\u00f4\u0309ng h\u01a1\u0323p nh\u01b0\u0303ng ba\u0300i vi\u00ea\u0301t h\u01b0\u01a1\u0301ng d\u00e2\u0303n ho\u0323c <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_Find_Replace_de_loai_bo_khoang_trang_du_thua_giua_cac_tu\"><\/span><strong>S\u1eed d\u1ee5ng Find &amp; Replace \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba gi\u1eefa c\u00e1c t\u1eeb:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0y \u00edt b\u01b0\u1edbc h\u01a1n, nh\u01b0ng ch\u1ec9 cho ph\u00e9p x\u00f3a kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb. Kho\u1ea3ng tr\u1eafng \u0111\u1ea7u v\u00e0 cu\u1ed1i t\u1eeb<strong><em>\u00a0<\/em><\/strong>c\u0169ng \u0111\u01b0\u1ee3c c\u1eaft th\u00e0nh m\u1ed9t d\u1ea5u c\u00e1ch, nh\u01b0ng kh\u00f4ng \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n x\u00f3a d\u1ea5u c\u00e1ch.<\/li>\n<li>Nh\u1ea5n <strong><em>Ctrl + H <\/em><\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\">Find &amp; Replace<\/a>.<\/li>\n<li>Nh\u1ea5n ph\u00edm c\u00e1ch hai l\u1ea7n trong \u00f4 <strong><em>Find What <\/em><\/strong>v\u00e0 m\u1ed9t l\u1ea7n trong \u00f4 <strong><em>Replace With<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5n n\u00fat <strong><em>Replace All<\/em><\/strong>, sau \u0111\u00f3 nh\u1ea5n OK \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i x\u00e1c nh\u1eadn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5806\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-71.png\" width=\"600\" height=\"214\" title=\"excel-dialog-box-launcher-1-71\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>L\u1eb7p l\u1ea1i b\u01b0\u1edbc 4 \u0111\u1ebfn khi b\u1ea1n th\u1ea5y tin nh\u1eafn <strong><em>\u201cWe couldn\u2019t find anything to replace.\u201d<\/em><\/strong><\/li>\n<\/ol>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loai_bo_toan_bo_khoang_trang_giua_cac_so\"><\/span><strong>Lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c s\u1ed1:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a c\u00e1c con s\u1ed1 \u0111\u01b0\u1ee3c ng\u0103n c\u00e1ch b\u1edfi c\u00e1c kho\u1ea3ng tr\u1eafng (h\u00e0ng ng\u00e0n, h\u00e0ng tri\u1ec7u, h\u00e0ng t\u1ef7). V\u00ec th\u1ebf, Excel xem nh\u1eefng con s\u1ed1 n\u00e0y \u1edf d\u1ea1ng <strong>text <\/strong>v\u00e0 kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n v\u1edbi ch\u00fang.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-spaces-between-numbers.png\" alt=\"Excel cells with numbers where the digits are separated with spaces\" title=\"excel-spaces-between-numbers\"><\/p>\n<p style=\"text-align: justify\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 lo\u1ea1i b\u1ecf nh\u1eefng kho\u1ea3ng tr\u1eafng n\u00e0y l\u00e0 s\u1eed d\u1ee5ng <strong><em>Find &amp; Replace<\/em><\/strong>:<\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5n <code class=\"excel-formula-inline\"><strong><em>Ctrl + Space<\/em><\/strong><\/code> \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 \u00f4 t\u00ednh trong c\u1ed9t.<\/li>\n<li>Nh\u1ea5n <strong><em><code class=\"excel-formula-inline\">Ctrl + H <\/code><\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <code class=\"excel-formula-inline\"><strong><em>Find &amp; Replace<\/em><\/strong><\/code>.<\/li>\n<li>Nh\u1eadp ph\u00edm c\u00e1ch v\u00e0o \u00f4 <strong><em>Find What<\/em><\/strong> v\u00e0 \u0111\u1ec3 tr\u1ed1ng \u00f4 <strong><em>Replace With<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5n n\u00fat <strong><em>Replace all<\/em><\/strong>, sau \u0111\u00f3 nh\u1ea5n OK.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/removed-spaces-between-numbers.png\" alt=\"Remove all spaces between numbers\" title=\"removed-spaces-between-numbers\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1eafng \u0111\u1ec1u \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_cong_thuc_de_loai_bo_toan_bo_khoang_trang\"><\/span><strong>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng, v\u00ed d\u1ee5 nh\u01b0 c\u00e1c kho\u1ea3ng tr\u1eafng trong m\u1ed9t chu\u1ed7i c\u00f4ng th\u1ee9c. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u1ed9t ph\u1ee5 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c: <strong><em>=SUBSTITUTE(A1,\u201c\u00a0 \u201c, \u201c \u201c)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u00d4 A1 \u0111\u1ea7u ti\u00ean trong c\u1ed9t d\u01b0\u1edbi \u0111\u00e2y ch\u1ee9a s\u1ed1 v\u00e0 t\u1eeb sau khi t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3ng tr\u1eafng \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-all-spaces-substitute.png\" alt=\"Using formula to remove all spaces between numbers\" title=\"remove-all-spaces-substitute\"><\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Blog <a href=\"http:\/\/blog.ezworkapp.com\">Ho\u0323c Excel<\/a> Online<\/p>\n<h2><span class=\"ez-toc-section\" id=\"XOA_KHOANG_TRANG_PHIA_TRUOC_TRONG_COT_SO\"><\/span><strong>XO\u00c1 KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC TRONG C\u1ed8T S\u1ed0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, h\u00e0m TRIM c\u00f3 ch\u1ee9c n\u0103ng xo\u00e1 m\u1ecdi kho\u1ea3ng tr\u1eafng th\u1eeba kh\u1ecfi c\u1ed9t d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng g\u1eb7p kh\u00f3 kh\u0103n n\u00e0o. Nh\u01b0ng n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 s\u1ed1, kh\u00f4ng ph\u1ea3i ch\u1eef?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4931 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trim-leading-spaces-numbers.png\" width=\"271\" height=\"161\" title=\"trim-leading-spaces-numbers\"><\/p>\n<p>Nh\u00ecn qua, c\u00f3 v\u1ebb h\u00e0m TRIM \u0111\u00e3 l\u00e0m t\u1ed1t nhi\u1ec7m v\u1ee5. Nh\u01b0ng n\u1ebfu b\u1ea1n xem x\u00e9t k\u1ef9 h\u01a1n, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda kh\u00f4ng c\u00f2n ch\u1ee9c n\u0103ng nh\u01b0 s\u1ed1. C\u00f3 v\u00e0i \u0111i\u1ec1u b\u1ea5t th\u01b0\u1eddng nh\u01b0:<\/p>\n<ul>\n<li>C\u1ea3 c\u1ed9t g\u1ed1c c\u00f3 kho\u1ea3ng tr\u1eafng v\u00e0 c\u1ed9t \u0111\u00e3 s\u1eeda \u0111\u1ec1u c\u0103n tr\u00e1i ngay c\u1ea3 khi b\u1ea1n \u0111\u1eb7t d\u1ea1ng S\u1ed1 cho \u00f4, nh\u01b0ng s\u1ed1 b\u00ecnh th\u01b0\u1eddng \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh c\u0103n ph\u1ea3i.<\/li>\n<li>Khi ch\u1ecdn t\u1eeb 2 \u00f4 tr\u1edf l\u00ean v\u1edbi s\u1ed1 \u0111\u00e3 s\u1eeda, Excel ch\u1ec9 hi\u1ec7n th\u1ecb COUNT \u1edf tr\u00ean thanh tr\u1ea1ng th\u00e1i. V\u1edbi s\u1ed1, thanh s\u1ebd hi\u1ec7n th\u1ecb SUM v\u00e0\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cac-cach-tinh-tong-nhanh-trong-excel-nhieu-cach-hay-va-la.html\" target=\"_blank\" rel=\"noopener noreferrer\">AVERAGE<\/a>.<\/li>\n<li>C\u00f4ng th\u1ee9c SUM \u00e1p d\u1ee5ng cho \u00f4 \u0111\u00e3 ch\u1ec9nh s\u1eeda ra k\u1ebft qu\u1ea3 0.<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4932 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trim-leading-numbers-not-working.png\" width=\"365\" height=\"252\" title=\"trim-leading-numbers-not-working\"><\/li>\n<\/ul>\n<p>B\u1edfi v\u00ec c\u00e1c gi\u00e1 tr\u1ecb qua ch\u1ec9nh s\u1eeda l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n, trong khi ch\u00fang ta c\u1ea7n s\u1ed1. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y, b\u1ea1n nh\u00e2n gi\u00e1 tr\u1ecb \u0111\u00e3 qua ch\u1ec9nh s\u1eeda v\u1edbi 1 (nh\u00e2n c\u00e1c gi\u00e1 tr\u1ecb trong 1 l\u1ea7n, b\u1ea1n d\u00f9ng\u00a0<strong>Paste Special &gt; Multiply<\/strong>).<\/p>\n<p>C\u00e1ch nh\u1eb9 nh\u00e0ng h\u01a1n l\u00e0 l\u1ed3ng h\u00e0m TRIM trong\u00a0h\u00e0m VALUE:<\/p>\n<p><strong>=VALUE(TRIM(A2))<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd xo\u00e1 b\u1ecf m\u1ecdi kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc v\u00e0 ph\u00eda sau, v\u00e0 tr\u1ea3 gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 v\u1ec1 d\u1ea1ng s\u1ed1, nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4933 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-leading-spaces-numbers.png\" width=\"365\" height=\"255\" title=\"remove-leading-spaces-numbers\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"CACH_XOA_KHOANG_TRANG_PHIA_TRUOC_LEFT_TRIM\"><\/span><span id=\"CACH_XOA_KHOANG_TRANG_PHIA_TRUOC_LEFT_TRIM\" class=\"ez-toc-section\"><\/span><strong>C\u00c1CH XO\u00c1 KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC (LEFT TRIM)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong v\u00e0i tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 2, th\u1eadm ch\u00ed 3 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c ch\u1eef \u0111\u1ec3 d\u1eef li\u1ec7u d\u1ec5 \u0111\u1ecdc h\u01a1n. Tuy nhi\u00ean, khi b\u1ea1n mu\u1ed1n b\u1ecf nh\u1eefng kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4934 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-leading-spaces-excel.png\" width=\"447\" height=\"162\" title=\"remove-leading-spaces-excel\"><\/p>\n<p>Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m TRIM c\u0169ng s\u1ebd xo\u00e1 kho\u1ea3ng tr\u1eafng \u1edf gi\u1eefa c\u00e1c ch\u1eef. \u0110\u1ec3 gi\u1eef l\u1ea1i nh\u1eefng kho\u1ea3ng tr\u1eafng n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n:<\/p>\n<p><strong>\u00a0=MID(A2,FIND(MID(TRIM(A2),1,1),A2),LEN(A2))<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n k\u1ebft h\u1ee3p\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m FIND<\/a>,\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">MID<\/a>\u00a0v\u00e0 TRIM \u0111\u1ec3 t\u00ednh to\u00e1n v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i. V\u00e0 sau \u0111\u00f3, b\u1ea1n th\u00eam con s\u1ed1 \u0111\u00f3 v\u00e0o h\u00e0m MID kh\u00e1c, h\u00e0m s\u1ebd \u0111\u01b0a to\u00e0n b\u1ed9 chu\u1ed7i v\u0103n b\u1ea3n (\u0111\u1ed9 d\u00e0i chu\u1ed7i \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m LEN<\/a>) v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean.<\/p>\n<p>H\u00ecnh d\u01b0\u1edbi minh ho\u1ea1 khi xo\u00e1 m\u1ecdi kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, ch\u1ec9 \u0111\u1ec3 l\u1ea1i kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c ch\u1eef.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4935 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trim-leading-spaces.png\" width=\"336\" height=\"199\" title=\"trim-leading-spaces\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng, thay th\u1ebf \u0111o\u1ea1n ch\u1eef g\u1ed1c b\u1eb1ng \u0111o\u1ea1n ch\u1eef \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda.<\/p>\n<p>\u0110\u1ebfm s\u1ed1 kho\u1ea3ng tr\u1eafng th\u1eeba trong 1 \u00f4<\/p>\n<p>\u0110\u00f4i l\u00fac tr\u01b0\u1edbc khi xo\u00e1 kho\u1ea3ng tr\u1eafng trong b\u1ea3ng Excel, b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau kho\u1ea3ng tr\u1eafng th\u1eeba ra trong \u0111\u00f3.<\/p>\n<p>\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c con s\u1ed1 n\u00e0y, t\u00ecm \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m LEN, sau \u0111\u00f3 t\u00ednh \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n khi kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng, v\u00e0 tr\u1eeb \u0111i:<\/p>\n<p><strong>=LEN(A2)-LEN(TRIM(A2))<\/strong><\/p>\n<p>H\u00ecnh d\u01b0\u1edbi minh ho\u1ea1 c\u00f4ng th\u1ee9c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4936 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-extra-spaces-excel.png\" width=\"247\" height=\"201\" title=\"count-extra-spaces-excel\"><\/p>\n<p>L\u01b0u \u00fd. C\u00f4ng th\u1ee9c tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 kho\u1ea3ng tr\u1eafng th\u1eeba, bao g\u1ed3m kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, ph\u00eda sau v\u00e0 kho\u1ea3ng tr\u1eafng th\u1eeba gi\u1eefa c\u00e1c ch\u1eef. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft t\u1ed5ng s\u1ed1 kho\u1ea3ng tr\u1eafng, d\u00f9ng h\u00e0m SUBSTITUTE<\/p>\n<h2><span class=\"ez-toc-section\" id=\"DANH_DAU_O_CO_KHOANG_TRANG_THUA\"><\/span><span id=\"DANH_DAU_O_CO_KHOANG_TRANG_THUA\" class=\"ez-toc-section\"><\/span><strong>\u0110\u00c1NH D\u1ea4U \u00d4 C\u00d3 KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi c\u00f3 nh\u1eefng th\u00f4ng tin nh\u1ea1y c\u1ea3m ho\u1eb7c quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ea7n ch\u1eeb kh\u00f4ng bi\u1ebft n\u00ean xo\u00e1 kho\u1ea3ng tr\u1eafng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u \u00f4 \u0111\u00f3 \u0111\u1ec3 ki\u1ec3m tra th\u00f4ng tin tr\u01b0\u1edbc khi quy\u1ebft \u0111\u1ecbnh xo\u00e1.<\/p>\n<p>\u0110\u1ec3 \u0111\u00e1nh d\u1ea5u, ta d\u00f9ng c\u00f4ng th\u1ee9c \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<p><strong>=LEN($A2)&gt;LEN(TRIM($A2))<\/strong><\/p>\n<p>A2 l\u00e0 \u00f4 d\u1eef li\u1ec7u tr\u00ean c\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u01b0\u1edbng d\u1eabn Excel \u0111\u00e1nh d\u1ea5u \u00f4 c\u00f3 \u0111\u1ed9 d\u00e0i \u0111o\u1ea1n ch\u1eef l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i \u0111o\u1ea1n ch\u1eef sau khi c\u1eaft b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba.<\/p>\n<p>\u0110\u1ec3 t\u1ea1o 1 c\u00f4ng th\u1ee9c \u0111i\u1ec1u ki\u1ec7n, ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u, b\u1ecf \u00f4 \u0111\u1ea7u c\u1ed9t, v\u00e0o\u00a0<strong>Home &gt; Styles &gt; Conditional formatting &gt; New Rule &gt; Use a formula to determine which cells to format.<\/strong><\/p>\n<p>\u1ede h\u00ecnh d\u01b0\u1edbi, k\u1ebft qu\u1ea3 kh\u1edbp v\u1edbi kho\u1ea3ng tr\u1eafng th\u1eeba ch\u00fang ta \u0111\u1ebfm \u1edf v\u00ed d\u1ee5 tr\u01b0\u1edbc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4937 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/highlight-extra-spaces-excel.png\" width=\"392\" height=\"541\" title=\"highlight-extra-spaces-excel\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026 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 <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. 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\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-88.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2705,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2704","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\/2704","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=2704"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2704\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2705"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}