{"id":11417,"date":"2025-01-15T03:03:57","date_gmt":"2025-01-15T03:03:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao\/"},"modified":"2025-01-15T03:03:57","modified_gmt":"2025-01-15T03:03:57","slug":"ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao\/","title":{"rendered":"H\u00e0m MID trong Excel \u2013 nh\u1eefng ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n v\u00e0 n\u00e2ng cao"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">MID l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m x\u1eed l\u00fd v\u0103n b\u1ea3n c\u1ee7a Excel, d\u00f9ng \u0111\u1ec3 thao t\u00e1c v\u1edbi m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. \u1ede m\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t, n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u n\u1eb1m \u1edf gi\u1eefa \u0111o\u1ea1n v\u0103n b\u1ea3n.Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng th\u1ea3o lu\u1eadn v\u1ec1 c\u00fa ph\u00e1p v\u00e0 t\u00ednh \u0111\u1eb7c tr\u01b0ng c\u1ee7a h\u00e0m MID trong Excel, sau \u0111\u00f3, <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y m\u1ed9t c\u00e1ch th\u1eadt h\u1eefu \u00edch.<\/span><\/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-6787259c5c49f\" 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-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Ham_MID_trong_Excel_%E2%80%93_cu_phap_va_nhung_cach_su_dung_co_ban\" title=\"H\u00e0m MID trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n\">H\u00e0m MID trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#5_dieu_can_biet_ve_ham_Excel_MID\" title=\"5 \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Excel MID\">5 \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Excel MID<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cac_vi_du_su_dung_cong_thuc_tinh_cua_ham_MID\" title=\" C\u00e1c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m MID\"> C\u00e1c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m MID<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_xuat_ten_va_ho\" title=\"C\u00e1ch xu\u1ea5t t\u00ean v\u00e0 h\u1ecd\">C\u00e1ch xu\u1ea5t t\u00ean v\u00e0 h\u1ecd<\/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\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Su_dung_ham_MID_de_trich_xuat_ho\" title=\"S\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u00edch xu\u1ea5t h\u1ecd\">S\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u00edch xu\u1ea5t h\u1ecd<\/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\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Su_dung_ham_MID_de_trich_xuat_ten\" title=\"S\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u00edch xu\u1ea5t t\u00ean\">S\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u00edch xu\u1ea5t t\u00ean<\/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\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_trich_xuat_chuoi_ky_tu_nam_giua_hai_dau_cach\" title=\"C\u00e1ch tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch\">C\u00e1ch tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch<\/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\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_trich_xuat_tu_thu_N_trong_mot_chuoi_van_ban\" title=\"C\u00e1ch tr\u00edch xu\u1ea5t t\u1eeb th\u1ee9 N trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n\">C\u00e1ch tr\u00edch xu\u1ea5t t\u1eeb th\u1ee9 N trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_hoat_dong_cua_cong_thuc_tren_nhu_sau\" title=\"C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_trich_xuat_mot_tu_chua_mot_hoac_nhieu_ky_tu_cu_the\" title=\"C\u00e1ch tr\u00edch xu\u1ea5t m\u1ed9t t\u1eeb ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 c\u1ee5 th\u1ec3\">C\u00e1ch tr\u00edch xu\u1ea5t m\u1ed9t t\u1eeb ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 c\u1ee5 th\u1ec3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_hoat_dong_cua_cong_thuc_tren_nhu_sau-2\" title=\"C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html#Cach_khien_ham_MID_tra_ve_mot_so\" title=\"C\u00e1ch khi\u1ebfn h\u00e0m MID tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1\">C\u00e1ch khi\u1ebfn h\u00e0m MID tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_MID_trong_Excel_%E2%80%93_cu_phap_va_nhung_cach_su_dung_co_ban\"><\/span><span style=\"font-family: georgia, palatino, serif\">H\u00e0m MID trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">N\u00f3i chung, h\u00e0m MID trong Excel \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 tr\u00edch m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u n\u1eb1m \u1edf gi\u1eefa v\u0103n b\u1ea3n g\u1ed1c. N\u00f3i m\u1ed9t c\u00e1ch c\u1ee5 th\u1ec3 h\u01a1n th\u00ec h\u00e0m MID tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 b\u1ea5t k\u00ec \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh s\u1eb5n b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed b\u1ea1n thi\u1ebft l\u1eadp.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">H\u00e0m MID trong Excel c\u00f3 nh\u1eefng \u0111\u1ed1i s\u1ed1 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>MID(text, start_num, num_chars)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Trong \u0111\u00f3,<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> Text<\/strong> l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> Start_num<\/strong> l\u00e0 v\u1ecb tr\u00ed c\u1ee7a d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> Num_chars<\/strong> l\u00e0 s\u1ed1 k\u00fd t\u1ef1 tr\u00edch xu\u1ea5t<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>V\u00ed d\u1ee5<\/strong>, \u0111\u1ec3 l\u1ea5y ra 8 k\u00fd t\u1ef1 t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n \u1edf h\u00e0ng A2, b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 10, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=MID(A2,10, 8)<\/strong><\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-294.gif\" title=\"ex101_92019-nho-294\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb s\u1ebd gi\u1ed1ng h\u00ecnh v\u1ebd b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_6344\" aria-describedby=\"caption-attachment-6344\" style=\"width: 430px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6344 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid1.png\" alt=\"trich-du-lieu-su-dung-ham-mid-trong-excel\" width=\"430\" height=\"111\" title=\"mid1\"><figcaption id=\"caption-attachment-6344\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">trich-du-lieu-su-dung-ham-mid-trong-excel<\/span><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"5_dieu_can_biet_ve_ham_Excel_MID\"><\/span><span style=\"font-family: georgia, palatino, serif\">5 \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Excel MID<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Khi s\u1eed d\u1ee5ng h\u00e0m MID c\u00e1c b\u1ea1n kh\u00f4ng th\u1ec3 v\u1ed9i v\u00e0ng v\u00e0 c\u1ea7n ph\u1ea3i ghi nh\u1edb m\u1ed9t s\u1ed1 \u0111i\u1ec1u \u0111\u1ec3 tr\u00e1nh vi\u1ec7c m\u1eafc ph\u1ea3i nh\u1eefng l\u1ed7i sai ph\u1ed5 bi\u1ebfn.<\/span><\/p>\n<ol style=\"text-align: justify\">\n<li><span style=\"font-family: georgia, palatino, serif\">H\u00e0m MID lu\u00f4n tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, ngay c\u1ea3 khi chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00f3 ch\u1ec9 ch\u1ee9a to\u00e0n c\u00e1c ch\u1eef s\u1ed1. \u0110i\u1ec1u n\u00e0y r\u1ea5t \u0111\u00e1ng l\u01b0u \u00fd n\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh s\u1eed d\u1ee5ng h\u00e0m MID trong c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c. \u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ea7u ra c\u1ee7a h\u00e0m MID l\u00e0 m\u1ed9t s\u1ed1 th\u00ec c\u1ea7n k\u1ebft h\u1ee3p h\u00e0m MID v\u1edbi h\u00e0m VALUE.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu start_num l\u1edbn h\u01a1n t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a v\u0103n b\u1ea3n g\u1ed1c, c\u00f4ng th\u1ee9c t\u00ednh theo h\u00e0m MID s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng (\u201c\u201d).<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu start_num nh\u1ecf h\u01a1n 1, c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m MID tr\u1ea3 v\u1ec1 s\u1ebd b\u1ecb l\u1ed7i #VALUE.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu num_chars nh\u1ecf h\u01a1n 0 (s\u1ed1 \u00e2m), c\u00f4ng th\u1ee9c MID tr\u1ea3 v\u1ec1 #VALUE! N\u1ebfu num_chars b\u1eb1ng 0 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng (\u00f4 r\u1ed7ng).<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu t\u1ed5ng c\u1ee7a start_num v\u00e0 num_chars v\u01b0\u1ee3t qu\u00e1 t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed1i v\u0103n b\u1ea3n g\u1ed1c, h\u00e0m Excel MID s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb start_num cho \u0111\u1ebfn k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c \u0111\u00f3.<\/span><\/li>\n<\/ol>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_vi_du_su_dung_cong_thuc_tinh_cua_ham_MID\"><\/span><span style=\"font-family: georgia, palatino, serif\"> C\u00e1c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m MID<\/span><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Khi s\u1eed d\u1ee5ng h\u00e0m MID trong Excel b\u1ea1n th\u01b0\u1eddng s\u1ebd ph\u1ea3i k\u1ebft h\u1ee3p n\u00f3 v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c, nh\u01b0 nh\u1eefng v\u00ed d\u1ee5 sau \u0111\u00e2y.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_xuat_ten_va_ho\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch xu\u1ea5t t\u00ean v\u00e0 h\u1ecd<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Ch\u00fang ta c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t h\u1ecd, t\u00ean l\u1ea7n l\u01b0\u1ee3t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m LEFT v\u00e0 h\u00e0m RIGHT<\/a>. Tuy nhi\u00ean, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_MID_de_trich_xuat_ho\"><\/span><span style=\"font-family: georgia, palatino, serif\">S\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u00edch xu\u1ea5t h\u1ecd<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Gi\u1ea3 s\u1eed, h\u1ecd v\u00e0 t\u00ean \u0111\u1ea7y \u0111\u1ee7 n\u1eb1m trong \u00f4 A2, h\u1ecd v\u00e0 t\u00ean \u0111\u01b0\u1ee3c ph\u00e2n c\u00e1ch v\u1edbi nhau b\u1eb1ng d\u1ea5u c\u00e1ch, b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t h\u1ecd b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=MID(A2,1,SEARCH(\u201d \u201c,A2)-1)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Ch\u1ee9c n\u0103ng SEARCH \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 b\u1ecf d\u1ea5u c\u00e1ch v\u00e0 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed c\u1ee7a n\u00f3, v\u00ec th\u1ebf b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua d\u1ea5u c\u00e1ch \u0111\u00f3. Sau \u0111\u00f3, b\u1ea1n d\u00f9ng h\u00e0m MID \u0111\u1ec3 tr\u00edch ra chu\u1ed7i con b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean cho \u0111\u1ebfn k\u00fd t\u1ef1 \u0111\u1ee9ng tr\u01b0\u1edbc d\u1ea5u c\u00e1ch, t\u1eeb \u0111\u00f3 ta thu \u0111\u01b0\u1ee3c h\u1ecd.<\/span><\/p>\n<figure id=\"attachment_6345\" aria-describedby=\"caption-attachment-6345\" style=\"width: 445px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6345 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid2.png\" alt=\"vi-du-ham-mid-trong-excel-1\" width=\"445\" height=\"155\" title=\"mid2\"><figcaption id=\"caption-attachment-6345\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">vi-du-ham-mid-trong-excel-1<\/span><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_MID_de_trich_xuat_ten\"><\/span><span style=\"font-family: georgia, palatino, serif\">S\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u00edch xu\u1ea5t t\u00ean<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 tr\u00edch xu\u1ea5t t\u00ean t\u1eeb \u00f4 A2, c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=TRIM(MID(A2,SEARCH(\u201d \u201c,A2),LEN(A2)))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">L\u1ea7n n\u00e0y, SEARCH \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u (t\u1eeb ch\u1ed7 d\u1ea5u c\u00e1ch). Kh\u00f4ng c\u1ea7n t\u00ednh ch\u00ednh x\u00e1c v\u1ecb tr\u00ed k\u1ebft th\u00fac (v\u00ec n\u1ebfu start_num v\u00e0 num_chars c\u1ed9ng l\u1ea1i l\u1edbn h\u01a1n t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i th\u00ec h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 c\u00f2n l\u1ea1i trong chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c). V\u00ec v\u1eady, trong \u0111\u1ed1i s\u1ed1 num_chars, b\u1ea1n ch\u1ec9 c\u1ea7n cung c\u1ea5p t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i ban \u0111\u1ea7u \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1eb1ng 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 ch\u1ee9c n\u0103ng LEN<\/a>. N\u1ebfu kh\u00f4ng d\u00f9ng h\u00e0m LEN th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t m\u1ed9t s\u1ed1 th\u1eadt d\u00e0i cho chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t, v\u00ed d\u1ee5 nh\u01b0 100. Cu\u1ed1i c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m TRIM <\/a>s\u1ebd lo\u1ea1i b\u1ecf ph\u1ea7n d\u1ea5u c\u00e1ch v\u00e0 cho ra k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_6346\" aria-describedby=\"caption-attachment-6346\" style=\"width: 527px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6346 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid3.png\" alt=\"vi-du-ham-mid-trong-excel-2\" width=\"527\" height=\"156\" title=\"mid3\"><figcaption id=\"caption-attachment-6346\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">vi-du-ham-mid-trong-excel-2<\/span><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_trich_xuat_chuoi_ky_tu_nam_giua_hai_dau_cach\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 v\u00ed d\u1ee5 \u1edf b\u00ean tr\u00ean, n\u1ebfu ngo\u00e0i h\u1ecd v\u00e0 t\u00ean c\u00f2n ch\u1ee9a t\u00ean \u0111\u1ec7m th\u00ec l\u00e0m th\u1ebf n\u00e0o m\u1edbi tr\u00edch xu\u1ea5t \u0111\u01b0\u1ee3c t\u00ean \u0111\u1ec7m \u0111\u00f3?<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo ph\u01b0\u01a1ng ph\u00e1p sau \u0111\u00e2y:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Gi\u1ed1ng nh\u01b0 \u1edf v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u00fang ta v\u1eabn s\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean, c\u1ed9ng th\u00eam 1 v\u00e0o \u0111\u00f3 \u0111\u1ec3 chu\u1ed7i k\u00fd t\u1ef1 tr\u00edch ra b\u1eaft \u0111\u1ea7u b\u1eb1ng k\u00fd t\u1ef1 \u0111\u1ee9ng ngay sau d\u1ea5u c\u00e1ch. T\u1eeb \u0111\u00f3, b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c tham s\u1ed1 start_num t\u1eeb c\u00f4ng th\u1ee9c MID: <strong>SEARCH(\u201d \u201c,A2)+1<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Ti\u1ebfp theo, \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a kho\u1ea3ng c\u00e1ch th\u1ee9 2 th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m SEARCH v\u1edbi vi\u1ec7c b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean sau d\u1ea5u c\u00e1ch th\u1ee9 2: <strong>SEARCH(\u201d \u201c,A2,SEARCH(\u201d \u201c,A2)+1)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c chu\u1ed7i k\u00fd t\u1ef1 tr\u1ea3 v\u1ec1, c\u1ea7n tr\u1eeb \u0111i v\u1ecb tr\u00ed 2 kho\u1ea3ng kh\u00f4ng c\u1ee7a 2 d\u1ea5u c\u00e1ch. T\u1eeb \u0111\u00f3, ch\u00fang ta c\u00f3 \u0111\u1ed1i s\u1ed1 num_chars: <strong>SEARCH (\u201d \u201c, A2, SEARCH (\u201d \u201c,A2)+1) \u2013 SEARCH (\u201d \u201c,A2)<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> K\u1ebft h\u1ee3p l\u1ea1i v\u1edbi nhau ch\u00fang ta c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c MID \u0111\u1ec3 tr\u00edch ra chu\u1ed7i k\u00fd t\u1ef1 \u0111\u1ee9ng gi\u1eefa hai kho\u1ea3ng kh\u00f4ng gian t\u1ea1o b\u1edfi hai d\u1ea5u c\u00e1ch:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=MID(A2, SEARCH(\u201d \u201c,A2)+1, SEARCH (\u201d \u201c, A2, SEARCH (\u201d \u201c,A2)+1) \u2013 SEARCH (\u201d \u201c,A2)-1)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem k\u1ebft qu\u1ea3 trong h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_6347\" aria-describedby=\"caption-attachment-6347\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6347\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid4.png\" alt=\"vi-du-ham-mid-trong-excel-3\" width=\"600\" height=\"177\" title=\"mid4\"><figcaption id=\"caption-attachment-6347\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">vi-du-ham-mid-trong-excel-3<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t chu\u1ed7i con n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch b\u1ea5t k\u1ef3:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>MID(string, SEARCH(delimiter, string)+1, SEARCH (delimiter, string, SEARCH (delimiter, string)+1) \u2013 SEARCH (delimiter, string)-1)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">V\u00ed d\u1ee5, \u0111\u1ec3 tr\u00edch ra m\u1ed9t chu\u1ed7i con \u0111\u01b0\u1ee3c ng\u0103n c\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y v\u00e0 kho\u1ea3ng c\u00e1ch, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=MID(A2,SEARCH(\u201c, \u201c,A2)+1,SEARCH(\u201c, \u201c,A2,SEARCH(\u201c, \u201c,A2)+1)-SEARCH(\u201c, \u201c,A2)-1)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Xem h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u1ec3 th\u1ea5y s\u1ef1 hi\u1ec7u qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n<figure id=\"attachment_6348\" aria-describedby=\"caption-attachment-6348\" style=\"width: 558px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6348 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid5.png\" alt=\"vi-du-ham-mid-trong-excel-4\" width=\"558\" height=\"182\" title=\"mid5\"><figcaption id=\"caption-attachment-6348\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">vi-du-ham-mid-trong-excel-4<\/span><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_trich_xuat_tu_thu_N_trong_mot_chuoi_van_ban\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch tr\u00edch xu\u1ea5t t\u1eeb th\u1ee9 N trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">V\u00ed d\u1ee5 n\u00e0y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh cho vi\u1ec7c k\u1ebft h\u1ee3p s\u00e1ng t\u1ea1o c\u00f4ng th\u1ee9c MID, k\u1ebft h\u1ee3p c\u1ee7a 5 h\u00e0m kh\u00e1c nhau.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> LEN<\/strong> \u2013 \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> REPT<\/strong> \u2013 \u0111\u1ec3 l\u1eb7p l\u1ea1i m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 v\u1edbi s\u1ed1 l\u1ea7n nh\u1ea5t \u0111\u1ecbnh<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> SUBSTITUTE<\/strong> \u2013 thay th\u1ebf m\u1ed9t k\u00fd t\u1ef1 b\u1eb1ng m\u1ed9t k\u00fd t\u1ef1 kh\u00e1c<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> MID<\/strong> \u2013 tr\u00edch xu\u1ea5t m\u1ed9t chu\u1ed7i con<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> TRIM<\/strong> \u2013 lo\u1ea1i b\u1ecf kho\u1ea3ng kh\u00f4ng gian d\u1ea5u c\u00e1ch th\u00eam v\u00e0o<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Ta c\u00f3 c\u00f4ng th\u1ee9c chung nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>TRIM(MID(SUBSTITUTE(string,\u201d \u201c,REPT(\u201d \u201c,LEN(string))), (N-1)*LEN(string)+1, LEN(string)))<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Trong \u0111\u00f3:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2022 <em>String<\/em> l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ban \u0111\u1ea7u ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2022 <em>N<\/em> l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a t\u1eeb c\u1ea7n tr\u00edch xu\u1ea5t<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">V\u00ed d\u1ee5, \u0111\u1ec3 tr\u00edch xu\u1ea5t t\u1eeb th\u1ee9 2 trong chu\u1ed7i v\u0103n b\u1ea3n \u00f4 A2, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=TRIM(MID(SUBSTITUTE(A2,\u201d \u201c,REPT(\u201d \u201c,LEN(A2))), (2-1)*LEN(A2)+1, LEN(A2)))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb c\u1ea7n tr\u00edch xu\u1ea5t (N) trong nhi\u1ec1u \u00f4 trong c\u00f9ng c\u00f4ng th\u1ee9c, nh\u01b0 h\u00ecnh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_6349\" aria-describedby=\"caption-attachment-6349\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6349\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid6.png\" alt=\"trich-xuat-tu-trong-chuoi-van-ban\" width=\"600\" height=\"146\" title=\"mid6\"><figcaption id=\"caption-attachment-6349\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">trich-xuat-tu-trong-chuoi-van-ban<\/span><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hoat_dong_cua_cong_thuc_tren_nhu_sau\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">V\u1ec1 b\u1ea3n ch\u1ea5t, c\u00f4ng th\u1ee9c bao g\u1ed3m nh\u1eefng t\u1eeb \u0111\u01a1n trong v\u0103n b\u1ea3n g\u1ed1c v\u00e0 c\u00e1c t\u1eeb c\u00e1ch nhau b\u1edfi r\u1ea5t nhi\u1ec1u kho\u1ea3ng tr\u1ed1ng (d\u1ea5u c\u00e1ch), \u0111\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c chu\u1ed7i d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n trong c\u1ea3 m\u1ed9t kh\u1ed1i c\u00e1c \u201ckho\u1ea3ng tr\u1ed1ng-t\u1eeb-kho\u1ea3ng tr\u1ed1ng\u201d th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1ed1ng \u0111\u00f3. N\u00f3i c\u1ee5 th\u1ec3 h\u01a1n th\u00ec c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng theo logic d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">\u2022 H\u00e0m SUBSTITUTE v\u00e0 REPT thay th\u1ebf m\u1ed7i kho\u1ea3ng tr\u1ed1ng \u0111\u01a1n l\u1ebb trong m\u1ed9t chu\u1ed7i b\u1eb1ng nhi\u1ec1u kho\u1ea3ng tr\u1ed1ng. S\u1ed1 l\u01b0\u1ee3ng kho\u1ea3ng tr\u1ed1ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1eb1ng t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edbi h\u00e0m LEN: SUBSTITUTE(A2,\u201d \u201c,REPT(\u201d \u201c,LEN(A2)))<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">B\u1ea1n c\u00f3 th\u1ec3 coi k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch ra t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c c\u0169ng gi\u1ed1ng nh\u01b0 m\u1ed9t \u201ch\u00e0nh tinh nh\u1ecf\u201d tr\u00f4i d\u1ea1t trong m\u1ed9t kh\u00f4ng gian r\u1ed9ng l\u1edbn g\u1ed3m: kho\u1ea3ng tr\u1ed1ng-t\u1eeb th\u1ee9 nh\u1ea5t-kho\u1ea3ng tr\u1ed1ng-t\u1eeb th\u1ee9 hai-kho\u1ea3ng tr\u1ed1ng-t\u1eeb th\u1ee9 ba-\u2026. T\u1eeb chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0 v\u1eady ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00f4ng th\u1ee9c MID.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">\u2022 Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n t\u00ednh ra v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a chu\u1ed7i con m\u00e0 b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t (\u0111\u1ed1i s\u1ed1 start_num) s\u1eed d\u1ee5ng ph\u01b0\u01a1ng tr\u00ecnh sau: (N-1) * LEN (A1) +1. Ph\u00e9p t\u00ednh n\u00e0y tr\u1ea3 v\u1ec1 v\u00ed tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i con c\u1ea7n tr\u00edch xu\u1ea5t ho\u1eb7c v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t s\u1ed1 kho\u1ea3ng tr\u1ed1ng trong t\u1ed5ng s\u1ed1 nh\u1eefng kho\u1ea3ng tr\u1ed1ng tr\u01b0\u1edbc \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">\u2022 S\u1ed1 k\u00fd t\u1ef1 tr\u00edch xu\u1ea5t (\u0111\u1ed1i s\u1ed1 num_chars) l\u00e0 ph\u1ea7n \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u00ec ch\u00fang ta c\u00f3 th\u1ec3 t\u00ecm ra b\u1eb1ng c\u00e1ch l\u1ea5y t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c: LEN(A2). Qua \u0111\u00f3, b\u1ea1n s\u1ebd lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c nh\u1eefng kho\u1ea3ng tr\u1ed1ng trong chu\u1ed7i d\u00e0i g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1ed1ng v\u00e0 t\u1eeb.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">\u2022 Cu\u1ed1i c\u00f9ng, h\u00e0m TRIM s\u1ebd lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1ed1ng n\u1eb1m \u1edf \u0111\u1ea7u v\u00e0 cu\u1ed1i.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> C\u00f4ng th\u1ee9c tr\u00ean ho\u1ea1t \u0111\u1ed9ng t\u1ed1t trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u01b0ng n\u1ebfu c\u00f3 t\u1eeb 2 kho\u1ea3ng tr\u1ed1ng s\u00e1t nhau gi\u1eefa c\u00e1c t\u1eeb th\u00ec k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd b\u1ecb sau. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i sai n\u00e0y th\u00ec n\u00ean l\u1ed3ng gh\u00e9p h\u00e0m TRIM v\u00e0o h\u00e0m SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1ed1ng n\u1eb1m gi\u1eefa nh\u1eefng kho\u1ea3ng tr\u1ed1ng kh\u00e1c, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=TRIM(MID(SUBSTITUTE(TRIM(A2),\u201d \u201c,REPT(\u201d \u201c,LEN(A2))), (B2-1)*LEN(A2)+1, LEN(A2)))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">C\u00e1c b\u1ea1n theo d\u00f5i h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_6350\" aria-describedby=\"caption-attachment-6350\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6350\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid8.png\" alt=\"vi-du-ham-mid-trong-excel-5\" width=\"600\" height=\"140\" title=\"mid8\"><figcaption id=\"caption-attachment-6350\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">vi-du-ham-mid-trong-excel-5<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c ch\u1ee9a nhi\u1ec1u kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb v\u00e0 c\u00e1c t\u1eeb trong \u0111\u00f3 qu\u00e1 l\u1edbn ho\u1eb7c qu\u00e1 nh\u1ecf th\u00ec b\u1ea1n n\u00ean th\u00eam h\u00e0m TRIM l\u1ed3ng trong m\u1ed7i h\u00e0m LEN \u0111\u1ec3 tr\u00e1nh x\u1ea3y ra l\u1ed7i:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=TRIM(MID(SUBSTITUTE(TRIM(A2),\u201d \u201c,REPT(\u201d \u201c,LEN(TRIM(A2)))), (B2-1)*LEN(TRIM(A2))+1, LEN(TRIM(A2))))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 v\u1ebb kh\u00e1 ph\u1ee9c t\u1ea1p nh\u01b0ng l\u1ea1i \u0111\u1ea3m b\u1ea3o kh\u00f4ng x\u1ea3y ra l\u1ed7i.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_trich_xuat_mot_tu_chua_mot_hoac_nhieu_ky_tu_cu_the\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch tr\u00edch xu\u1ea5t m\u1ed9t t\u1eeb ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 c\u1ee5 th\u1ec3<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">V\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y s\u1ef1 h\u1eefu \u00edch c\u1ee7a c\u00f4ng th\u1ee9c MID trong Excel \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t t\u1eeb ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 t\u1eeb v\u0103n b\u1ea3n g\u1ed1c:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>TRIM(MID(SUBSTITUTE(string,\u201d \u201c,REPT(\u201d \u201c,99)),MAX(1,FIND(char,SUBSTITUTE(string,\u201d \u201c,REPT(\u201d \u201c,99)))-50),99))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Gi\u1ea3 s\u1eed v\u0103n b\u1ea3n g\u1ed1c n\u1eb1m \u1edf \u00f4 A2, b\u1ea1n c\u1ea7n t\u00ecm ki\u1ebfm chu\u1ed7i con ch\u1ee9a k\u00ed t\u1ef1 \u201c$\u201d (gi\u00e1 c\u1ea3) b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=TRIM(MID(SUBSTITUTE(A2,\u201d \u201c,REPT(\u201d \u201c,99)),MAX(1,FIND(\u201c$\u201d,SUBSTITUTE(A2,\u201d \u201c,REPT(\u201d \u201c,99)))-50),99))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t \u0111\u1ecba ch\u1ec9 email (d\u1ef1a tr\u00ean k\u00ed t\u1ef1 @) hay t\u00ean trang web (d\u1ef1a tr\u00ean \u201cwww\u201d), \u2026.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hoat_dong_cua_cong_thuc_tren_nhu_sau-2\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Gi\u1ed1ng nh\u01b0 trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, c\u00e1c <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> v\u00e0<a href=\"http:\/\/blog.ezworkapp.com\/ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"> h\u00e0m REPT<\/a> bi\u1ebfn m\u1ecdi kho\u1ea3ng tr\u1ed1ng trong chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c th\u00e0nh nhi\u1ec1u kho\u1ea3ng tr\u1ed1ng, ch\u00ednh x\u00e1c h\u01a1n l\u00e0 99 kho\u1ea3ng tr\u1eafng.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">H\u00e0m FIND x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 mong mu\u1ed1n (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 $), ti\u1ebfp \u0111\u00f3 b\u1ea1n tr\u1eeb \u0111i 50. L\u00e0m nh\u01b0 v\u1eady b\u1ea1n s\u1ebd nh\u1eadn l\u1ea1i \u0111\u01b0\u1ee3c 50 k\u00fd t\u1ef1 v\u00e0 \u0111\u1eb7t \u1edf gi\u1eefa kh\u1ed1i 99 kho\u1ea3ng tr\u1ed1ng \u0111\u1ee9ng tr\u01b0\u1edbc chu\u1ed7i con ch\u1ee9a k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">H\u00e0m MAX \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd t\u00ecnh hu\u1ed1ng khi chu\u1ed7i con mong mu\u1ed1n xu\u1ea5t hi\u1ec7n \u1edf \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n ban \u0111\u1ea7u. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, k\u1ebft qu\u1ea3 c\u1ee7a FIND () \u2013 50 s\u1ebd l\u00e0 s\u1ed1 \u00e2m, v\u00e0 MAX (1, FIND () \u2013 50) s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng 1.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Qua \u0111\u00f3, h\u00e0m MID s\u1ebd thu th\u1eadp 99 k\u00fd t\u1ef1 ti\u1ebfp theo v\u00e0 tr\u1ea3 v\u1ec1 chu\u1ed7i con b\u1ea1n c\u1ea7n. H\u00e0m TRIM gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf h\u1ebft nh\u1eefng kho\u1ea3ng tr\u1ed1ng \u1edf xung quanh chu\u1ed7i con b\u1ea1n c\u1ea7n \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>M\u1eb9o:<\/strong> N\u1ebfu chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c qu\u00e1 l\u1edbn, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf 99 v\u00e0 50 th\u00e0nh con s\u1ed1 l\u1edbn h\u01a1n, v\u00ed d\u1ee5 nh\u01b0 1000 v\u00e0 500.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_khien_ham_MID_tra_ve_mot_so\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch khi\u1ebfn h\u00e0m MID tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Gi\u1ed1ng nh\u01b0 nh\u1eefng h\u00e0m v\u0103n b\u1ea3n kh\u00e1c, Excel MID lu\u00f4n tr\u1ea3 v\u1ec1 chu\u1ed7i v\u0103n b\u1ea3n, ngay c\u1ea3 khi n\u00f3 ch\u1ee9a c\u00e1c ch\u1eef s\u1ed1 tr\u00f4ng gi\u1ed1ng nh\u01b0 m\u1ed9t con s\u1ed1. \u0110\u1ec3 chuy\u1ec3n \u0111\u1ea7u ra th\u00e0nh m\u1ed9t s\u1ed1, ch\u00fang ta ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i h\u00e0m MID m\u1ed9t ch\u00fat, s\u1eed d\u1ee5ng VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n \u0111\u1ea1i di\u1ec7n cho m\u1ed9t s\u1ed1.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00ed d\u1ee5, \u0111\u1ec3 tr\u00edch xu\u1ea5t 3 k\u00fd t\u1ef1, b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 7 v\u00e0 chuy\u1ec3n chu\u1ed7i v\u0103n b\u1ea3n k\u1ebft qu\u1ea3 th\u00e0nh d\u1ea1ng s\u1ed1 th\u00ec ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=VALUE(MID(A2,7,3))<\/strong><\/span><\/p>\n<figure id=\"attachment_6351\" aria-describedby=\"caption-attachment-6351\" style=\"width: 457px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6351 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid9.png\" alt=\"ket-hop-ham-mid-va-value\" width=\"457\" height=\"163\" title=\"mid9\"><figcaption id=\"caption-attachment-6351\" class=\"wp-caption-text\"><span style=\"font-family: georgia, palatino, serif\">ket-hop-ham-mid-va-value<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">V\u1edbi c\u00e1ch ti\u1ebfp c\u1eadn t\u01b0\u01a1ng t\u1ef1 \u00e1p d\u1ee5ng cho nh\u1eefng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n. Nh\u01b0 trong v\u00ed d\u1ee5 tr\u00ean, gi\u1ea3 s\u1eed c\u00e1c m\u00e3 l\u1ed7i (Erro) c\u00f3 \u0111\u1ed9 d\u00e0i kh\u00e1c nhau th\u00ec b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t ch\u00fang b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MID \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c chu\u1ed7i k\u00fd t\u1ef1 con n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch, l\u1ed3ng b\u00ean trong h\u00e0m VALUE:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><strong>=VALUE(MID(A2,SEARCH(\u201c:\u201d,A2)+1,SEARCH(\u201c:\u201d,A2,SEARCH(\u201c:\u201d,A2)+1)-SEARCH(\u201c:\u201d,A2)-1))<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mid10.png\" width=\"614\" height=\"162\" title=\"mid10\"><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft.<\/span><\/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\/2025\/01\/ex101_92019-nho-294.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11418,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11417","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\/11417","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=11417"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11417\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11418"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}