{"id":11941,"date":"2025-01-15T06:21:45","date_gmt":"2025-01-15T06:21:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu\/"},"modified":"2025-01-15T06:21:45","modified_gmt":"2025-01-15T06:21:45","slug":"ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu\/","title":{"rendered":"H\u00e0m Right v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng tuy\u1ec7t v\u1eddi c\u1ee7a h\u00e0m Right trong ph\u00e2n xu\u1ea5t k\u00fd t\u1ef1"},"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> s\u1ebd\u00a0gi\u1ea3i th\u00edch c\u00e1c \u0111\u1eb7c tr\u01b0ng c\u1ee7a h\u00e0m Right\u00a0trong Excel v\u00e0 ch\u1ec9 ra nh\u1eefng c\u00e1ch t\u1ed1i \u01b0u \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Right\u00a0trong 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-678753f6b5f34\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Chuc_nang_cua_ham_Right_trong_Excel\" title=\"Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m Right trong Excel\">Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m Right trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Cach_su_dung_ham_Right_trong_Excel_Vi_du_mau\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right trong Excel, V\u00ed d\u1ee5 m\u1eabu\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right trong Excel, V\u00ed d\u1ee5 m\u1eabu<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Cach_phan_xuat_chuoi_ky_tu_con_theo_sau_mot_ky_tu_xac_dinh\" title=\"C\u00e1ch ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con theo sau m\u1ed9t k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh\">C\u00e1ch ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con theo sau m\u1ed9t k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Cach_phan_xuat_chuoi_ky_tu_con_xuat_hien_sau_dau_phan_cach_cuoi_cung\" title=\"C\u00e1ch ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con xu\u1ea5t hi\u1ec7n sau d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng\">C\u00e1ch ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con xu\u1ea5t hi\u1ec7n sau d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Cach_doi_n_ky_tu_dau_tien_trong_mot_chuoi\" title=\"C\u00e1ch d\u1eddi n k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong m\u1ed9t chu\u1ed7i\">C\u00e1ch d\u1eddi n k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong m\u1ed9t chu\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Ham_Right_trong_Excel_co_the_tra_ve_so_khong\" title=\"H\u00e0m Right trong Excel c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 kh\u00f4ng?\">H\u00e0m Right trong Excel c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 kh\u00f4ng?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html#Vi_sao_ham_Right_khong_thuc_hien_duoc_voi_ngay_thang\" title=\"V\u00ec sao h\u00e0m Right kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c v\u1edbi ng\u00e0y th\u00e1ng?\">V\u00ec sao h\u00e0m Right kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c v\u1edbi ng\u00e0y th\u00e1ng?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuc_nang_cua_ham_Right_trong_Excel\"><\/span>Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m Right trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">H\u00e0m RIGHT trong Excel gi\u00fap ph\u00e2n xu\u1ea5t\u00a0s\u1ed1 k\u00ed t\u1ef1 x\u00e1c \u0111\u1ecbnh trong chu\u1ed7i v\u0103n b\u1ea3n<\/p>\n<p style=\"text-align: justify\"><strong><em>= Right(Text,[num_chars])<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3:<\/p>\n<ul style=\"text-align: justify\">\n<li>Text (b\u1eaft bu\u1ed9c) \u2013 chu\u1ed7i v\u0103n nguy\u00ean b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n ph\u00e2n xu\u1ea5t k\u00ed t\u1ef1.<\/li>\n<li>Num-chars (kh\u00f4ng b\u1eaft bu\u1ed9c) \u2013 s\u1ed1 k\u00ed t\u1ef1 mu\u1ed1n ph\u00e2n xu\u1ea5t, t\u00ednh t\u1eeb k\u00ed t\u1ef1 b\u00ean ph\u1ea3i<\/li>\n<\/ul>\n<p style=\"text-align: justify\">+ N\u1ebfu b\u1ecf s\u00f3t num-chars, 1 k\u00ed t\u1ef1 cu\u1ed1i c\u00f9ng c\u1ee7a chu\u1ed7i s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i (m\u1eb7c \u0111\u1ecbnh)<\/p>\n<p style=\"text-align: justify\">+ N\u1ebfu num-chars nhi\u1ec1u h\u01a1n t\u1ed5ng k\u00ed t\u1ef1 c\u1ee7a chu\u1ed7i, t\u1ea5t c\u1ea3 k\u00ed t\u1ef1 s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i<\/p>\n<p style=\"text-align: justify\">+ N\u1ebfu num-chars l\u00e0 s\u1ed1 \u00e2m, c\u00f4ng th\u1ee9c h\u00e0m RIGHT s\u1ebd tr\u1ea3 v\u1ec1 #VALUE! Error (gi\u00e1 tr\u1ecb l\u1ed7i).<\/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\/2025\/01\/vba101_92019-nho-68.gif\" title=\"vba101_92019-nho-68\"><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\/2025\/01\/ex101_92019-nho-337.gif\" title=\"ex101_92019-nho-337\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, th\u1ec3 l\u1ea5y ra\u00a03 k\u00ed t\u1ef1 cu\u1ed1i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n \u00f4 A2, d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><em><strong>=RIGHT(A2, 3)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-4629 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/a.png\" width=\"275\" height=\"105\" title=\"a\"><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd quan tr\u1ecdng: h\u00e0m RIGHT trong EXCEL lu\u00f4n tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, ngay c\u1ea3 khi gi\u00e1 tr\u1ecb g\u1ed1c l\u00e0 m\u1ed9t ch\u1eef s\u1ed1. \u0110\u1ec3 c\u00f4ng th\u1ee9c h\u00e0m RIGHT cho ra gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 n\u00ean k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c 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<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Right_trong_Excel_Vi_du_mau\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right trong Excel, V\u00ed d\u1ee5 m\u1eabu<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Trong th\u1ef1c t\u1ebf, h\u00e0m RIGHT trong Excel hi\u1ebfm khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ed9c l\u1eadp, ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi m\u1ed9t h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ea1o nh\u1eefng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n trong Excel.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_phan_xuat_chuoi_ky_tu_con_theo_sau_mot_ky_tu_xac_dinh\"><\/span>C\u00e1ch ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con theo sau m\u1ed9t k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n ph\u00e2n xu\u1ea5t m\u1ed9t chu\u1ed7i k\u00ed t\u1ef1 con theo sau m\u1ed9t k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh, s\u1eed d\u1ee5ng c\u1ea3 <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> hay <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> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a k\u00ed t\u1ef1 \u0111\u00f3, tr\u1eeb v\u1ecb tr\u00ed k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c ch\u1ecdn trong t\u1ed5ng chu\u1ed7i k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 ta d\u00f9ng h\u00e0m LEN, k\u00e9o s\u1ed1 k\u00ed t\u1ef1 mu\u1ed1n ch\u1ecdn t\u1eeb ph\u00eda b\u00ean ph\u1ea3i chu\u1ed7i v\u0103n b\u1ea3n ngu\u1ed3n.<\/p>\n<p style=\"text-align: justify\"><strong>RIGHT(<\/strong><em><strong>chu\u1ed7i v\u0103n b\u1ea3n<\/strong><\/em><strong>, LEN(<\/strong><em><strong>chu\u1ed7i v\u0103n b\u1ea3n<\/strong><\/em><strong>) \u2013 SEARCH(<\/strong><em><strong>k\u00ed t\u1ef1<\/strong><\/em><strong>,<\/strong><strong><em>\u00a0<\/em><\/strong><em><strong>chu\u1ed7i v\u0103n b\u1ea3n<\/strong><\/em><strong>))<\/strong><\/p>\n<p style=\"text-align: justify\">\u00d4 A2 ch\u1ee9a k\u00ed t\u1ef1 \u0111\u1ea7u v\u00e0 cu\u1ed1i \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch nhau b\u1edfi kho\u1ea3ng tr\u1ed1ng, k\u00e9o k\u00ed t\u1ef1 cu\u1ed1i sang m\u1ed9t c\u1ed9t kh\u00e1c. S\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c tr\u00ean, sau \u0111\u00f3 ghi A2 v\u00e0o kho\u1ea3ng tr\u1ed1ng c\u1ee7a chu\u1ed7i, v\u00e0 \u0111i\u1ec1n k\u00ed t\u1ef1 v\u00e0o kho\u1ea3ng tr\u1ed1ng \u201c\u201d.<\/p>\n<p style=\"text-align: justify\"><strong>=RIGHT(A2,LEN(A2)-SEARCH(\u201d \u201c,A2))<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1:<\/p>\n<p style=\"text-align: justify\"><strong>:<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4630 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b.png\" width=\"246\" height=\"183\" title=\"b\"><\/strong><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p t\u01b0\u01a1ng t\u1ef1, c\u00f3 th\u1ec3 ph\u00e2n xu\u1ea5t \u0111\u01b0\u1ee3c chu\u1ed7i k\u00ed t\u1ef1 con theo sau b\u1ea5t c\u1ee9 k\u00ed t\u1ef1 n\u00e0o kh\u00e1c nh\u01b0: (,) (;) (-)\u2026 V\u00ed d\u1ee5, \u0111\u1ec3 ph\u00e2n xu\u1ea5t m\u1ed9t chu\u1ed7i k\u00ed t\u1ef1 con theo sau d\u1ea5u (-), d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong>=RIGHT(A2,LEN(A2)-SEARCH(\u201c-\u201c,A2)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4631 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/c.png\" width=\"247\" height=\"181\" title=\"c\"><\/p>\n<h1 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Cach_phan_xuat_chuoi_ky_tu_con_xuat_hien_sau_dau_phan_cach_cuoi_cung\"><\/span>C\u00e1ch ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con xu\u1ea5t hi\u1ec7n sau d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Khi x\u1eed l\u00ed nh\u1eefng chu\u1ed7i ph\u1ee9c t\u1ea1p ch\u1ee9a nhi\u1ec1u d\u1ea5u ph\u00e2n c\u00e1ch, b\u1ea1n th\u01b0\u1eddng ph\u1ea3i kh\u00f4i ph\u1ee5c l\u1ea1i chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ebfn b\u00ean ph\u1ea3i c\u1ee7a d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng. \u0110\u1ec3 \u0111\u01a1n gi\u1ea3n h\u01a1n, theo d\u00f5i b\u1ea3ng ch\u1ee9a d\u1eef li\u1ec7u ngu\u1ed3n v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4632 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/d.png\" width=\"439\" height=\"121\" title=\"d\"><\/p>\n<p style=\"text-align: justify\">T\u1eeb b\u1ea3ng tr\u00ean c\u00f3 th\u1ec3 th\u1ea5y c\u1ed9t A ch\u1ee9a m\u1ed9t chu\u1ed7i l\u1ed7i (ERROR). Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 k\u00e9o ph\u1ea7n m\u00f4 t\u1ea3 l\u1ed7i theo sau d\u1ea5u (:) c\u1ee7a t\u1eebng chu\u1ed7i. Ph\u1ee9c t\u1ea1p h\u01a1n n\u1eefa \u0111\u00f3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c c\u00f3 th\u1ec3 ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng d\u1ea5u ph\u00e2n c\u00e1ch kh\u00e1c nhau nh\u01b0 \u00f4 A3 ch\u1ee9a 3 d\u1ea5u (:) trong khi \u00f4 A5 ch\u1ec9 c\u00f3 1.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft, c\u1ea7n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng trong chu\u1ed7i ngu\u1ed3n (trong v\u00ed d\u1ee5 l\u00e0 d\u1ea5u (:) cu\u1ed1i c\u00f9ng). \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u1ea7n c\u00f3 nh\u1eefng h\u00e0m ch\u1ee9c n\u0103ng kh\u00e1c:<\/p>\n<ol style=\"text-align: justify\">\n<li>L\u1ea5y s\u1ed1 l\u01b0\u1ee3ng d\u1ea5u ph\u00e2n c\u00e1ch trong chu\u1ed7i ngu\u1ed3n:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>T\u00ednh t\u1ed5ng \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n, d\u00f9ng <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>: LEN(A2)<\/li>\n<li>T\u00ednh chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i khi kh\u00f4ng c\u00f3 d\u00e2u ph\u00e2n c\u00e1ch b\u1eb1ng <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 SUBTITUTE<\/a> \u0111\u1ec3 b\u1ecf to\u00e0n b\u1ed9 c\u00e1c d\u1ea5u ph\u00e2n c\u00e1ch: <strong><em>LEN(SUBSITUTE(A2,\u201c:\u201d,\u201c\u201d)<\/em><\/strong><\/li>\n<li>Tr\u1eeb chi\u1ec1u d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c kh\u00f4ng ch\u1ee9a d\u1ea5u ng\u0103n c\u00e1ch t\u1eeb t\u1ed5ng chu\u1ed7i v\u0103n b\u1ea3n ngu\u1ed3n: <strong><em>LEN(A2)-LEN(SUBSTITUTE(A2,\u201d:\u201d,\u201d\u201d)<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c \u0111\u00fang, c\u00f3 th\u1ec3 chia c\u00f4ng th\u1ee9c ra c\u00e1c \u00f4 ri\u00eang, s\u1ebd c\u00f3 2 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, \u00f4 A2 ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng d\u1ea5u (:).<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Thay th\u1ebf d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng v\u1edbi t\u1eebng k\u00ed t\u1ef1 ri\u00eang bi\u1ec7t. \u0110\u1ec3 ph\u00e2n xu\u1ea5t v\u0103n b\u1ea3n \u0111\u1ee9ng sau d\u1ea5u ph\u00e2n c\u00e1ch trong chu\u1ed7i, c\u1ea7n \u201c\u0111\u00e1nh d\u1ea5u\u201d d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng. \u0110\u1ec3 \u0111\u00e1nh d\u1ea5u, c\u1ea7n thay th\u1ebf d\u1ea5u (:) cu\u1ed1i c\u00f9ng v\u1edbi k\u00ed t\u1ef1 kh\u00f4ng xu\u1ea5t hi\u1ec7n trong chu\u1ed7i ngu\u1ed3n nh\u01b0 (#)<\/li>\n<\/ol>\n<p style=\"text-align: justify\">N\u1ebfu \u0111\u00e3 quen s\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE trong Excel, c\u00f3 th\u1ec3 b\u1ea1n nh\u1edb l\u1ef1a ch\u1ecdn th\u1ee9 4 (instance_num) ch\u1ec9 cho ph\u00e9p thay th\u1ebf m\u1ed9t v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh c\u1ee7a k\u00ed t\u1ef1 nh\u00e1t \u0111\u1ecbnh. Khi t\u00ednh xong s\u1ed1 l\u01b0\u1ee3ng d\u1ea5u ph\u00e2n c\u00e1ch c\u1ee7a chu\u1ed7i, b\u1ed5 sung v\u00e0o l\u1ef1a ch\u1ecdn th\u1ee9 4 b\u1eb1ng h\u00e0m SUBSTITUTE sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=SUBSTITUTE(A2,\u201d:\u201d,\u201d#\u201d,LEN(A2)LEN(SUBSTITUTE(A2,\u201d:\u201d,\u201d\u201d)))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">N\u1ebfu \u0111\u1eb7t c\u00f4ng th\u1ee9c n\u00e0y trong m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t, k\u1ebft qu\u1ea3 s\u1ebd quay l\u1ea1i chu\u1ed7i: <em>ERROR:432#Connection timed out<\/em><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li style=\"text-align: left\">L\u1ea5y v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng trong chu\u1ed7i. D\u1ef1a v\u00e0o k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c thay th\u1ebf v\u1edbi d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng, s\u1eed d\u1ee5ng c\u1ea3 h\u00e0m SEARCH ho\u1eb7c FIND \u0111\u1ec3 x\u00e1c \u0111\u1ecbn v\u1ecb tr\u00ed c\u1ee7a k\u00ed t\u1ef1 trong chu\u00f4i. Thay th\u1ebf d\u1ea5u (:) cu\u1ed1i c\u00f9ng v\u1edbi d\u1ea5u (#), d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0<em><strong>=SEARCH(\u201c#\u201d,SUBSTITUTE(A2,\u201d:\u201d,\u201d#\u201d,LEN(A2)LEN(SUBSTITUTE(A2,\u201d:\u201d,\u201d\u201d))))<\/strong><\/em><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 10, l\u00e0 v\u1ecb trs c\u1ee7a d\u1ea5u (#) trong chu\u1ed7i thay th\u1ebf.<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Tr\u1ea3 v\u1ec1 chu\u1ed7i k\u00ed t\u1ef1 con v\u1ec1 b\u00ean ph\u1ea3i d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng. V\u1ecb tr\u00ed c\u1ee7a d\u1ea5u ph\u00e2n c\u00e1ch cu\u1ed1i c\u00f9ng trong chu\u1ed7i \u0111\u00e3 x\u00e1c \u0111\u1ecbnh, tr\u1eeb s\u1ed1 \u0111\u00f3 t\u1eeb t\u1ed5ng \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i, sau \u0111\u00f3 d\u00f9ng h\u00e0m RIGHT \u0111\u1ec3 tr\u1ea3 v\u1ec1 nh\u1eefng k\u00ed t\u1ef1 c\u1ea7n t\u1eeb ph\u1ea7n k\u1ebft c\u1ee7a chu\u1ed7i ngu\u1ed3n: <em><strong>=RIGHT(A2,LEN(A2)SEARCH(\u201c$\u201d,SUBSTITUTE(A2,\u201d:\u201d,\u201d$\u201d,LEN(A2)-LEN(SUBSTITUTE(A2,\u201d:\u201d,\u201d\u201d)))))<\/strong><\/em><\/li>\n<\/ol>\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-4633 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/e.png\" width=\"599\" height=\"167\" title=\"e\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi b\u1ed9 d\u1eef li\u1ec7u l\u1edbn, nh\u1eefng \u00f4 kh\u00e1c nhau c\u00f3 th\u1ec3 ch\u1ee9a nhi\u1ec1u d\u1ea5u ph\u00e2n c\u00e1ch kh\u00e1c nhau, c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m IFERROR \u0111\u1ec3 khoanh v\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><em><strong>=IFERROR(RIGHT(A2,LEN(A2)SEARCH(\u201c$\u201d,SUBSTITUTE(A2,\u201d:\u201d,\u201d$\u201d,LEN(A2)LEN(SUBSTITUTE(A2,\u201d:\u201d,\u201d\u201d))))), A2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p chu\u1ed7i x\u00e1c \u0111\u1ecbnh kh\u00f4ng ch\u1ee9a d\u1ea5u ph\u00e2n c\u00e1ch x\u00e1c \u0111\u1ecbnh, chu\u1ed7i ngu\u1ed3n s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i, nh\u01b0 h\u00e0ng 6 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4634 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/f.png\" width=\"520\" height=\"205\" title=\"f\"><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_doi_n_ky_tu_dau_tien_trong_mot_chuoi\"><\/span>C\u00e1ch d\u1eddi n k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong m\u1ed9t chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Ngo\u00e0i ch\u1ee9c n\u0103ng ph\u00e2n xu\u1ea5t chu\u1ed7i k\u00ed t\u1ef1 con t\u1eeb cu\u1ed1i chu\u1ed7i, h\u00e0m RIGHT trong Excl c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1eddi s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb ph\u00eda \u0111\u1ea7u chu\u1ed7i, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>RIGHT(<\/strong><strong>string<\/strong><strong>, LEN(<\/strong><strong>string<\/strong><strong>)-<\/strong><strong>s\u1ed1_k\u00ed_t\u1ef1_c\u1ea7n_d\u1eddi<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><em>V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y th\u1ef1c hi\u1ec7n d\u1eddi 6 k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean (5 ch\u1eef c\u00e1i v\u00e0 1 d\u1ea5u (:)) t\u1eeb chu\u1ed7i A2, c\u00f4ng th\u1ee9c m\u1eabu:<\/em><\/p>\n<p style=\"text-align: justify\"><em><strong>=RIGHT(A2, LEN(A2)-6)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4635 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/g.png\" width=\"459\" height=\"163\" title=\"g\"><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Right_trong_Excel_co_the_tra_ve_so_khong\"><\/span>H\u00e0m Right trong Excel c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, h\u00e0m RIGHT trong Excel lu\u00f4n lu\u00f4n tr\u1ea3 v\u1ec1 chu\u1ed7i v\u0103n b\u1ea3n ngay c\u1ea3 hi gi\u00e1 tr\u1ecb ngu\u1ed3n l\u00e0 m\u1ed9t con s\u1ed1. Nh\u01b0ng n\u1ebfu\u00a0mu\u1ed1n s\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1 v\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 th\u00ec sao? M\u1ed9t gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n l\u00e0 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p h\u00e0m RIGHT trong h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n chu\u1ed7i ngu\u1ed3n t\u1eeb \u0111\u01a1n v\u1ecb s\u1ed1 sang \u0111\u01a1n v\u1ecb s\u1ed1.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 k\u00e9o 5 k\u00ed t\u1ef1 cu\u1ed1i t\u1eeb chu\u1ed7i A2 v\u00e0 chuy\u1ec3n k\u00ed t\u1ef1 ph\u00e2n t\u00e1ch th\u00e0nh s\u1ed1, d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><em><strong>=VALUE(RIGHT(A2, 5))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4636 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/h.png\" width=\"232\" height=\"159\" title=\"h\"><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_sao_ham_Right_khong_thuc_hien_duoc_voi_ngay_thang\"><\/span>V\u00ec sao h\u00e0m Right kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c v\u1edbi ng\u00e0y th\u00e1ng?<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">V\u00ec h\u00e0m RIGHT ch\u1ec9 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c v\u1edbi chu\u1ed7i v\u0103n b\u1ea3n trong khi ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng nh\u1eefng con s\u1ed1 \u1ea9n trong h\u1ec7 th\u1ed1ng Excel, h\u00e0m RIGHT kh\u00f4ng th\u1ec3 l\u1ea5y l\u1ea1i m\u1ed9t ph\u1ea7n c\u1ee7a ng\u00e0y nh\u01b0 ng\u00e0y, th\u00e1ng, hay n\u0103m. N\u1ebfu c\u1ed1 th\u1ef1c hi\u1ec7n, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 m\u1ed9t v\u00e0i ch\u1eef s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a m\u1ed9t ng\u00e0y.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, \u00f4 A1 ch\u1ee9a ng\u00e0y 18\/01\/2017. N\u1ebfu c\u1ed1 ph\u00e2n xu\u1ea5t n\u0103m v\u1edbi h\u00e0m RIGHT(A1,4), k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 2753 \u2013 4 con s\u1ed1 th\u1ec3 hi\u1ec7n 18\/1\/2017 trong h\u1ec7 th\u1ed1ng Excel.<\/p>\n<p style=\"text-align: justify\">V\u1eady l\u00e0m th\u1ec3 n\u00e0o \u0111\u1ec3 l\u1ea5y l\u1ea1i m\u1ed9t ph\u1ea7n nh\u1ea5t \u0111\u1ecbnh c\u1ee7a ng\u00e0y? S\u1eed d\u1ee5ng h\u00e0m sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e0m DAY \u0111\u1ec3 ph\u00e2n xu\u1ea5t ng\u00e0y: =DAY(A1)<\/li>\n<li>H\u00e0m MONTH \u0111\u1ec3 ph\u00e2n xu\u1ea5t th\u00e1ng: =MONTH(A1)<\/li>\n<li>H\u00e0m YEAR \u0111\u1ec3 ph\u00e2n xu\u1ea5t n\u0103m: =YEAR(A1)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 ra nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4637 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/i.png\" width=\"252\" height=\"120\" title=\"i\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng chu\u1ed7i v\u0103n b\u1ea3n, th\u01b0\u1eddng x\u1ea3y ra trong tr\u01b0\u1eddng h\u1ee3p xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n b\u00ean ngo\u00e0i, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m RIGHT \u0111\u1ec3 k\u00e9o m\u1ed9t v\u00e0i k\u00ed t\u1ef1 l\u00e0 m\u1ed9t ph\u1ea7n x\u00e1c \u0111\u1ecbnh c\u1ee7a ng\u00e0y \u1edf cu\u1ed1i c\u00f9ng c\u1ee7a d\u00e3y.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4638 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/k-1.png\" width=\"251\" height=\"203\" title=\"k-1\"><\/p>\n<p style=\"text-align: justify\">H\u00e0m Right trong Excel kh\u00f4ng hi\u1ec7u qu\u1ea3, nguy\u00ean nh\u00e2n v\u00e0 c\u00e1c kh\u1eafc ph\u1ee5c.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c h\u00e0m RIGHT kh\u00f4ng hi\u1ec7u qu\u1ea3 trong trang t\u00ednh, h\u1ea7u h\u1ebft l\u00e0 do nh\u1eefng nguy\u00ean nh\u00e2n sau:<\/p>\n<ol>\n<li style=\"text-align: justify\">C\u00f3 m\u1ed9t ho\u1eb7c nhi\u1ec1u h\u01a1n c\u00e1c kho\u1ea3ng tr\u1ed1ng trong d\u1eef li\u1ec7u ngu\u1ed3n. \u0110\u1ec3 nhanh ch\u00f3ng d\u1eddi nh\u1eefng kho\u1ea3ng tr\u1ed1ng trong \u00f4, s\u1eed d\u1ee5ng th\u00eam <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> hay CELL CLEANER.<\/li>\n<li style=\"text-align: justify\">S\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 num-chars nh\u1ecf h\u01a1n 0. N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 num-chars \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng nhwungx c\u00f4ng th\u1ee9c kh\u00e1c hay m\u1ed9t t\u1ed5 h\u1ee3p nh\u1eefng h\u00e0m kh\u00e1c nhau v\u00e0 h\u00e0m RIGHT tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #VALUE!, h\u00e3y ki\u1ec3m tra l\u1ea1i t\u1ed5 h\u1ee3p h\u00e0m.<\/li>\n<li style=\"text-align: justify\">Gi\u00e1 tr\u1ecb ngu\u1ed3n l\u00e0 ng\u00e0y th\u00e1ng.<\/li>\n<\/ol>\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\u00a0 \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\">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\/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\/2025\/01\/vba101_92019-nho-68.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11942,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11941","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\/11941","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=11941"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11942"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}