{"id":976,"date":"2024-12-02T03:15:56","date_gmt":"2024-12-02T03:15:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o\/"},"modified":"2024-12-02T03:15:56","modified_gmt":"2024-12-02T03:15:56","slug":"cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o\/","title":{"rendered":"C\u00c1CH D\u00d9NG H\u00c0M LEN TRONG EXCEL \u0110\u1ec2 \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-len-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html?ham-len-trong-excel\">\n<p style=\"text-align: justify\">C\u00f3 ph\u1ea3i b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t c\u00f4ng th\u1ee9c Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4? N\u1ebfu c\u00e2u tr\u1ea3 l\u1eddi l\u00e0 c\u00f3, th\u00ec b\u1ea1n \u0111\u00e3 t\u00ecm \u0111\u00fang trang r\u1ed3i \u0111\u1ea5y. B\u00e0i h\u01b0\u1edbng d\u1eabn ng\u1eafn n\u00e0y s\u1ebd d\u1ea1y b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <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> \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong Excel, d\u00f9 b\u1ea1n c\u00f3 t\u00ednh hay kh\u00f4ng t\u00ednh kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb.<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m Excel, h\u00e0m LEN \u0111\u01b0\u1ee3c coi l\u00e0 h\u00e0m d\u1ec5 v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t. T\u00ean h\u00e0m c\u0169ng r\u1ea5t d\u1ec5 nh\u1edb, kh\u00f4ng c\u00f3 g\u00ec ngo\u00e0i ba k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a t\u1eeb \u201clength\u201d. V\u00e0 \u0111\u00f3 l\u00e0 t\u00e1c d\u1ee5ng th\u1eadt s\u1ef1 c\u1ee7a h\u00e0m LEN \u2013 tr\u1ea3 v\u1ec1 chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1, hay chi\u1ec1u d\u00e0i c\u1ee7a m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: justify\">N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4, bao g\u1ed3m ch\u1eef c\u00e1i, ch\u1eef s\u1ed1, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, v\u00e0 t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn ng\u1eafn n\u00e0y, ch\u00fang ta s\u1ebd xem x\u00e9t nhanh c\u00fa ph\u00e1p tr\u01b0\u1edbc, r\u1ed3i s\u1ebd t\u00ecm hi\u1ec3u k\u1ef9 m\u1ed9t v\u00e0i m\u1eabu c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong b\u1ea3ng t\u00ednh Excel.<\/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-674d266ba4b3a\" 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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#HAM_LEN_TRONG_EXCEL\" title=\"H\u00c0M LEN TRONG EXCEL\">H\u00c0M LEN 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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#CACH_DUNG_HAM_LEN_TRONG_EXCEL_%E2%80%93_MAU_CONG_THUC\" title=\"C\u00c1CH D\u00d9NG H\u00c0M LEN TRONG EXCEL \u2013 M\u1eaaU C\u00d4NG TH\u1ee8C\">C\u00c1CH D\u00d9NG H\u00c0M LEN TRONG EXCEL \u2013 M\u1eaaU C\u00d4NG TH\u1ee8C<\/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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#CACH_DEM_TAT_CA_KY_TU_TRONG_MOT_O_BAO_GOM_KHOANG_TRONG\" title=\"C\u00c1CH \u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4 (BAO G\u1ed2M KHO\u1ea2NG TR\u1ed0NG)\">C\u00c1CH \u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4 (BAO G\u1ed2M KHO\u1ea2NG TR\u1ed0NG)<\/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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#DEM_SO_KY_TU_TRONG_NHIEU_O\" title=\"\u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG NHI\u1ec0U \u00d4\">\u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG NHI\u1ec0U \u00d4<\/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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#DEM_TAT_CA_KY_TU_TRONG_NHIEU_O\" title=\"\u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG NHI\u1ec0U \u00d4\">\u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG NHI\u1ec0U \u00d4<\/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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#CACH_DEM_SO_KY_TU_KHONG_TINH_KHOANG_TRONG_THUT_DAU_DONG_VA_THUT_CUOI_DONG\" title=\"C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 KH\u00d4NG T\u00cdNH KHO\u1ea2NG TR\u1ed0NG TH\u1ee4T \u0110\u1ea6U D\u00d2NG V\u00c0 TH\u1ee4T CU\u1ed0I D\u00d2NG\">C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 KH\u00d4NG T\u00cdNH KHO\u1ea2NG TR\u1ed0NG TH\u1ee4T \u0110\u1ea6U D\u00d2NG V\u00c0 TH\u1ee4T CU\u1ed0I D\u00d2NG<\/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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#CACH_DEM_SO_KY_TU_TRONG_MOT_O_MA_KHONG_TINH_CAC_KHOANG_TRONG\" title=\"C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4 M\u00c0 KH\u00d4NG T\u00cdNH C\u00c1C KHO\u1ea2NG TR\u1ed0NG\">C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4 M\u00c0 KH\u00d4NG T\u00cdNH C\u00c1C KHO\u1ea2NG TR\u1ed0NG<\/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\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html#CACH_DEM_SO_KY_TU_TRUOC_HAY_SAU_MOT_KY_TU_XAC_DINH\" title=\"C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TR\u01af\u1edaC HAY SAU M\u1ed8T K\u00dd T\u1ef0 X\u00c1C \u0110\u1ecaNH\">C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TR\u01af\u1edaC HAY SAU M\u1ed8T K\u00dd T\u1ef0 X\u00c1C \u0110\u1ecaNH<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_LEN_TRONG_EXCEL\"><\/span>H\u00c0M LEN TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m LEN trong Excel \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4, r\u1ed3i tr\u1ea3 v\u1ec1 chi\u1ec1u d\u00e0i chu\u1ed7i. N\u00f3 ch\u1ec9 c\u00f3 m\u1ed9t c\u00e2u l\u1ec7nh, c\u00e2u l\u1ec7nh n\u00e0y ch\u1eafc ch\u1eafn ph\u1ea3i c\u00f3 r\u1ed3i:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(text)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Text ch\u00ednh l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 n\u01a1i m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1. Ch\u1eb3ng c\u00f3 g\u00ec l\u00e0 d\u1ec5 h\u01a1n th\u1ebf, \u0111\u00fang kh\u00f4ng n\u00e0o?<\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n b\u00ean d\u01b0\u1edbi nh\u1eb1m gi\u00fap b\u1ea1n hi\u1ec3u s\u01a1 qua c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m LEN trong Excel.<\/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-64.gif\" title=\"ex101_92019-nho-64\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">=LEN(123) \u2013 tr\u1ea3 v\u1ec1 3, b\u1edfi v\u00ec 3 ch\u1eef s\u1ed1 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o c\u00e2u l\u1ec7nh text.<\/p>\n<p style=\"text-align: justify\">=LEN(\u201cgood\u201d) \u2013 tr\u1ea3 v\u1ec1 4, b\u1edfi v\u00ec t\u1eeb good c\u00f3 4 ch\u1eef c\u00e1i. Gi\u1ed1ng nh\u01b0 b\u1ea5t c\u1ee9 c\u00f4ng th\u1ee9c Excel n\u00e0o kh\u00e1c, h\u00e0m LEN b\u1eaft bu\u1ed9c b\u1ea1n ph\u1ea3i \u0111\u1eb7t chu\u1ed7i k\u00fd t\u1ef1 b\u00ean trong d\u1ea5u ngo\u1eb7c k\u00e9p, v\u00e0 d\u1ea5u ngo\u1eb7c k\u00e9p n\u00e0y s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c LEN, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i nh\u1eadp tham chi\u1ebfu \u00f4 thay v\u00ec ch\u1eef s\u1ed1 hay chu\u1ed7i k\u00fd t\u1ef1 , \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 hay m\u1ed9t d\u1ea3i \u00f4.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c chi\u1ec1u d\u00e0i chu\u1ed7i k\u00fd t\u1ef1 trong \u00f4 A1, b\u1ea1n s\u1ebd d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(A1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y s\u1ebd c\u00f3 th\u00eam nhi\u1ec1u v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i th\u00edch chi ti\u1ebft v\u00e0 c\u1ea3 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DUNG_HAM_LEN_TRONG_EXCEL_%E2%80%93_MAU_CONG_THUC\"><\/span>C\u00c1CH D\u00d9NG H\u00c0M LEN TRONG EXCEL \u2013 M\u1eaaU C\u00d4NG TH\u1ee8C<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tho\u1ea1t nh\u00ecn, h\u00e0m LEN tr\u00f4ng \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u1ed7i ch\u1eb3ng c\u1ea7n ph\u1ea3i gi\u1ea3i th\u00edch g\u00ec th\u00eam n\u1eefa. Tuy nhi\u00ean, c\u00f3 m\u1ed9t v\u00e0i m\u1eb9o h\u1eefu \u00edch c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c LEN trong Excel theo mong mu\u1ed1n c\u1ee7a m\u00ecnh.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DEM_TAT_CA_KY_TU_TRONG_MOT_O_BAO_GOM_KHOANG_TRONG\"><\/span>C\u00c1CH \u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4 (BAO G\u1ed2M KHO\u1ea2NG TR\u1ed0NG)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 n\u00f3i l\u00fac tr\u01b0\u1edbc, h\u00e0m LEN trong Excel \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 m\u1ed9t c\u00e1ch tuy\u1ec7t \u0111\u1ed1i, bao g\u1ed3m t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1ed1ng \u2013 th\u1ee5t \u0111\u1ea7u d\u00f2ng, th\u1ee5t cu\u1ed1i d\u00f2ng, v\u00e0 kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh chi\u1ec1u d\u00e0i c\u1ee7a \u00f4 A2, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEN(A2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c LEN \u0111\u1ebfm \u0111\u01b0\u1ee3c 36 k\u00fd t\u1ef1, bao g\u1ed3m 29 ch\u1eef c\u00e1i, 1 ch\u1eef s\u1ed1, v\u00e0 6 kho\u1ea3ng tr\u1ed1ng.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DEM_SO_KY_TU_TRONG_NHIEU_O\"><\/span>\u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG NHI\u1ec0U \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong nhi\u1ec1u \u00f4, h\u00e3y ch\u1ecdn \u00f4 c\u00f3 c\u00f4ng th\u1ee9c LEN r\u1ed3i sao ch\u00e9p sang \u00f4 kh\u00e1c, v\u00ed d\u1ee5 b\u1eb1ng c\u00e1ch k\u00e9o \u00f4 vu\u00f4ng n\u1eb1m d\u01b0\u1edbi g\u00f3c b\u00ean ph\u1ea3i .<\/p>\n<p style=\"text-align: justify\">Ngay khi sao ch\u00e9p c\u00f4ng th\u1ee9c, h\u00e0m LEN s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 k\u00fd t\u1ef1 \u0111\u1ebfm \u0111\u01b0\u1ee3c trong m\u1ed7i \u00f4.<\/p>\n<p style=\"text-align: justify\">V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, h\u00e3y l\u01b0u \u00fd r\u1eb1ng h\u00e0m LEN \u0111\u1ebfm t\u1ea5t c\u1ea3 m\u1ecdi th\u1ee9 m\u1ed9t c\u00e1ch tuy\u1ec7t \u0111\u1ed1i bao g\u1ed3m ch\u1eef c\u00e1i, ch\u1eef s\u1ed1, kho\u1ea3ng tr\u1ed1ng, d\u1ea5u ph\u1ea9y, d\u1ea5u ngo\u1eb7c k\u00e9p, d\u1ea5u ngo\u1eb7c \u0111\u01a1n, v\u00e0 c\u00f2n nhi\u1ec1u n\u1eefa:<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> Khi sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c c\u1ed9t kh\u00e1c, h\u00e3y ch\u1eafc r\u1eb1ng b\u1ea1n s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i ch\u1eb3ng h\u1ea1n nh\u01b0 LEN(A1), hay m\u1ed9t tham chi\u1ebfu h\u1ed7n h\u1ee3p nh\u01b0 LEN($A1) ch\u1ec9 d\u00f9ng c\u1ed1 \u0111\u1ecbnh cho c\u1ed9t, n\u00ean c\u00f4ng th\u1ee9c LEN c\u1ee7a b\u1ea1n s\u1ebd \u0111i\u1ec1u ch\u1ec9nh m\u1ed9t c\u00e1ch th\u00edch h\u1ee3p v\u1edbi v\u1ecb tr\u00ed m\u1edbi.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">C\u00e1c\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">h\u00e0m excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DEM_TAT_CA_KY_TU_TRONG_NHIEU_O\"><\/span>\u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG NHI\u1ec0U \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1ch r\u00f5 r\u00e0ng nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong v\u00e0i \u00f4 l\u00e0 th\u00eam v\u00e0i h\u00e0m LEN n\u1eefa, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(A2)+LEN(A3)+LEN(A4)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Hay, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m LEN:<\/p>\n<p style=\"text-align: justify\"><em><strong>=SUM(LEN(A2),LEN(A3),LEN(A4))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c, c\u00f4ng th\u1ee9c \u0111\u1ec1u \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed7i \u00f4 x\u00e1c \u0111\u1ecbnh r\u1ed3i tr\u1ea3 v\u1ec1 t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i:<\/p>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0y ch\u1eafc ch\u1eafn d\u1ec5 hi\u1ec3u v\u00e0 c\u0169ng d\u1ec5 s\u1eed d\u1ee5ng, nh\u01b0ng n\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t d\u1ea3i g\u1ed3m c\u00f3, gi\u1ea3 s\u1eed, 100 hay 1000 \u00f4. Tr\u00f4ng tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n n\u00ean d\u00f9ng h\u00e0m SUM v\u00e0 h\u00e0m LEN trong c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00e0 t\u00f4i s\u1ebd cho b\u1ea1n v\u00ed d\u1ee5 trong b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DEM_SO_KY_TU_KHONG_TINH_KHOANG_TRONG_THUT_DAU_DONG_VA_THUT_CUOI_DONG\"><\/span>C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 KH\u00d4NG T\u00cdNH KHO\u1ea2NG TR\u1ed0NG TH\u1ee4T \u0110\u1ea6U D\u00d2NG V\u00c0 TH\u1ee4T CU\u1ed0I D\u00d2NG<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi thao t\u00e1c v\u1edbi b\u1ea3ng t\u00ednh l\u1edbn th\u00ec v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn ch\u00ednh l\u00e0 kho\u1ea3ng c\u00e1ch \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng, v\u00ed d\u1ee5: kho\u1ea3ng tr\u1ed1ng \u1edf \u0111\u1ea7u hay \u1edf cu\u1ed1i k\u00fd t\u1ef1. C\u00f3 l\u1ebd b\u1ea1n h\u1ea7u nh\u01b0 kh\u00f4ng th\u1ea5y ch\u00fang tr\u00ean b\u1ea3ng t\u00ednh, nh\u01b0ng sau khi b\u1ea1n g\u1eb7p ch\u00fang m\u1ed9t v\u00e0i l\u1ea7n, th\u00ec b\u1ea1n s\u1ebd d\u1ec5 nh\u1eadn th\u1ea5y ch\u00fang h\u01a1n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n nghi ng\u1edd c\u00f3 v\u00e0i kho\u1ea3ng tr\u1ed1ng v\u00f4 h\u00ecnh trong c\u00e1c \u00f4 th\u00ec h\u00e0m LEN trong Excel s\u1ebd gi\u00fap \u00edch r\u1ea5t nhi\u1ec1u. Hy v\u1ecdng b\u1ea1n c\u00f2n nh\u1edb, n\u00f3 \u0111\u1ebfm t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1ed1ng trong ph\u00e9p \u0111\u1ebfm k\u00fd t\u1ef1:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c chi\u1ec1u d\u00e0i chu\u1ed7i m\u00e0 kh\u00f4ng \u0111\u1ebfm kho\u1ea3ng tr\u1ed1ng \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng, h\u00e3y l\u1ed3ng gh\u00e9p h\u00e0m TRIM v\u00e0o h\u00e0m LEN trong Excel:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(TRIM(A2))<\/em><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DEM_SO_KY_TU_TRONG_MOT_O_MA_KHONG_TINH_CAC_KHOANG_TRONG\"><\/span>C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG M\u1ed8T \u00d4 M\u00c0 KH\u00d4NG T\u00cdNH C\u00c1C KHO\u1ea2NG TR\u1ed0NG<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 m\u00e0 kh\u00f4ng t\u00ednh c\u00e1c kho\u1ea3ng tr\u1ed1ng cho d\u00f9 \u0111\u00f3 l\u00e0 kho\u1ea3ng tr\u1ed1ng \u0111\u1ea7u d\u00f2ng, cu\u1ed1i d\u00f2ng hay gi\u1eefa c\u00e1c t\u1eeb, th\u00ec b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f3 l\u1ebd b\u1ea1n \u0111\u00e3 bi\u1ebft, <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\">h\u00e0m SUBSTITUTE<\/a> thay th\u1ebf k\u00fd t\u1ef1 n\u00e0y v\u1edbi k\u00fd t\u1ef1 kh\u00e1c. Trong c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n thay th\u1ebf kho\u1ea3ng tr\u1ed1ng (\u201d \u201c) b\u1eb1ng m\u1ed9t k\u00fd t\u1ef1 r\u1ed7ng, v\u00ed d\u1ee5 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 r\u1ed7ng (\u201c\u201d). V\u00e0 b\u1edfi v\u00ec b\u1ea1n l\u1ed3ng gh\u00e9p h\u00e0m SUBSTITUTE v\u00e0o h\u00e0m LEN n\u00ean ph\u00e9p th\u1ebf th\u1eadt s\u1ef1 kh\u00f4ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n trong c\u00e1c \u00f4, m\u00e0 n\u00f3 ch\u1ec9 h\u01b0\u1edbng d\u1eabn c\u00f4ng th\u1ee9c LEN t\u00ednh chi\u1ec1u d\u00e0i chu\u1ed7i m\u00e0 kh\u00f4ng t\u00ednh c\u00e1c kho\u1ea3ng tr\u1ed1ng.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DEM_SO_KY_TU_TRUOC_HAY_SAU_MOT_KY_TU_XAC_DINH\"><\/span>C\u00c1CH \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TR\u01af\u1edaC HAY SAU M\u1ed8T K\u00dd T\u1ef0 X\u00c1C \u0110\u1ecaNH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n c\u1ea7n ph\u1ea3i bi\u1ebft chi\u1ec1u d\u00e0i c\u1ee7a m\u1ed9t ph\u1ea7n nh\u1ea5t \u0111\u1ecbnh c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1, thay v\u00ec \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch m\u00e3 h\u00e0ng h\u00f3a nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">V\u00e0 t\u1ea5t c\u1ea3 m\u00e3 h\u00e0ng h\u00f3a h\u1ee3p l\u1ec7 \u0111\u1ec1u c\u00f3 ch\u00ednh x\u00e1c 5 k\u00fd t\u1ef1 trong nh\u00f3m \u0111\u1ea7u ti\u00ean. V\u1eady l\u00e0m th\u1ebf n\u00e0o b\u1ea1n ch\u1ec9 ra \u0111\u01b0\u1ee3c m\u00e3 h\u00e0ng h\u00f3a n\u00e0o l\u00e0 kh\u00f4ng h\u1ee3p l\u1ec7? \u00c0 th\u00ec, b\u1eb1ng c\u00e1ch \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch ngang \u0111\u1ea7u ti\u00ean.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c chi\u1ec1u d\u00e0i Excel c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEN(LEFT($A2, SEARCH(\u201c-\u201c, $A2) -1))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y chia nh\u1ecf c\u00f4ng th\u1ee9c ra \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u quy lu\u1eadt c\u1ee7a n\u00f3:<\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-search-trong-excel-cach-dung-va-vi-du.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m SEARCH<\/a> \u0111\u1ec3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch ngang \u0111\u1ea7u ti\u00ean (\u201c-\u201c) trong \u00f4 A2:<\/p>\n<p style=\"text-align: justify\"><em><strong>SEARCH(\u201c-\u201c, $A2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c k\u00fd t\u1ef1 ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1, r\u1ed3i l\u1ea5y k\u1ebft qu\u1ea3 tr\u1eeb 1 b\u1edfi v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n t\u00ednh lu\u00f4n d\u1ea5u g\u1ea1ch ngang:<\/p>\n<p style=\"text-align: justify\"><em><strong>LEFT($A2,SEARCH(\u201c-\u201c, $A2) -1))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u00e0 cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 h\u00e0m LEN \u0111\u1ec3 tr\u1ea3 v\u1ec1 chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">Ngay khi c\u00f3 k\u1ebft qu\u1ea3, c\u00f3 l\u1ebd b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa, l\u00e0 \u0111\u00e1nh d\u1ea5u m\u00e3 h\u00e0ng h\u00f3a kh\u00f4ng h\u1ee3p l\u1ec7 b\u1eb1ng c\u00e1ch t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n \u0111\u01a1n gi\u1ea3n c\u00f3 c\u00f4ng th\u1ee9c =$B2&lt;&gt;5:<\/p>\n<p style=\"text-align: justify\">Hay, b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh m\u00e3 h\u00e0ng h\u00f3a kh\u00f4ng h\u1ee3p l\u1ec7 b\u1eb1ng c\u00e1ch l\u1ed3ng gh\u00e9p c\u00f4ng th\u1ee9c LEN \u1edf tr\u00ean v\u00e0o h\u00e0m IF:<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(LEN(LEFT($A2, SEARCH(\u201c-\u201c, $A2) -1))&lt;&gt;5, \u201cInvalid\u201d, \u201c\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c x\u00e1c \u0111\u1ecbnh m\u00e3 h\u00e0ng h\u00f3a kh\u00f4ng h\u1ee3p l\u1ec7 m\u1ed9t c\u00e1ch ho\u00e0n h\u1ea3o d\u1ef1a tr\u00ean chi\u1ec1u d\u00e0i chu\u1ed7i, v\u00e0 b\u1ea1n th\u1eadm ch\u00ed kh\u00f4ng c\u1ea7n m\u1ed9t c\u1ed9t \u0111\u1ebfm k\u00fd t\u1ef1 ri\u00eang bi\u1ec7t:<\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 sau m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, trong m\u1ed9t danh s\u00e1ch t\u00ean, c\u00f3 th\u1ec3 b\u1ea1n mu\u1ed1n bi\u1ebft h\u1ecd c\u1ee7a m\u1ed9t ng\u01b0\u1eddi c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1. C\u00f4ng th\u1ee9c LEN sau \u0111\u00e2y s\u1ebd gi\u1ea3i quy\u1ebft vi\u1ec7c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEN(RIGHT(A2, LEN(A2) -SEARCH(\u201d \u201c,A2)))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a kho\u1ea3ng tr\u1ed1ng (\u201d \u201c) trong chu\u1ed7i k\u00fd t\u1ef1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH: SEARCH(\u201c-\u201c,A2)))<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n \u0111\u1ebfm c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 ph\u00eda sau kho\u1ea3ng tr\u1ed1ng. V\u1ec1 vi\u1ec7c n\u00e0y, b\u1ea1n l\u1ea5y t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i tr\u1eeb \u0111i v\u1ecb tr\u00ed kho\u1ea3ng tr\u1ed1ng:<\/p>\n<p style=\"text-align: justify\"><em><strong>LEN(A2) -SEARCH(\u201c_\u201d, A2)))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m RIGHT<\/a> \u0111\u1ec3 tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 ph\u00eda sau kho\u1ea3ng tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\">V\u00e0 cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 t\u00ednh chi\u1ec1u d\u00e0i chu\u1ed7i \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m RIGHT.<\/p>\n<p style=\"text-align: justify\">Xin h\u00e3y l\u01b0u \u00fd r\u1eb1ng, \u0111\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, m\u1ed7i \u00f4 n\u00ean c\u00f3 ch\u1ec9 m\u1ed9t kho\u1ea3ng tr\u1ed1ng, v\u00ed d\u1ee5 ch\u1ec9 c\u00f3 t\u00ean v\u00e0 h\u1ecd, kh\u00f4ng c\u00f3 t\u00ean l\u00f3t, danh hi\u1ec7u hay h\u1eadu t\u1ed1.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed3ng th\u1eddi, xin c\u1ea3m \u01a1n c\u00e1c b\u1ea1n v\u00ec \u0111\u00e3 d\u00e0nh th\u1eddi gian \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y v\u00e0 hy v\u1ecdng s\u1ebd s\u1edbm g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n tr\u00ean trang blog.<\/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\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\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\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-64.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":977,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-976","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\/976","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=976"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/976\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/977"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}