{"id":1144,"date":"2024-12-02T04:18:02","date_gmt":"2024-12-02T04:18:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten\/"},"modified":"2024-12-02T04:18:02","modified_gmt":"2024-12-02T04:18:02","slug":"ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten\/","title":{"rendered":"H\u00e0m LEFT v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u1ef1c hay c\u1ee7a h\u00e0m Left trong ph\u00e2n t\u00e1ch h\u1ecd t\u00ean"},"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:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a>\u00a0s\u1ebd gi\u00fap c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng<strong> h\u00e0m LEFT trong Excel<\/strong> \u0111\u1ec3 ph\u00e2n\u00a0xu\u1ea5t \u0111\u01b0\u1ee3c chu\u1ed7i k\u00ed t\u1ef1 con t\u1eeb ph\u1ea7n \u0111\u1ea7u c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n, ph\u00e2n xu\u1ea5t v\u0103n b\u1ea3n tr\u01b0\u1edbc m\u1ed9t k\u00ed t\u1ef1 x\u00e1c \u0111\u1ecbnh, bu\u1ed9c <strong>h\u00e0m LEFT<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1, v\u00e0 h\u01a1n th\u1ebf\u2026<\/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-674d34f91ccd5\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#CONG_THUC_HAM_LEFT_TRONG_EXCEL\" title=\"C\u00d4NG TH\u1ee8C H\u00c0M LEFT TRONG EXCEL\">C\u00d4NG TH\u1ee8C H\u00c0M LEFT TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#CACH_SU_DUNG_HAM_LEFT_TRONG_EXCEL_%E2%80%93_CONG_THUC_VI_DU\" title=\"C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M LEFT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C V\u00cd D\u1ee4\">C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M LEFT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C V\u00cd D\u1ee4<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#CACH_PHAN_XUAT_CHUOI_KY_TU_CON_DUNG_TRUOC_MOT_KI_TU_NHAT_DINH\" title=\"C\u00c1CH PH\u00c2N XU\u1ea4T CHU\u1ed6I K\u00dd T\u1ef0 CON \u0110\u1ee8NG TR\u01af\u1edaC M\u1ed8T K\u00cd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH\">C\u00c1CH PH\u00c2N XU\u1ea4T CHU\u1ed6I K\u00dd T\u1ef0 CON \u0110\u1ee8NG TR\u01af\u1edaC M\u1ed8T K\u00cd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#CACH_DOI_N_KI_TU_CUOI_KHOI_CHUOI_KI_TU\" title=\"C\u00c1CH D\u1edcI N K\u00cd T\u1ef0 CU\u1ed0I KH\u1eceI CHU\u1ed6I K\u00cd T\u1ef0\">C\u00c1CH D\u1edcI N K\u00cd T\u1ef0 CU\u1ed0I KH\u1eceI CHU\u1ed6I K\u00cd T\u1ef0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#CACH_BUOC_HAM_LEFT_TRA_KET_QUA_VE_LA_MOT_SO\" title=\"C\u00c1CH BU\u1ed8C H\u00c0M LEFT TR\u1ea2 K\u1ebeT QU\u1ea2 V\u1ec0 L\u00c0 M\u1ed8T S\u1ed0\">C\u00c1CH BU\u1ed8C H\u00c0M LEFT TR\u1ea2 K\u1ebeT QU\u1ea2 V\u1ec0 L\u00c0 M\u1ed8T S\u1ed0<\/a><\/li>\n<\/ul>\n<\/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\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#HAM_LEFT_KHONG_THUC_HIEN_DUOC_%E2%80%93_NGUYEN_NHAN_VA_CACH_KHAC_PHUC\" title=\"H\u00c0M LEFT KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C \u2013 NGUY\u00caN NH\u00c2N V\u00c0 C\u00c1CH KH\u1eaeC PH\u1ee4C\">H\u00c0M LEFT KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C \u2013 NGUY\u00caN NH\u00c2N V\u00c0 C\u00c1CH KH\u1eaeC PH\u1ee4C<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#NUM_CHARS_NHO_HON_O\" title=\"NUM_CHARS NH\u1ece H\u01a0N O\">NUM_CHARS NH\u1ece H\u01a0N O<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#KHOANG_TRONG_DUNG_DAU_TRONG_VAN_BAN_NGUON\" title=\"KHO\u1ea2NG TR\u1ed0NG \u0110\u1ee8NG \u0110\u1ea6U TRONG V\u0102N B\u1ea2N NGU\u1ed2N\">KHO\u1ea2NG TR\u1ed0NG \u0110\u1ee8NG \u0110\u1ea6U TRONG V\u0102N B\u1ea2N NGU\u1ed2N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html#HAM_LEFT_KHONG_THUC_HIEN_DUOC_VOI_NGAY_THANG\" title=\"H\u00c0M LEFT KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C V\u1edaI NG\u00c0Y TH\u00c1NG\">H\u00c0M LEFT KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C V\u1edaI NG\u00c0Y TH\u00c1NG<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_HAM_LEFT_TRONG_EXCEL\"><\/span>C\u00d4NG TH\u1ee8C H\u00c0M LEFT TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m LEFT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb m\u1edf \u0111\u1ea7u c\u1ee7a m\u1ed9t chu\u1ed7i.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c: <em><strong>LEFT(text, [num_chars])<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3:<\/p>\n<p style=\"text-align: justify\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>Text<\/strong> (b\u1eaft bu\u1ed9c): chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c \u0111\u1ec3 t\u1eeb \u0111\u00f3 ph\u00e2n xu\u1ea5t ra chu\u1ed7i k\u00ed t\u1ef1 con. \u0110\u00f3ng vai tr\u00f2 nh\u01b0 khung tham chi\u1ebfu c\u1ee7a \u00f4 ch\u1ee9a v\u0103n b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>Num_chars<\/strong> (kh\u00f4ng b\u1eaft bu\u1ed9c): s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 mu\u1ed1n ph\u00e2n xu\u1ea5t, b\u1eaft \u0111\u1ea7u t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i.<\/p>\n<p style=\"text-align: justify\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 N\u1ebfu num_chars b\u1ecb b\u1ecf s\u00f3t, t\u1ef1 \u0111\u1ed9ng k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 1 k\u00ed t\u1ef1.<\/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-27.gif\" title=\"vba101_92019-nho-27\"><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-81.gif\" title=\"ex101_92019-nho-81\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 N\u1ebfu num_chars l\u1edbn h\u01a1n t\u1ed5ng \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n, h\u00e0m LEFT s\u1ebd tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 v\u0103n b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 ph\u00e2n xu\u1ea5t 3 k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean t\u1eeb v\u0103n b\u1ea3n trong \u00f4 A2, d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\">\u00a0<strong><em>=LEFT(A2, 3)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4683 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1a.png\" width=\"338\" height=\"105\" title=\"1a\"><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd quan tr\u1ecdng: h\u00e0m LEFT thu\u1ed9c h\u00e0m v\u0103n b\u1ea3n, b\u1edfi v\u1eady k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m LEFT lu\u00f4n l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n, ngay c\u1ea3 khi gi\u00e1 tr\u1ecb ngu\u1ed3n \u0111\u1ec3 ph\u00e2n xu\u1ea5t k\u00ed t\u1ef1 l\u00e0 s\u1ed1. N\u1ebfu th\u1ef1c hi\u1ec7n h\u00e0m LEFT v\u1edbi d\u1eef li\u1ec7u s\u1ed1 v\u00e0 mu\u1ed1n k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 s\u1ed1, s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi <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<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_SU_DUNG_HAM_LEFT_TRONG_EXCEL_%E2%80%93_CONG_THUC_VI_DU\"><\/span>C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M LEFT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C V\u00cd D\u1ee4<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel \u0111\u1ec3 gi\u1ea3i quy\u1ebft nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_PHAN_XUAT_CHUOI_KY_TU_CON_DUNG_TRUOC_MOT_KI_TU_NHAT_DINH\"><\/span>C\u00c1CH PH\u00c2N XU\u1ea4T CHU\u1ed6I K\u00dd T\u1ef0 CON \u0110\u1ee8NG TR\u01af\u1edaC M\u1ed8T K\u00cd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n ph\u00e2n xu\u1ea5t m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ee9ng tr\u01b0\u1edbc m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh. V\u00ed d\u1ee5, c\u1ea7n l\u1ea5y h\u1ecd (first name) trong c\u1ed9t t\u00ean \u0111\u1ea7y \u0111\u1ee7 (full name), hay l\u1ea5y m\u00e3 qu\u1ed1c gia tr\u1eeb c\u1ed9t s\u1ed1 \u0111i\u1ec7n tho\u1ea1i\u2026 Kh\u00f3 kh\u0103n \u1edf ch\u1ed7 m\u1ed7i t\u00ean v\u00e0 m\u1ed7i m\u00e3 l\u1ea1i ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 kh\u00e1c nhau, b\u1edfi v\u1eady kh\u00f4ng d\u1ec5 d\u00e0ng g\u00ec c\u00f3 th\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 x\u00e1c \u0111\u1ecbnh trong num_chars b\u1eb1ng h\u00e0m LEFT nh\u01b0 v\u00ed d\u1ee5 tr\u00ean.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu h\u1ecd v\u00e0 t\u00ean \u0111\u01b0\u1ee3c ph\u00e2n c\u00e1ch b\u1edfi kho\u1ea3ng tr\u1ed1ng (d\u1ea5u c\u00e1ch), c\u00f4ng vi\u1ec7c chuy\u1ec3n sang l\u00e0 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a k\u00ed t\u1ef1 kho\u1ea3ng tr\u1ed1ng trong chu\u1ed7i. C\u00f4ng vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng v\u1edbi <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> ho\u1eb7c <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\">FIND<\/a>:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEFT(A2, SEARCH(\u201d \u201c, A2))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ph\u00e1t tri\u1ec3n th\u00eam c\u00f4ng th\u1ee9c, \u00a0lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1ed1ng b\u1eb1ng c\u00e1ch tr\u1eeb 1 t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m SEARCH (kh\u00f4ng hi\u1ec3n th\u1ecb trong c\u00e1c \u00f4, d\u1ea5u c\u00e1ch c\u00f3 th\u1ebb g\u00e2y n\u00ean nhi\u1ec1u v\u1ea5n \u0111\u1ec1, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi b\u1ea1n \u0111\u1ecbnh d\u00f9ng c\u00e1c t\u00ean \u0111\u01b0\u1ee3c ph\u00e2n xu\u1ea5t trong c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c).<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEFT(A2, SEARCH(\u201d \u201c, A2)-1)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4684 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1b.png\" width=\"229\" height=\"184\" title=\"1b\"><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 b\u1ea1n c\u00f3 th\u1ec3 ph\u00e2n xu\u1ea5t m\u00e3 qu\u1ed1c gia t\u1eeb c\u1ed9t s\u1ed1 \u0111i\u1ec7n tho\u1ea1i. Kh\u00e1c bi\u1ec7t duy h\u1ea5t \u1edf ch\u1ed7 d\u00f9ng h\u00e0m SEARCH \u0111\u1ec3 t\u00ecm ra v\u1ecb tr\u00ed d\u1ea5u (\u201c-\u201d) tr\u01b0\u1edbc kho\u1ea3ng tr\u1ed1ng:<\/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\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4685 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1c.png\" width=\"224\" height=\"178\" title=\"1c\"><\/p>\n<p style=\"text-align: justify\">T\u00f3m l\u1ea1i, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c chu\u1ed7i k\u00ed t\u1ef1 con \u0111\u1ee9ng tr\u01b0\u1edbc b\u1ea5t c\u1ee9 k\u00ed t\u1ef1 n\u00e0o:<\/p>\n<p style=\"text-align: justify\"><em><strong>LEFT(<\/strong><strong>chu\u1ed7i<\/strong><strong>, SEARCH\u00a0<\/strong><strong>(k\u00ed t\u1ef1,chu\u1ed7i<\/strong><strong>)-1)<\/strong><\/em><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DOI_N_KI_TU_CUOI_KHOI_CHUOI_KI_TU\"><\/span>C\u00c1CH D\u1edcI N K\u00cd T\u1ef0 CU\u1ed0I KH\u1eceI CHU\u1ed6I K\u00cd T\u1ef0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 bi\u1ebft, ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m LEFT l\u00e0 ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00ed t\u1ef1 con t\u1eeb \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n. Nh\u01b0ng n\u1ebfu mu\u1ed1n d\u1eddi m\u1ed9t s\u1ed1 k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb ph\u1ea7n cu\u1ed1i c\u1ee7a chu\u1ed7i v\u00e0 \u0111\u1eb7t ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a chu\u1ed7i v\u00e0o m\u1ed9t \u00f4 kh\u00e1c? Tr\u01b0\u1eddng h\u1ecdp n\u00e0y c\u00f3 th\u1ec3 k\u1ebft h\u01a1p d\u00f9ng h\u00e0m LEFT v\u00e0 LEN:<\/p>\n<p style=\"text-align: justify\"><em><strong>LEFT(<\/strong><strong><em>chu\u1ed7i<\/em>,<\/strong><\/em><strong>\u00a0<\/strong><strong>LEN(<\/strong><em><strong>chu\u1ed7i<\/strong><\/em><strong>) \u2013\u00a0<\/strong><em><strong>s\u1ed1_k\u00ed_t\u1ef1_mu\u1ed1n_d\u1eddi<\/strong><\/em><strong>)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng t\u00ean nguy\u00ean t\u1eafc: h\u00e0m LEN l\u1ea5y t\u1ed5ng s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed9t chu\u1ed7i. Sau \u0111\u00f3 tr\u1eeb \u0111i s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 kh\u00f4ng mong mu\u1ed1n t\u1eeb t\u1ed5ng \u0111\u1ed9 d\u00e0i c\u1ee7a d\u00e3y, h\u00e0m LEFT s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 k\u00ed t\u1ef1 c\u00f2n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 d\u1eddi 7 k\u00ed t\u1ef1 cu\u1ed1i c\u00f9ng c\u1ee7a v\u0103n b\u1ea3n trong \u00f4 A2, d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEFT(A2, LEN(A2)-7)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">B\u1ea3ng k\u1ebft qu\u1ea3 b\u00ean d\u01b0\u1edbi cho th\u1ea5y c\u00f4ng th\u1ee9c \u0111\u00e3 c\u1eaft ph\u1ea7n \u201c \u2013 ToDo\u201d (g\u1ed3m 4 ch\u1eef c\u00e1i, 1 d\u1ea5u g\u1ea1ch ngang, v\u00e0 2 kho\u1ea3ng tr\u1ed1ng) t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n trong c\u1ed9t A.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4687 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1d-1.png\" width=\"241\" height=\"166\" title=\"1d-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_BUOC_HAM_LEFT_TRA_KET_QUA_VE_LA_MOT_SO\"><\/span>C\u00c1CH BU\u1ed8C H\u00c0M LEFT TR\u1ea2 K\u1ebeT QU\u1ea2 V\u1ec0 L\u00c0 M\u1ed8T S\u1ed0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 bi\u1ebft, h\u00e0m LEFT lu\u00f4n tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 l\u00e0 v\u0103n b\u1ea3n ch\u1eef, ngay c\u1ea3 khi \u0111\u1eb7t m\u1ed9t v\u00e0i ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t con s\u1ed1. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m LEFT kh\u00f4ng th\u1ec3 d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n hay d\u00f9ng trong nh\u1eefng h\u00e0m kh\u00e1c trong Excel t\u1ea1o thi\u1ebft l\u1eadp s\u1ed1.<\/p>\n<p style=\"text-align: justify\">B\u1edfi v\u1eady, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m LEFT tr\u1ea3 v\u1ec1 l\u00e0 con s\u1ed1 thay v\u00ec chu\u1ed7i v\u0103n b\u1ea3n? C\u00e1ch \u0111\u01a1n gi\u1ea3n l\u00e0 s\u1eed d\u1ee5ng h\u00e0m VALUE \u2013 h\u00e0m \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 chuy\u1ec3n chu\u1ed7i con s\u1ed1 sang con s\u1ed1, s\u1eed d\u1ee5ng: <strong>VALUE(LEFT())<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 ph\u00e2n xu\u1ea5t 2 k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i trong \u00f4 A2 v\u00e0 chuy\u1ec3n k\u1ebft qu\u1ea3 sag con s\u1ed1, d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><em><strong>=VALUE(LEFT(A2,2))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng t\u1ef1 b\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4689 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1e.png\" width=\"171\" height=\"186\" title=\"1e\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 trong b\u1ea3ng, c\u1ed9t B thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 nh\u1eefng con s\u1ed1 t\u1eeb c\u00f4ng th\u1ee9c h\u00e0m VALUE LEFT. Khi Excel nh\u1eadn k\u1ebft qu\u1ea3 l\u00e0 nh\u1eefng con s\u1ed1, ph\u00e9p t\u00ednh t\u1ed5ng, t\u00ednh trung b\u00ecnh gi\u00e1 tr\u1ecb, t\u00ecm gi\u00e1 tr\u1ecb cao nh\u1ea5t \u2013 th\u1ea5p nh\u1ea5t, hay b\u1ea5t c\u1ee9 ph\u00e9p to\u00e1n n\u00e0o \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_LEFT_KHONG_THUC_HIEN_DUOC_%E2%80%93_NGUYEN_NHAN_VA_CACH_KHAC_PHUC\"><\/span>H\u00c0M LEFT KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C \u2013 NGUY\u00caN NH\u00c2N V\u00c0 C\u00c1CH KH\u1eaeC PH\u1ee4C<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu h\u00e0m LEFT kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c trong trang t\u00ednh, h\u1ea7u h\u1ebft l\u00e0 do nh\u1eefng nguy\u00ean nh\u00e2n sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>\n<h4><span class=\"ez-toc-section\" id=\"NUM_CHARS_NHO_HON_O\"><\/span>NUM_CHARS NH\u1ece H\u01a0N O<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c h\u00e0m LEFT tr\u1ea3 v\u1ec1 #VALUE (l\u1ed7i), \u0111\u1ea7u ti\u00ean c\u1ea7n ph\u1ea3i ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb c\u1ee7a num_chars. N\u1ebfu l\u00e0 s\u1ed1 \u00e2m, ch\u1ec9 c\u1ea7n lo\u1ea1i b\u1ecf c\u00e1c c\u1ea5u tr\u1eeb, l\u1ed7i s\u1ebd \u0111\u01b0\u1ee3c kh\u1eafc ph\u1ee5c.<\/p>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, l\u1ed7i th\u01b0\u1eddng x\u1ea3 ra khi num_chars \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng nh\u1eefng ch\u1ee9c n\u0103ng kh\u00e1c. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, copy h\u00e0m \u0111\u00f3 v\u00e0o m\u1ed9t \u00f4 kh\u00e1c ho\u1eb7c ch\u1ecdn tr\u00ean thanh c\u00f4ng th\u1ee9c, nh\u1ea5n F9 \u0111\u1ec3 xem h\u00e0m t\u01b0\u01a1ng \u0111\u01b0\u01a1ng. N\u1ebfu gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n 0, ki\u1ec3m tra l\u1ea1i h\u00e0m l\u1ed7i.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 ph\u00e2n xu\u1ea5t m\u00e3 qu\u1ed1c gia t\u1eeb s\u1ed1 \u0111i\u1ec7n tho\u1ea1i: LEFT(A2, SEARCH(\u201c-\u201c, A2)-1). H\u00e0m SEARCH trong ph\u1ea7n num_chars s\u1ebd t\u00ecm v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u (-) \u0111\u1ea7u ti\u00ean trong chu\u1ed7i ngu\u1ed3n, t\u1eeb \u0111\u00f3 ra tr\u1eeb 1 \u0111\u1ec3 x\u00f3a d\u1ea5u (-) kh\u1ecfi k\u1ebft qu\u1ea3 sau c\u00f9ng. N\u1ebfu thay th\u1ebf -1 v\u1edbi -11, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u00e8 k\u1ebft qu\u1ea3 l\u1ed7i #VALUE v\u00ec num_chars t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi s\u1ed1 \u00e2m:<\/p>\n<p style=\"text-align: justify\">t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi s\u1ed1 \u00e2m:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4690 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1f.png\" width=\"630\" height=\"106\" title=\"1f\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>\n<h4><span class=\"ez-toc-section\" id=\"KHOANG_TRONG_DUNG_DAU_TRONG_VAN_BAN_NGUON\"><\/span>KHO\u1ea2NG TR\u1ed0NG \u0110\u1ee8NG \u0110\u1ea6U TRONG V\u0102N B\u1ea2N NGU\u1ed2N<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p h\u00e0m LEFT l\u1ed7i kh\u00f4ng r\u00f5 l\u00ed do, ki\u1ec3m tra nh\u1eefng kho\u1ea3ng tr\u1ed1ng (d\u1ea5u c\u00e1ch) \u1edf \u0111\u1ea7u gi\u00e1 tr\u1ecb ngu\u1ed3n. N\u1ebfu \u0111\u00e3 th\u1ef1c hi\u1ec7n copy d\u1eef li\u1ec7u tr\u1eeb trang web hay t\u1eeb ngu\u1ed3n b\u00ean ngo\u00e0i, s\u1ebd c\u00f3 r\u1ea5t nhi\u1ec1u d\u1ea5u c\u00e1ch \u1ea9n \u0111\u1ee9ng tr\u01b0\u1edbc v\u0103n b\u1ea3n, \u0111i\u1ec1u n\u00e0y kh\u00f3 nh\u1eadn ra cho \u0111\u1ebfn khi c\u00f4ng th\u1ee9c h\u00e0m b\u00e1o l\u1ed7i, nh\u01b0 h\u00ecnh trong b\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4691 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1g.png\" width=\"471\" height=\"160\" title=\"1g\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 lo\u1ea1i b\u1ecf nh\u1eefng d\u1ea5u c\u00e1ch \u1edf \u0111\u1ea7u trang t\u00ednh, s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m TRIM<\/a> ho\u1eb7c b\u1ed5 sung h\u00e0m CELL CLEANER.<\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>\n<h4><span class=\"ez-toc-section\" id=\"HAM_LEFT_KHONG_THUC_HIEN_DUOC_VOI_NGAY_THANG\"><\/span>H\u00c0M LEFT KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C V\u1edaI NG\u00c0Y TH\u00c1NG<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify\">N\u1ebfu c\u1ed1 s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 ph\u00e2n xu\u1ea5t m\u1ed9t ph\u1ea7n trong ng\u00e0y (nh\u01b0 ng\u00e0y, th\u00e1ng, n\u0103m), trong h\u1ea7u h\u1ebft tr\u01b0\u1eddng h\u1ee3p, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 m\u1ed9t v\u00e0i con s\u1ed1 th\u1ec3 hi\u1ec7n ng\u00e0y th\u00e1ng. B\u1edfi trong Excel, t\u1ea5t c\u1ea3 ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng s\u1ed1 nguy\u00ean \u0111\u1ea1i di\u1ec7n cho s\u1ed1 ng\u00e0y; t\u1eeb 1\/1\/1900 l\u00e0 s\u1ed1 1 (do \u0111\u1ecbnh d\u1ea1ng Excel). Trong \u00f4 hi\u1ec3n th\u1ecb ch\u1ec9 l\u00e0 bi\u1ec3u di\u1ec5n tr\u1ef1c quan c\u1ee7a ng\u00e0y, v\u00e0 bi\u1ec3u di\u1ec5n \u0111\u00f3 c\u00f3 th\u1ec3 thay th\u1ebf b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, trong \u00f4 A1 c\u00f3 11- th\u00e1ng 1 \u2013 2017, khi th\u1ef1c hi\u1ec7n ph\u00e2n xu\u1ea5t b\u1eb1ng c\u00f4ng th\u1ee9c h\u00e0m LEFT(A1,2), k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 42 \u2013 2 ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean trong s\u1ed1 42746 bi\u1ec3u th\u1ecb ng\u00e0y 11\/1\/2017 trong h\u1ec7 th\u1ed1ng Excel.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ph\u00e2n xu\u1ea5t m\u1ed9t ph\u1ea7n x\u00e1c \u0111\u1ecbnh trong ng\u00e0y, s\u1eed d\u1ee5ng c\u00e1c h\u00e0m DAY, MONTH, ho\u1eb7c YEAR<\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p ng\u00e0y \u0111\u01b0\u1ee3c nh\u1eadp b\u1eb1ng chu\u1ed7i v\u0103n b\u1ea3n, h\u00e0m LEFT s\u1ebd hi\u1ec7u qu\u1ea3, k\u1ebft qu\u1ea3 th\u1ec3 hi\u1ec7n nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4692 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1h.png\" width=\"405\" height=\"163\" title=\"1h\"><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u1ee7a H\u1ecdc Excel Online v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel.\u00a0\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 <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">kh\u00f3a h\u1ecdc EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-27.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1144","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\/1144","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=1144"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1144\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1145"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}