{"id":4212,"date":"2024-12-04T13:53:16","date_gmt":"2024-12-04T13:53:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel\/"},"modified":"2024-12-04T13:53:16","modified_gmt":"2024-12-04T13:53:16","slug":"xoa-khoang-trang-thua-bang-ham-trim-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel\/","title":{"rendered":"Xo\u00e1 kho\u1ea3ng tr\u1eafng th\u1eeba b\u1eb1ng h\u00e0m TRIM 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, <strong><a href=\"http:\/\/blog.ezworkapp.com\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n xo\u00e1 kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, ph\u00eda sau v\u00e0 kho\u1ea3ng tr\u1eafng th\u1eeba gi\u1eefa c\u00e1c t\u1eeb nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng,gi\u1ea3i th\u00edch l\u00fd do h\u00e0m TRIM b\u1ecb l\u1ed7i v\u00e0 c\u00e1ch s\u1eeda.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n \u0111ang so s\u00e1nh 2 c\u1ed9t m\u00e0 b\u1ea1n bi\u1ebft l\u00e0 s\u1ebd gi\u1ed1ng nhau, nh\u01b0ng c\u00f4ng th\u1ee9c l\u1ea1i kh\u00f4ng cho ra k\u1ebft qu\u1ea3 nh\u01b0 v\u1eady? Hay b\u1ea1n c\u1ed9ng 2 c\u1ed9t s\u1ed1 nh\u01b0ng t\u1ed5ng l\u1ea1i b\u1eb1ng 0? Ho\u1eb7c khi b\u1ea1n ch\u1eafc ch\u1eafn c\u00f4ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m VLOOKUP<\/a> c\u1ee7a b\u1ea1n ch\u00ednh x\u00e1c, th\u00ec l\u1ea1i tr\u1ea3 v\u1ec1 to\u00e0n l\u1ed7i? \u0110\u00f3 l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 m\u00e0 c\u00f3 l\u1ebd b\u1ea1n \u0111ang b\u0103n kho\u0103n. V\u00e0 t\u1ea5t c\u1ea3 \u0111\u1ec1u do nh\u1eefng kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf \u0111\u1ea7u, cu\u1ed1i ho\u1eb7c gi\u1eefa s\u1ed1 ho\u1eb7c \u0111o\u1ea1n ch\u1eef trong \u00f4 Excel.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4928 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/extra-spaces-excel.png\" width=\"595\" height=\"147\" title=\"extra-spaces-excel\"><\/p>\n<p style=\"text-align: justify\">Excel \u0111\u01b0a ra nh\u1eefng c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. Nh\u01b0ng trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m TRIM<\/a> \u2013 c\u00f4ng c\u1ee5 nhanh v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng th\u1eeba trong Excel.<\/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<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-67505ecb442b3\" 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-thua-bang-ham-trim-trong-excel.html#HAM_TRIM_XOA_KHOANG_TRANG_THUA_TRONG_EXCEL\" title=\"H\u00c0M TRIM, XO\u00c1 KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA TRONG EXCEL\">H\u00c0M TRIM, XO\u00c1 KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA TRONG EXCEL<\/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-khoang-trang-thua-bang-ham-trim-trong-excel.html#VI_DU_CACH_DUNG_HAM_TRIM_TRONG_EXCEL\" title=\"V\u00cd D\u1ee4 C\u00c1CH D\u00d9NG H\u00c0M TRIM TRONG EXCEL \">V\u00cd D\u1ee4 C\u00c1CH D\u00d9NG H\u00c0M TRIM TRONG EXCEL <\/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-khoang-trang-thua-bang-ham-trim-trong-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-4\" href=\"https:\/\/blog.hocexcel.online\/xoa-khoang-trang-thua-bang-ham-trim-trong-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-5\" href=\"https:\/\/blog.hocexcel.online\/xoa-khoang-trang-thua-bang-ham-trim-trong-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<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-khoang-trang-thua-bang-ham-trim-trong-excel.html#HAM_TRIM_EXCEL_LOI\" title=\"H\u00c0M TRIM EXCEL L\u1ed6I\">H\u00c0M TRIM EXCEL L\u1ed6I<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_TRIM_XOA_KHOANG_TRANG_THUA_TRONG_EXCEL\"><\/span><strong>H\u00c0M TRIM, XO\u00c1 KHO\u1ea2NG TR\u1eaeNG TH\u1eeaA TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng tr\u1eafng th\u1eeba trong chu\u1ed7i v\u0103n b\u1ea3n, bao g\u1ed3m c\u00e1c kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc, sau v\u00e0 gi\u1eefa chu\u1ed7i, ch\u1ec9 \u0111\u1ec3 l\u1ea1i 1 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb.<\/p>\n<p style=\"text-align: justify\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m TRIM r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/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-337.gif\" title=\"ex101_92019-nho-337\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>TRIM (chu\u1ed7i v\u0103n b\u1ea3n)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 thay chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng \u00f4 ch\u1ee9a chu\u1ed7i \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng trong \u00f4 A1, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(A1)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi l\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4929 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-trim-function.png\" width=\"287\" height=\"116\" title=\"excel-trim-function\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f2n ch\u1ee9a d\u1ea5u ng\u1eaft d\u00f2ng v\u00e0 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c ngo\u00e0i kho\u1ea3ng tr\u1eafng th\u1eeba, b\u1ea1n d\u00f9ng h\u00e0m TRIM k\u1ebft h\u1ee3p v\u1edbi CLEAN \u0111\u1ec3 xo\u00e1 32 k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c \u0111\u1ea7u ti\u00ean trong h\u1ec7 th\u1ed1ng ASCII 7-bit.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng, d\u1ea5u ng\u1eaft d\u00f2ng v\u00e0 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n kh\u1ecfi \u00f4 A1, d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(CLEAN(A1))<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VI_DU_CACH_DUNG_HAM_TRIM_TRONG_EXCEL\"><\/span><strong>V\u00cd D\u1ee4 C\u00c1CH D\u00d9NG H\u00c0M TRIM TRONG EXCEL <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1c ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n, gi\u1edd ch\u00fang ta xem x\u00e9t d\u00f9ng h\u00e0m TRIM trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">Xo\u00e1 kho\u1ea3ng tr\u1eafng trong c\u1ea3 c\u1ed9t d\u1eef li\u1ec7u<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 1 c\u1ed9t t\u00ean ch\u1ee9a kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u v\u00e0 cu\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n, c\u0169ng nh\u01b0 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb. V\u1eady b\u1ea1n l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xo\u00e1 m\u1ecdi kho\u1ea3ng tr\u1eafng tr\u01b0\u1edbc, sau v\u00e0 gi\u1eefa \u1edf t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong 1 l\u1ea7n? Ch\u00fang ta sao ch\u00e9p c\u00f4ng th\u1ee9c h\u00e0m TRIM \u0111\u1ebfn h\u1ebft c\u1ed9t, sau \u0111\u00f3 thay th\u1ebf c\u00e1c gi\u00e1 tr\u1ecb. C\u00e1c b\u01b0\u1edbc chi ti\u1ebft th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Vi\u1ebft c\u00f4ng th\u1ee9c h\u00e0m TRIM cho \u00f4 cao nh\u1ea5t, trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta l\u00e0 A2<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>=TRIM(A2)<\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Di chuy\u1ec3n con tr\u1ecf \u0111\u1ebfn v\u1ecb tr\u00ed g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 c\u00f4ng th\u1ee9c (trong v\u00ed d\u1ee5 l\u00e0 B2), v\u00e0 khi con tr\u1ecf chuy\u1ec3n th\u00e0nh d\u1ea5u c\u1ed9ng, k\u00edch \u0111\u00fap chu\u1ed9t \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng h\u1ebft c\u1ed9t, v\u1edbi \u00f4 d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng. K\u1ebft qu\u1ea3 b\u1ea1n s\u1ebd c\u00f3 2 c\u1ed9t \u2013 c\u1ed9t t\u00ean g\u1ed1c c\u00f2n kho\u1ea3ng tr\u1eafng v\u00e0 c\u1ed9t t\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c xo\u00e1 kho\u1ea3ng tr\u1eafng.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4930 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trim-formula-excel.png\" width=\"280\" height=\"223\" title=\"trim-formula-excel\"><\/li>\n<li>Cu\u1ed1i c\u00f9ng, thay gi\u00e1 tr\u1ecb \u1edf c\u1ed9t g\u1ed1c b\u1eb1ng gi\u00e1 tr\u1ecb \u1edf c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda. Nh\u01b0ng h\u00e3y c\u1ea9n th\u1eadn! Ch\u1ec9 \u0111\u01a1n gi\u1ea3n sao ch\u00e9p c\u1ed9t \u0111\u00e3 ch\u1ec9nh s\u1eeda sang c\u1ed9t t\u00ean g\u1ed1c c\u00f3 th\u1ec3 ph\u00e1 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n. \u0110\u1ec3 ng\u0103n l\u1ed7i n\u00e0y, b\u1ea1n ch\u1ec9 sao ch\u00e9p gi\u00e1 tr\u1ecb, kh\u00f4ng sao ch\u00e9p c\u00f4ng th\u1ee9c. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn c\u00e1c \u00f4 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c TRIM (trong v\u00ed d\u1ee5 l\u00e0 B2:B8), v\u00e0 nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p<\/li>\n<li>Ch\u1ecdn c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u g\u1ed1c (A2:A8), v\u00e0 nh\u1ea5n <strong>Ctrl + Alt + V<\/strong> r\u1ed3i nh\u1ea5n <strong>V<\/strong>. \u0110\u00f3 l\u00e0 ph\u00edm t\u1eaft cho <strong>Paste Special &gt; Values<\/strong><\/li>\n<li>Nh\u1ea5n Enter<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><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 style=\"text-align: justify\">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 style=\"text-align: justify\"><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-1.png\" width=\"271\" height=\"161\" title=\"trim-leading-spaces-numbers-1\"><\/p>\n<p style=\"text-align: justify\">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 style=\"text-align: justify\">\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 <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-1.png\" width=\"365\" height=\"252\" title=\"trim-leading-numbers-not-working-1\"><\/li>\n<\/ul>\n<p style=\"text-align: justify\">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 <strong>Paste Special &gt; Multiply<\/strong>).<\/p>\n<p style=\"text-align: justify\">C\u00e1ch nh\u1eb9 nh\u00e0ng h\u01a1n l\u00e0 l\u1ed3ng h\u00e0m TRIM trong <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m VALUE<\/a>:<\/p>\n<p style=\"text-align: justify\"><strong>=VALUE(TRIM(A2))<\/strong><\/p>\n<p style=\"text-align: justify\">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 style=\"text-align: justify\"><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-1.png\" width=\"365\" height=\"255\" title=\"remove-leading-spaces-numbers-1\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_XOA_KHOANG_TRANG_PHIA_TRUOC_LEFT_TRIM\"><\/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 style=\"text-align: justify\">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 style=\"text-align: justify\"><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-1.png\" width=\"447\" height=\"162\" title=\"remove-leading-spaces-excel-1\"><\/p>\n<p style=\"text-align: justify\">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 style=\"text-align: justify\"><strong>\u00a0=MID(A2,FIND(MID(TRIM(A2),1,1),A2),LEN(A2))<\/strong><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n k\u1ebft h\u1ee3p <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>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">MID<\/a> v\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 <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 style=\"text-align: justify\">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 style=\"text-align: justify\"><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-1.png\" width=\"336\" height=\"199\" title=\"trim-leading-spaces-1\"><\/p>\n<p style=\"text-align: justify\">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 style=\"text-align: justify\">\u0110\u1ebfm s\u1ed1 kho\u1ea3ng tr\u1eafng th\u1eeba trong 1 \u00f4<\/p>\n<p style=\"text-align: justify\">\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 style=\"text-align: justify\">\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 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\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><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-1.png\" width=\"247\" height=\"201\" title=\"count-extra-spaces-excel-1\"><\/p>\n<p style=\"text-align: justify\">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<blockquote>\n<p style=\"text-align: justify\">\u0110\u1eebng b\u1ecf l\u1ee1:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a h\u1ecdc excel k\u1ebf to\u00e1n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DANH_DAU_O_CO_KHOANG_TRANG_THUA\"><\/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 style=\"text-align: justify\">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 style=\"text-align: justify\">\u0110\u1ec3 \u0111\u00e1nh d\u1ea5u, ta d\u00f9ng c\u00f4ng th\u1ee9c \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<p style=\"text-align: justify\"><strong>=LEN($A2)&gt;LEN(TRIM($A2))<\/strong><\/p>\n<p style=\"text-align: justify\">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 style=\"text-align: justify\">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 style=\"text-align: justify\">\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 <strong>Home &gt; Styles &gt; Conditional formatting &gt; New Rule &gt; Use a formula to determine which cells to format.<\/strong><\/p>\n<p style=\"text-align: justify\">\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 style=\"text-align: justify\"><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-1.png\" width=\"392\" height=\"541\" title=\"highlight-extra-spaces-excel-1\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong excel<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_TRIM_EXCEL_LOI\"><\/span><strong>H\u00c0M TRIM EXCEL L\u1ed6I<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m TRIM \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 xo\u00e1 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng (m\u00e3 32 trong h\u1ec7 th\u1ed1ng ASCII 7-bit). Trong h\u1ec7 th\u1ed1ng Unicode, c\u00f2n c\u00f3 k\u00fd t\u1ef1 g\u1ecdi l\u00e0 kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft, m\u00e3 th\u1eadp ph\u00e2n 160\u00a0 \u2013 m\u00e3 html &nbsp; m\u00e0 h\u00e0m TRIM kh\u00f4ng th\u1ec3 xo\u00e1.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n 1 kho\u1ea3ng tr\u1eafng m\u00e0 h\u00e0m TRIM kh\u00f4ng xo\u00e1 \u0111\u01b0\u1ee3c, d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\"><strong>h\u00e0m SUBSTITUTE<\/strong><\/a> \u0111\u1ec3 chuy\u1ec3n kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft th\u00e0nh kho\u1ea3ng tr\u1eafng th\u01b0\u1eddng. Gi\u1ea3 s\u1eed chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 A1, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(SUBSTITUTE(A1, CHAR(160), \u201d \u201c))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4938 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-trim-not-working.png\" width=\"549\" height=\"107\" title=\"excel-trim-not-working\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c tr\u00ean c\u0169ng kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng, c\u00f3 th\u1ec3 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c c\u00f3 m\u00e3 ngo\u00e0i kho\u1ea3ng 0 \u2013 32 v\u00e0 kh\u00e1c 60. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm m\u00e3 k\u00fd t\u1ef1 \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\">Kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc: <strong>=CODE(LEFT(A1,1))<\/strong><\/p>\n<p style=\"text-align: justify\">Kho\u1ea3ng tr\u1eafng ph\u00eda sau: <strong>=CODE(RIGHT(A1,1)) <\/strong><\/p>\n<p style=\"text-align: justify\">A1 l\u00e0 \u00f4 c\u00f3 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">Kho\u1ea3ng tr\u1eafng \u1edf gi\u1eefa (n l\u00e0 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 l\u1ed7i trong chu\u1ed7i v\u0103n b\u1ea3n):<\/p>\n<p style=\"text-align: justify\"><strong>=CODE(MID(A1, n, 1)))<\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 \u0111\u01b0a m\u00e3 c\u1ee7a k\u00fd t\u1ef1 v\u00e0o c\u00f4ng th\u1ee9c TRIM(SUBSTITUTE()).<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 n\u1ebfu c\u00f4ng th\u1ee9c CODE tr\u1ea3 m\u00e3 l\u00e0 9, k\u00fd t\u1ef1 thanh ngang (Horizontal Tab), b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 xo\u00e1:<\/p>\n<p style=\"text-align: justify\"><strong>=TRIM(SUBSTITUTE(A1, CHAR(9), \u201d \u201c))<\/strong><\/p>\n<p style=\"text-align: justify\">C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc b\u00e0i vi\u1ebft. Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c v\u1edbi h\u00e0m TRIM th\u00e0nh c\u00f4ng!<\/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<\/p>\n<p>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<\/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-337.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4212","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\/4212","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=4212"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4213"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}