{"id":11997,"date":"2025-01-15T06:29:40","date_gmt":"2025-01-15T06:29:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel\/"},"modified":"2025-01-15T06:29:40","modified_gmt":"2025-01-15T06:29:40","slug":"xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel\/","title":{"rendered":"Xo\u00e1 kho\u1ea3ng tr\u1eafng v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong 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 h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch\/ kho\u1ea3ng tr\u1eafng trong Excel s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c. B\u1ea1n s\u1ebd h\u1ecdc <a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1eafn<\/a>g ph\u00eda tr\u01b0\u1edbc, sau trong 1 \u00f4, lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba gi\u1eefa c\u00e1c t\u1eeb, kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft v\u00e0 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c (non-printing character).<\/p>\n<p style=\"text-align: justify\">V\u1ea5n \u0111\u1ec1 l\u1edbn nh\u1ea5t v\u1edbi c\u00e1c kho\u1ea3ng tr\u1eafng l\u00e0 g\u00ec? Ch\u00fang ta kh\u00f4ng nh\u00ecn th\u1ea5y ch\u00fang. Ng\u01b0\u1eddi d\u00f9ng c\u1ea9n th\u1eadn c\u00f3 th\u1ec3 t\u00ecm ra kho\u1ea3ng tr\u1eafng \u1ea9n \u1edf tr\u01b0\u1edbc \u0111o\u1ea1n v\u0103n b\u1ea3n ho\u1eb7c v\u00e0i kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf gi\u1eefa c\u00e1c t\u1eeb. Nh\u01b0ng kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o t\u00ecm ra kho\u1ea3ng tr\u1eafng ph\u00eda sau, v\u00ec ch\u00fang ta kh\u00f4ng th\u1ec3 th\u1ea5y khi kho\u1ea3ng tr\u1eafng \u1edf cu\u1ed1i c\u00e1c \u00f4.<\/p>\n<p style=\"text-align: justify\">S\u1ebd kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1 g\u00ec n\u1ebfu nh\u1eefng kho\u1ea3ng tr\u1eafng th\u1eeba n\u1eb1m y\u00ean, nh\u01b0ng ch\u00fang s\u1ebd \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n. Khi 2 \u00f4 ch\u1ee9a \u0111o\u1ea1n v\u0103n b\u1ea3n gi\u1ed1ng nhau, 1 \u00f4 c\u00f3 kho\u1ea3ng tr\u1eafng c\u00f2n \u00f4 kia kh\u00f4ng c\u00f3, th\u00ec kho\u1ea3ng tr\u1eafng d\u00f9 nh\u1ecf \u0111\u1ebfn \u0111\u00e2u, d\u00f9 ch\u1ec9 l\u00e0 1 k\u00fd t\u1ef1 c\u0169ng khi\u1ebfn 2 \u00f4 c\u00f3 gi\u00e1 tr\u1ecb kh\u00e1c nhau. Khi \u0111\u00f3, b\u1ea1n s\u1ebd ph\u1ea3i \u0111au \u0111\u1ea7u t\u00ecm ra l\u00fd do t\u1ea1i sao c\u00f4ng th\u1ee9c \u0111\u00fang l\u1ea1i kh\u00f4ng hi\u1ec7u qu\u1ea3 v\u1edbi 2 d\u1eef li\u1ec7u nh\u00ecn gi\u1ed1ng nhau.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4943 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/leading-trailing-spaces-excel.png\" width=\"367\" height=\"206\" title=\"leading-trailing-spaces-excel\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n \u0111\u00e3 hi\u1ec3u v\u1ea5n \u0111\u1ec1, gi\u1edd l\u00e0 l\u00fac t\u00ecm ra gi\u1ea3i ph\u00e1p. C\u00f3 m\u1ed9t s\u1ed1 c\u00e1ch lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng trong Excel, v\u00e0 b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi c\u00f4ng vi\u1ec7c v\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/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-678755d1cc48c\" 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-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html#LOAI_BO_KHOANG_TRANG_THUA_TRONG_EXCEL_KHOANG_TRANG_PHIA_TRUOC_SAU_VA_GIUA_CAC_TU\" title=\"LO\u1ea0I B\u1ece KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA TRONG EXCEL, KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC, SAU, V\u00c0 GI\u1eeeA C\u00c1C T\u1eea:\">LO\u1ea0I B\u1ece KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA TRONG EXCEL, KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC, SAU, V\u00c0 GI\u1eeeA C\u00c1C T\u1eea:<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html#XOA_NGAT_DONG_VA_KY_TU_KHONG_IN_DUOC\" title=\"XO\u00c1 NG\u1eaeT D\u00d2NG V\u00c0 K\u00dd T\u1ef0 KH\u00d4NG IN \u0110\u01af\u1ee2C:\">XO\u00c1 NG\u1eaeT D\u00d2NG V\u00c0 K\u00dd T\u1ef0 KH\u00d4NG IN \u0110\u01af\u1ee2C:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html#XOA_BO_KHOANG_TRANG_KHONG_NGAT_NON-BREAKING_SPACE_TRONG_EXCEL\" title=\"XO\u00c1 B\u1ece KHO\u1ea2NG TR\u1eaeNG KH\u00d4NG NG\u1eaeT (NON-BREAKING SPACE) TRONG EXCEL\">XO\u00c1 B\u1ece KHO\u1ea2NG TR\u1eaeNG KH\u00d4NG NG\u1eaeT (NON-BREAKING SPACE) TRONG EXCEL<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html#XOA_1_KY_TU_KHONG_IN_DUOC_CU_THE\" title=\"XO\u00c1 1 K\u00dd T\u1ef0 KH\u00d4NG IN \u0110\u01af\u1ee2C C\u1ee4 TH\u1ec2\">XO\u00c1 1 K\u00dd T\u1ef0 KH\u00d4NG IN \u0110\u01af\u1ee2C C\u1ee4 TH\u1ec2<\/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\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html#XOA_MOI_KHOANG_TRANG_TRONG_EXCEL\" title=\"XO\u00c1 M\u1eccI KHO\u1ea2NG TR\u1eaeNG TRONG EXCEL\">XO\u00c1 M\u1eccI KHO\u1ea2NG TR\u1eaeNG TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html#DEM_KHOANG_TRANG_TRONG_EXCEL\" title=\"\u0110\u1ebeM KHO\u1ea2NG TR\u1eaeNG TRONG EXCEL\">\u0110\u1ebeM KHO\u1ea2NG TR\u1eaeNG TRONG EXCEL<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"LOAI_BO_KHOANG_TRANG_THUA_TRONG_EXCEL_KHOANG_TRANG_PHIA_TRUOC_SAU_VA_GIUA_CAC_TU\"><\/span><strong>LO\u1ea0I B\u1ece KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA TRONG EXCEL, KHO\u1ea2NG TR\u1eaeNG PH\u00cdA TR\u01af\u1edaC, SAU, V\u00c0 GI\u1eeeA C\u00c1C T\u1eea:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 c\u00e1c kho\u1ea3ng tr\u1eafng kh\u00f4ng c\u1ea7n thi\u1ebft, h\u00e0m TRIM s\u1ebd gi\u00fap b\u1ea1n xo\u00e1 b\u1ecf t\u1ea5t c\u1ea3 \u2013 kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, sau v\u00e0 gi\u1eefa c\u00e1c t\u1eeb (ch\u1ec9 \u0111\u1ec3 l\u1ea1i 1 kho\u1ea3ng tr\u1eafng) v\u1edbi ch\u1ec9 1 c\u00f4ng th\u1ee9c duy nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m TRIM<\/a> b\u00ecnh th\u01b0\u1eddng nh\u01b0 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-342.gif\" title=\"ex101_92019-nho-342\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>=TRIM(A2)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3 A2 l\u00e0 \u00f4 b\u1ea1n mu\u1ed1n xo\u00e1 b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4944 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-extra-spaces.png\" width=\"332\" height=\"261\" title=\"remove-extra-spaces\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 h\u00ecnh minh ho\u1ea1, h\u00e0m TRIM lo\u1ea1i b\u1ecf th\u00e0nh c\u00f4ng c\u00e1c kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u v\u00e0 cu\u1ed1i \u0111o\u1ea1n v\u0103n b\u1ea3n c\u0169ng nh\u01b0 kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf gi\u1eefa \u00f4.<\/p>\n<p style=\"text-align: justify\">V\u00e0 gi\u1edd, b\u1ea1n ch\u1ec9 c\u1ea7n thay th\u1ebf gi\u00e1 tr\u1ecb trong c\u1ed9t g\u1ed1c b\u1eb1ng gi\u00e1 tr\u1ecb trong c\u1ed9t TRIM. C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 l\u00e0m l\u00e0 d\u00f9ng <strong><em>Paste Special &gt; Values.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m TRIM ch\u1ec9 \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, gi\u1eef l\u1ea1i t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1eafng \u1edf gi\u1eefa \u0111o\u1ea1n v\u0103n b\u1ea3n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"XOA_NGAT_DONG_VA_KY_TU_KHONG_IN_DUOC\"><\/span><strong>XO\u00c1 NG\u1eaeT D\u00d2NG V\u00c0 K\u00dd T\u1ef0 KH\u00d4NG IN \u0110\u01af\u1ee2C:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n b\u00ean ngo\u00e0i, kh\u00f4ng ch\u1ec9 c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba xu\u1ea5t hi\u1ec7n m\u00e0 c\u00f2n th\u00eam nhi\u1ec1u k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c nh\u01b0 v\u1ec1 \u0111\u1ea7u d\u00f2ng (carriage return), xu\u1ed1ng d\u00f2ng (line feed), tab ngang (horizontal tab), tab d\u1ecdc (vertical tab).<\/p>\n<p style=\"text-align: justify\">H\u00e0m TRIM xo\u00e1 ho\u00e0n to\u00e0n kho\u1ea3ng tr\u1eafng, nh\u01b0ng kh\u00f4ng th\u1ec3 xo\u00e1 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c. V\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt, h\u00e0m TRIM \u0111\u01b0\u1ee3c thi\u1ebft k\u1ec3 ch\u1ec9 \u0111\u1ec3 xo\u00e1 k\u00fd t\u1ef1 32 trong h\u1ec7 th\u1ed1ng ASCII 7-bit, t\u1ee9c l\u00e0 kho\u1ea3ng tr\u1eafng.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 lo\u1ea1i tr\u1eeb c\u00e1c kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c trong Excel, d\u00f9ng h\u00e0m TRIM k\u1ebft h\u1ee3p v\u1edbi CLEAR. H\u00e0m CLEAR \u0111\u01b0\u1ee3c d\u00f9ng v\u1edbi m\u1ee5c \u0111\u00edch xo\u00e1 s\u1ea1ch d\u1eef li\u1ec7u, v\u00e0 h\u00e0m n\u00e0y c\u00f3 th\u1ec3 xo\u00e1 t\u1ea5t c\u1ea3 32 k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c trong ASCII 7 bit (m\u00e3 0 \u0111\u1ebfn 31) bao g\u1ed3m c\u1ea3 ng\u1eaft d\u00f2ng (line break \u2013 m\u00e3 10).<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed d\u1eef li\u1ec7u c\u1ea7n xo\u00e1 \u1edf \u00f4 A2, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(CLEAN(A2))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4945 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-nonprinting-chars.png\" width=\"322\" height=\"290\" title=\"remove-nonprinting-chars\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c Trim\/Clean khi\u1ebfn n\u1ed9i dung c\u00e1c d\u00f2ng n\u1ed1i v\u1edbi nhau v\u00e0 m\u1ea5t kho\u1ea3ng tr\u1eafng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i \u0111\u00f3 b\u1eb1ng 1 trong c\u00e1c c\u00e1ch sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>D\u00f9ng ch\u1ee9c n\u0103ng <strong>Replace All <\/strong>c\u1ee7a Excel: trong h\u1ed9p <strong>Find what<\/strong>, nh\u1eadp k\u00fd t\u1ef1 v\u1ec1 \u0111\u1ea7u d\u00f2ng b\u1eb1ng ph\u00edm t\u1eaft <strong>Ctrl + J<\/strong>, v\u00e0 trong h\u1ed9p <strong>Replace with<\/strong>, nh\u1eadp kho\u1ea3ng tr\u1eafng. Nh\u1ea5n n\u00fat <strong>Place All<\/strong> s\u1ebd xo\u00e1 m\u1ecdi d\u1ea5u ng\u1eaft d\u00f2ng v\u00e0 thay b\u1eb1ng kho\u1ea3ng tr\u1eafng<\/li>\n<li>D\u00f9ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 thay th\u1ebf k\u00fd t\u1ef1 v\u1ec1 \u0111\u1ea7u d\u00f2ng (m\u00e3 13) v\u00e0 xu\u1ed1ng d\u00f2ng (m\u00e3 10) b\u1eb1ng kho\u1ea3ng tr\u1eafng:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>=SUBSTITUTE(SUBSTITUTE(A2, CHAR(13),\u201d \u201c), CHAR(10), \u201d \u201c)<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"XOA_BO_KHOANG_TRANG_KHONG_NGAT_NON-BREAKING_SPACE_TRONG_EXCEL\"><\/span><strong>XO\u00c1 B\u1ece KHO\u1ea2NG TR\u1eaeNG KH\u00d4NG NG\u1eaeT (NON-BREAKING SPACE) TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu sau khi d\u00f9ng c\u00f4ng th\u1ee9c TRIM &amp; CLEAN, nh\u1eefng kho\u1ea3ng tr\u1eafng b\u01b0\u1edbng b\u1ec9nh v\u1eabn c\u00f2n, th\u00ec c\u00f3 th\u1ec3 do b\u1ea1n \u0111\u00e3 sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n ngo\u00e0i v\u00e0 c\u00f3 ch\u1ee9a kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 lo\u1ea1i b\u1ecf nh\u1eefng kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft (k\u00fd t\u1ef1 html\u00a0<em>&nbsp;<\/em><em>) thay th\u1ebf b\u1eb1ng kho\u1ea3ng tr\u1eafng th\u01b0\u1eddng, ta c\u00f3 c\u00f4ng th\u1ee9c h\u00e0m TRIM nh\u01b0 sau:<\/em><\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(SUBSTITUTE(A2, CHAR(160), \u201d \u201c))<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c, ch\u00fang ta c\u1ea7n chia nh\u1ecf c\u00f4ng th\u1ee9c tr\u00ean:<\/p>\n<ul style=\"text-align: justify\">\n<li>Kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft c\u00f3 m\u00e3 160 trong h\u1ec7 th\u1ed1ng ASCII 7-bit, do v\u1eady b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c CHAR(160) \u0111\u1ec3 bi\u1ec3u th\u1ecb.<\/li>\n<li>H\u00e0m SUBSTITUTE d\u00f9ng \u0111\u1ec3 chuy\u1ec3n kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft th\u00e0nh kho\u1ea3ng tr\u1eafng th\u01b0\u1eddng.<\/li>\n<li>V\u00e0 cu\u1ed1i c\u00f9ng, b\u1ea1n g\u1ed9p c\u00f4ng th\u1ee9c SUBSTITUTE v\u00e0o h\u00e0m TRIM \u0111\u1ec3 xo\u00e1 nh\u1eefng kho\u1ea3ng tr\u1eafng th\u01b0\u1eddng m\u00e0 kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft chuy\u1ec3n th\u00e0nh.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu trong b\u1ea3ng c\u00f2n ch\u1ee9a c\u1ea3 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c, d\u00f9ng h\u00e0m CLEAN k\u1ebft h\u1ee3p h\u00e0m TRIM v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUBSTITUTE<\/a> nh\u1eb1m xo\u00e1 nh\u1eefng kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n v\u1edbi 1 c\u00f4ng th\u1ee9c duy nh\u1ea5t:<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(CLEAN((SUBSTITUTE(A2,CHAR(160),\u201d \u201c))))<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi th\u1ec3 hi\u1ec7n s\u1ef1 kh\u00e1c nhau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4946 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-nonbreaking-space-excel.png\" width=\"633\" height=\"221\" title=\"remove-nonbreaking-space-excel\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"XOA_1_KY_TU_KHONG_IN_DUOC_CU_THE\"><\/span><strong>XO\u00c1 1 K\u00dd T\u1ef0 KH\u00d4NG IN \u0110\u01af\u1ee2C C\u1ee4 TH\u1ec2<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a 3 h\u00e0m trong v\u00ed d\u1ee5 tr\u00ean (TRIM, CLEAN v\u00e0 SUBSTITUTE) kh\u00f4ng th\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c trong b\u1ea3ng, th\u00ec c\u00f3 ngh\u0129a trong b\u1ea3ng ch\u1ee9a k\u00fd t\u1ef1 c\u00f3 m\u00e3 ASCII ngo\u00e0i kho\u1ea3ng 0 \u0111\u1ebfn 32 (k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c) v\u00e0 kh\u00e1c 160 (kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft).<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n<\/a> hay nh\u00e2\u0301t mo\u0323i th\u01a1\u0300i \u0111a\u0323i<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, d\u00f9ng h\u00e0m CODE \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh m\u00e3 k\u00fd t\u1ef1, sau \u0111\u00f3 d\u00f9ng SUBTITUTE thay th\u1ebf k\u00fd t\u1ef1 \u0111\u00f3 b\u1eb1ng kho\u1ea3ng tr\u1eafng th\u01b0\u1eddng v\u00e0 TRIM \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed kho\u1ea3ng tr\u1eafng ho\u1eb7c nh\u1eefng k\u00fd t\u1ef1 kh\u00f3 ch\u1ecbu m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i tr\u1eeb \u1edf trong \u00f4 A2, b\u1ea1n vi\u1ebft 2 c\u00f4ng th\u1ee9c:<\/p>\n<ol style=\"text-align: justify\">\n<li>Tr\u00f4ng \u00f4 B2, ph\u00e1t hi\u1ec7n m\u00e3 k\u00fd t\u1ef1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng 1 trong nh\u1eefng c\u00f4ng th\u1ee9c CODE:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>Kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c \u1edf \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>=CODE(LEFT(A2,1))<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c \u1edf cu\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>=CODE(RIGHT(A2,1))<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c \u1edf gi\u1eefa chu\u1ed7i v\u0103n b\u1ea3n, <em>n<\/em> l\u00e0 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>=CODE(MID(A2, n, 1)))<\/strong><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c ch\u01b0a bi\u1ebft m\u00e3 \u1edf gi\u1eefa chu\u1ed7i v\u0103n b\u1ea3n, \u1edf v\u1ecb tr\u00ed th\u1ee9 4, v\u1edbi c\u00f4ng th\u1ee9c sau ta s\u1ebd t\u00ecm ra m\u00e3 c\u1ee7a k\u00fd t\u1ef1 \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\"><strong>=CODE(MID(A2,4,1))<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e0m CODE tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 m\u00e3 127 (xem h\u00ecnh d\u01b0\u1edbi)<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>N\u1ebfu trong \u00f4 C2, b\u1ea1n thay th\u1ebf CHAR(127) b\u1eb1ng kho\u1ea3ng tr\u1eafng th\u01b0\u1eddng (\u201c\u201d), v\u00e0 r\u1ed3i lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng \u0111\u00f3:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>=TRIM(SUBSTITUTE(A2, CHAR(127), \u201d \u201c))<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4947 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/delete-nonprinting-char.png\" width=\"507\" height=\"145\" title=\"delete-nonprinting-char\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 m\u1ed9t v\u00e0i k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c kh\u00e1c nhau nh\u01b0 kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng 2 ho\u1eb7c nhi\u1ec1u h\u00e0m SUBSTITUTE \u0111\u1ec3 xo\u00e1 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n trong 1 l\u1ea7n.<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(SUBSTITUTE(SUBSTITUTE(A2, CHAR(127), \u201d \u201c), CHAR(160), \u201d \u201c)))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4948 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nonbreaking-space-nonprinting-char.png\" width=\"426\" height=\"106\" title=\"nonbreaking-space-nonprinting-char\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"XOA_MOI_KHOANG_TRANG_TRONG_EXCEL\"><\/span><strong>XO\u00c1 M\u1eccI KHO\u1ea2NG TR\u1eaeNG TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n xo\u00e1 m\u1ecdi kho\u1ea3ng tr\u1eafng trong 1 \u00f4, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c ch\u1eef v\u00e0 s\u1ed1. V\u00ed d\u1ee5 nh\u01b0 khi b\u1ea1n nh\u1eadp 1 c\u1ed9t s\u1ed1, kho\u1ea3ng tr\u1eafng \u0111\u1ec3 c\u00e1ch h\u00e0ng ngh\u00ecn, gi\u00fap \u0111\u1ecdc c\u00e1c s\u1ed1 l\u1edbn d\u1ec5 h\u01a1n, nh\u01b0ng ng\u0103n b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh to\u00e1n.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xo\u00e1 t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1eafng trong 1 l\u1ea7n, d\u00f9ng SUBSTITUTE nh\u01b0 trong v\u00ed d\u1ee5 tr\u00ean, \u0111i\u1ec3m kh\u00e1c duy nh\u1ea5t l\u00e0 b\u1ea1n thay th\u1ebf kho\u1ea3ng tr\u1eafng v\u1edbi m\u00e3 CHAR(32) b\u1eb1ng kh\u00f4ng (\u201c\u201d).<\/p>\n<p style=\"text-align: justify\"><strong>=SUBSTITUTE(A2, CHAR(32), \u201c\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c b\u1ea1n \u0111\u1ec3 kho\u1ea3ng tr\u1eafng trong d\u1ea5u ngo\u1eb7c k\u00e9p (\u201c \u201c), nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4949 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-all-spaces-excel.png\" width=\"286\" height=\"142\" title=\"remove-all-spaces-excel\"><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, thay th\u1ebf c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 c\u00e1c con s\u1ed1 c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n ch\u00ednh x\u00e1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DEM_KHOANG_TRANG_TRONG_EXCEL\"><\/span><strong>\u0110\u1ebeM KHO\u1ea2NG TR\u1eaeNG TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc khi lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng trong 1 \u00f4 nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 t\u00f2 m\u00f2 mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau kho\u1ea3ng tr\u1eafng trong \u00f4 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c s\u1ed1 kho\u1ea3ng tr\u1eafng trong 1 \u00f4, l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>T\u00ednh to\u00e1n \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n d\u00f9ng h\u00e0m <strong>LEN: LEN(A2)<\/strong><\/li>\n<li>Thay th\u1ebf m\u1ecdi kho\u1ea3ng tr\u1eafng b\u1eb1ng kh\u00f4ng: <strong>SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d)<\/strong><\/li>\n<li>T\u00ednh \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n khi kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng: <strong>LEN(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d))<\/strong><\/li>\n<li>L\u1ea5y t\u1ed5ng \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n tr\u1eeb \u0111i \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c \u1edf trong \u00f4 A2, c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=LEN(A2)-LEN(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm ra c\u00f3 bao nhi\u00eau kho\u1ea3ng tr\u1eafng th\u1eeba trong \u00f4, l\u1ea5y \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n khi kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba, sau \u0111\u00f3 l\u1ea5y t\u1ed5ng \u0111\u1ed9 d\u00e0i chu\u1ed7i tr\u1eeb \u0111i con s\u1ed1 v\u1eeba t\u00ecm \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><strong>=LEN(A2)-LEN(TRIM(A2))<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi minh ho\u1ea1 c\u1ea3 2 c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4950 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/count-spaces-excel.png\" width=\"535\" height=\"244\" title=\"count-spaces-excel\"><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n bi\u1ebft c\u00f3 bao nhi\u00eau kho\u1ea3ng tr\u1eafng trong m\u1ed7i \u00f4, b\u1ea1n c\u00f3 th\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng th\u1eeba b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m TRIM.<\/p>\n<p>\u2013 \u2013 \u2013 \u2013 \u2013<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\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\/2wbvASp\">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\">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\/2025\/01\/ex101_92019-nho-342.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11998,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11997","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\/11997","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=11997"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11997\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11998"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}