{"id":3168,"date":"2024-12-03T01:18:25","date_gmt":"2024-12-03T01:18:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-khong-can-dung-ham\/"},"modified":"2024-12-03T01:18:25","modified_gmt":"2024-12-03T01:18:25","slug":"xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-khong-can-dung-ham","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-khong-can-dung-ham\/","title":{"rendered":"Xo\u00e1 t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong Excel KH\u00d4NG c\u1ea7n d\u00f9ng h\u00e0m"},"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, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch xo\u00e1 m\u1ecdi kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t \u1edf trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng m\u00e0 KH\u00d4NG c\u1ea7n d\u00f9ng h\u00e0m Excel n\u00e0o. Nghe c\u00f3 v\u1ebb h\u1ea5p d\u1eabn ph\u1ea3i kh\u00f4ng n\u00e0o<\/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-674e5c605e5f5\" 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\/huong-dan-cach-xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-voi-power-query.html#The_nao_la_ky_tu_khoang_trang_dac_biet\" title=\"Th\u1ebf n\u00e0o l\u00e0 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t?\">Th\u1ebf n\u00e0o l\u00e0 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t?<\/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\/huong-dan-cach-xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-voi-power-query.html#Xoa_tat_tan_tat_cac_ky_tu_khoang_trang_dac_biet_trong_Excel_voi_Power_Query\" title=\"Xo\u00e1 t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong Excel v\u1edbi Power Query\">Xo\u00e1 t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong Excel v\u1edbi Power Query<\/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\/huong-dan-cach-xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-voi-power-query.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"The_nao_la_ky_tu_khoang_trang_dac_biet\"><\/span>Th\u1ebf n\u00e0o l\u00e0 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Kho\u1ea3ng tr\u1eafng \u1edf \u0111\u00e2y l\u00e0 nh\u1eefng k\u00fd t\u1ef1, nh\u01b0ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tra-cuu-ki-tu-voi-ham-char-va-code-trong-excel.html\"><strong>CHAR trong Excel<\/strong><\/a> m\u00e0 ta kh\u00f4ng th\u1ec3 nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a n\u00f3 \u1edf c\u00e1c Cell trong trang t\u00ednh. V\u00ed d\u1ee5 nh\u01b0 d\u1ea5u c\u00e1ch, d\u1ea5u xu\u1ed1ng d\u00f2ng d\u00f2ng trong 1 \u00f4\u00a0 (Alt + Enter),\u2026.<\/p>\n<p style=\"text-align: justify\">Trong Excel c\u00f2n c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t kh\u00e1c n\u1eefa.\u00a0 Ta c\u00f3 th\u1ec3 l\u1ea5y ra n\u00f3 b\u1eb1ng h\u00e0m CHAR, c\u1ee5 th\u1ec3 sau \u0111\u00e2y H\u1ecdc Excel Online \u0111\u00e3 li\u1ec7t k\u00ea \u0111\u01b0\u1ee3c c\u00e1c CHAR m\u00e0 n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t.<\/p>\n<blockquote>\n<p>CHAR(2), CHAR(9), CHAR(10), CHAR(13), CHAR(28), CHAR(29), CHAR(30), CHAR(31), CHAR(32), CHAR(129), CHAR(143), CHAR(144), CHAR(157), CHAR(160)<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong Excel c\u00f3 m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ec3 xo\u00e1 b\u1ecf thay thay th\u1ebf c\u00e1c k\u00fd t\u1ef1\u00a0 v\u00ed d\u1ee5 nh\u01b0: TRIM, SUBSTITUTE, REPLACE. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c h\u00e0m \u0111\u00f3 ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html\"><em><strong>Xo\u00e1 kho\u1ea3ng tr\u1eafng v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel<\/strong><\/em><\/a><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\">SUBSTITUTE v\u00e0 40 t\u00ean c\u01b0\u1edbp<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, vi\u1ec7c v\u1eadn d\u1ee5ng \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch th\u00ec kh\u00e1 n\u00e2ng cao \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi ch\u01b0a t\u1ed1t k\u1ef9 n\u0103ng Excel. H\u01a1n n\u1eefa,\u00a0ta s\u1ebd kh\u00f4ng bi\u1ebft \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111ang g\u1eb7p n\u00f3 thu\u1ed9c CHAR n\u00e0o n\u00ean vi\u1ec7c x\u1eed l\u00fd l\u1ea1i c\u00e0ng tr\u1edf n\u00ean kh\u00f3 kh\u0103n h\u01a1n.<\/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-102.gif\" title=\"vba101_92019-nho-102\"><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-241.gif\" title=\"ex101_92019-nho-241\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3, m\u00ecnh c\u00f3 v\u00ed d\u1ee5 sau \u0111\u00e2y. B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y gi\u00e1 tr\u1ecb trong \u00f4 C3 l\u00e0 18 \u0111\u00f3, nh\u00ecn n\u00f3 l\u00e0 s\u1ed1 18 \u0111\u1ea5y. Tuy nhi\u00ean, khi ki\u1ec3m tra b\u1eb1ng h\u00e0m ISNUMBER k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 FALSE,\u00a0 hay th\u1ef1c hi\u1ec7n c\u1ed9ng n\u00f3 v\u1edbi 100 th\u00ec b\u00e1o l\u1ed7i #VALUE!.<\/p>\n<p style=\"text-align: justify\">M\u00ecnh c\u0169ng \u0111\u00e3 th\u1eed s\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE \u0111\u1ec3 thay th\u1ebf c\u00e1c CHAR v\u1edbi hy v\u1ecdng \u0111\u01b0a n\u00f3 v\u1ec1 \u0111\u01b0\u1ee3c d\u1ea1ng s\u1ed1 th\u00ec m\u00e3i t\u1edbi CHAR(160) th\u00ec m\u1edbi ra, v\u00e0 m\u1ea5t kha kh\u00e1 th\u1eddi gian cho vi\u1ec7c \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/1-9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30478\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-9-1024x444-1.png\" width=\"1024\" height=\"444\" title=\"1-9-1024x444-1\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1edbi c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c xu\u1ea5t ra t\u1eeb c\u00e1c ph\u1ea7n m\u1ec1m th\u00ec th\u01b0\u1eddng s\u1ebd c\u00f3 c\u00e1c l\u1ed7i \u0111\u00f3 v\u00e0 vi\u1ec7c x\u1eed l\u00fd s\u1ed1 li\u1ec7u tr\u00ean Excel g\u1eb7p r\u1ea5t nhi\u1ec1u kh\u00f3 kh\u0103n. Th\u1eadm ch\u00ed n\u1ebfu b\u1ea1n bi\u1ebft VBA v\u00e0 vi\u1ebft ra \u0111\u01b0\u1ee3c h\u00e0m \u0111\u1ec3 x\u1eed l\u00fd v\u1ea5n \u0111\u1ec1 tr\u00ean th\u00ec c\u0169ng kh\u00f4ng \u0111\u01a1n gi\u1ea3n.<\/p>\n<p style=\"text-align: justify\"><strong><em>V\u1eady gi\u1ea3i ph\u00e1p l\u00e0 g\u00ec?<\/em><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Xoa_tat_tan_tat_cac_ky_tu_khoang_trang_dac_biet_trong_Excel_voi_Power_Query\"><\/span>Xo\u00e1 t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong Excel v\u1edbi Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><em><strong>Gi\u1ea3i ph\u00e1p ch\u00ednh l\u00e0 Power Query<\/strong><\/em><\/span><\/p>\n<p style=\"text-align: justify\">V\u1edbi Power Query, ta s\u1ebd x\u1eed l\u00fd g\u1ecdn g\u1ebd v\u1ea5n \u0111\u1ec1 tr\u00ean m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 h\u1ebft s\u1ee9c d\u1ec5 d\u00e0ng. Ta th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn d\u1eef li\u1ec7u, t\u1ea1o n\u00f3 n\u00f3 1 Table n\u1ebfu mu\u1ed1n th\u00ec \u0111\u1eb7t t\u00ean Table \u0111\u00f3 c\u00f2n kh\u00f4ng th\u00ec c\u0169ng kh\u00f4ng sao. Sau \u0111\u00f3 v\u00e0o Power Query, \u0111\u01b0a b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0o Power Query t\u1eeb m\u1ee5c From Table\/Range. C\u1eeda s\u1ed5 Power Query hi\u1ec7n ra v\u00e0 n\u00f3 tr\u00f4ng gi\u1ed1ng nh\u01b0 n\u00e0y \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30479\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-10-1024x324-1.png\" width=\"1024\" height=\"324\" title=\"2-10-1024x324-1\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t, \u1edf \u0111\u00e2y l\u00e0 2 c\u1ed9t D\u1ef1 ki\u1ebfn v\u00e0 Th\u1ef1c t\u1ebf. Ti\u1ebfp theo, v\u00e0o Tab Transform -&gt; Format -&gt; Trim \u0111\u1ec3 lo\u1ea1i b\u1ecf m\u1ecdi k\u00fd t\u1ef1 c\u00e1c kho\u1ea3n tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong 2 c\u1ed9t \u0111\u00f3.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/3-8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30480\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-8.png\" width=\"1021\" height=\"391\" title=\"3-8\"><\/a><\/p>\n<p style=\"text-align: justify\">TRIM trong Power Query l\u1ee3i h\u1ea1i h\u01a1n TRIM trong Excel ph\u1ea3i kh\u00f4ng n\u00e0o<\/p>\n<p style=\"text-align: justify\">Ti\u1ebfp theo, b\u1ea1n th\u1ef1c hi\u1ec7n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng cho 2 c\u1ed9t D\u1ef1 ki\u1ebfn v\u00e0 Th\u1ef1c t\u1ebf v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/4-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30481\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-6-1.png\" width=\"489\" height=\"467\" title=\"4-6-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Close Power Query v\u00e0 Load v\u00e0o Excel th\u00f4i n\u00e0o.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, t\u1ea5t c\u1ea3 \u0111\u00e3 v\u1ec1 Number m\u1ed9t c\u00e1ch ngon l\u00e0nh r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i ng\u1ed3i suy ngh\u0129 v\u1ec1 c\u00e1c h\u00e0m Excel.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/5-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30482\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-5-1024x193-1.png\" width=\"1024\" height=\"193\" title=\"5-5-1024x193-1\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Qua b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>hy v\u1ecdng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch\u00a0x\u1eed l\u00fd \u0111\u01b0\u1ee3c nh\u1eefng k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t l\u1eabn l\u1ed9n trong d\u1eef li\u1ec7u quan tr\u1ecdng c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng m\u00e0 kh\u00f4ng ph\u1ea3i d\u00f9ng b\u1ea5t k\u1ef3 m\u1ed9t h\u00e0m Excel n\u00e0o. Ch\u1ec9 b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Power Query trong Excel.<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><em>\u0110\u00f3 l\u00e0 m\u1ed9t trong c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n c\u1ea7n bi\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd khi g\u1eb7p nh\u1eefng tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u v\u1edbi ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng \u0111\u00fang. V\u1edbi s\u1ef1 ph\u00e1t tri\u1ec3n v\u01b0\u1ee3t b\u1eadc c\u1ee7a c\u00f4ng ngh\u1ec7 nh\u01b0 hi\u1ec7n nay, v\u1ea5n \u0111\u1ec1 x\u1eed l\u00fd, \u0111\u01b0a ra \u0111\u01b0\u1ee3c nh\u1eefng d\u1eef li\u1ec7u chu\u1ea9n \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c l\u00e0m c\u00e1c b\u00e1o c\u00e1o ph\u00e2n t\u00edch m\u1ed9t c\u00e1ch c\u00f3 \u0111\u1ed9 tin c\u1eady cao nh\u1ea5t l\u00e0 r\u1ea5t quan tr\u1ecdng. Power Query l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t m\u1ea1nh gi\u00fap b\u1ea1n x\u1eed l\u00fd, bi\u1ebfn \u0111\u1ed5i \u0111\u01b0\u1ee3c nh\u1eefng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p v\u1ec1 \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng, \u0111\u00fang chu\u1ea9n. Vi\u1ec7c n\u1eafm \u0111\u01b0\u1ee3c Power Query trong Excel l\u00e0 c\u1ea7u n\u1ed1i gi\u00fap b\u1ea1n ti\u1ebfp c\u1eadn t\u1edbi 1 c\u00f4ng c\u1ee5 r\u1ea5t m\u1ea1nh kh\u00e1c c\u1ee7a Microsoft \u0111\u00f3 l\u00e0 <strong>Power BI \u2013 Power Business Intelligence.<\/strong><\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u00f9ng ch\u1ee7 \u0111\u1ec1 c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> \u1edf d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<hr>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html\">Xo\u00e1 kho\u1ea3ng tr\u1eafng v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Power Query \u0111\u1ec3 chu\u1ea9n ho\u00e1 d\u1eef li\u1ec7u<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html\">L\u1ea5y d\u1eef li\u1ec7u tr\u00ean trang Facebook c\u00e1 nh\u00e2n v\u00e0o excel v\u1edbi Power Query<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-name-dong-voi-power-query.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng name \u0111\u1ed9ng v\u1edbi Power Query trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html\">C\u00e1ch g\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng v\u00e0o 1 b\u1ea3ng s\u1eed d\u1ee5ng power query<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/pbi101-microsoft-power-bi-desktop-business-intelligence-trong-tam-tay\">PBI101 \u2013 Microsoft Power BI Desktop, Business Intelligence trong t\u1ea7m tay<\/a><\/strong><\/em><\/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-102.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3169,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3168","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\/3168","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=3168"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3169"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}