{"id":477857,"date":"2025-07-30T08:51:09","date_gmt":"2025-07-30T01:51:09","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=477857"},"modified":"2025-07-30T08:51:09","modified_gmt":"2025-07-30T01:51:09","slug":"ham-mid-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/","title":{"rendered":"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft"},"content":{"rendered":"<p data-start=\"193\" data-end=\"673\">Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean Excel, vi\u1ec7c tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n th\u00f4ng tin t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n l\u00e0 nhu c\u1ea7u r\u1ea5t ph\u1ed5 bi\u1ebfn. Excel cung c\u1ea5p nhi\u1ec1u h\u00e0m h\u1ed7 tr\u1ee3 l\u00e0m vi\u1ec7c v\u1edbi chu\u1ed7i, trong \u0111\u00f3 <strong data-start=\"373\" data-end=\"384\">h\u00e0m MID<\/strong> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n l\u1ea5y m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n n\u1eb1m gi\u1eefa chu\u1ed7i m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c. D\u00f9 b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi hay \u0111\u00e3 c\u00f3 kinh nghi\u1ec7m s\u1eed d\u1ee5ng Excel, vi\u1ec7c hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p, c\u00e1ch ho\u1ea1t \u0111\u1ed9ng v\u00e0 c\u00e1c t\u00ecnh hu\u1ed1ng \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a h\u00e0m MID s\u1ebd gi\u00fap t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c \u0111\u00e1ng k\u1ec3.<\/p>\n<h2 data-start=\"245\" data-end=\"283\">H\u00e0m MID trong Excel d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/h2>\n<p data-start=\"41\" data-end=\"222\">H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t chu\u1ed7i con (m\u1ed9t ph\u1ea7n v\u0103n b\u1ea3n) t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c, b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed ch\u1ec9 \u0111\u1ecbnh v\u00e0 c\u00f3 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ee5 th\u1ec3. C\u00f4ng d\u1ee5ng ch\u00ednh c\u1ee7a h\u00e0m MID l\u00e0 h\u1ed7 tr\u1ee3 x\u1eed l\u00fd chu\u1ed7i, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u1ea5y ra m\u1ed9t ph\u1ea7n th\u00f4ng tin n\u1eb1m gi\u1eefa trong m\u1ed9t chu\u1ed7i l\u1edbn. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n:<\/p>\n<ul data-start=\"408\" data-end=\"659\">\n<li data-start=\"408\" data-end=\"485\">\n<p data-start=\"410\" data-end=\"485\">L\u1ea5y <strong data-start=\"414\" data-end=\"423\">m\u00e3 s\u1ed1<\/strong> ho\u1eb7c k\u00fd t\u1ef1 n\u1eb1m \u1edf gi\u1eefa chu\u1ed7i (v\u00ed d\u1ee5: m\u00e3 s\u1ea3n ph\u1ea9m, s\u1ed1 h\u00f3a \u0111\u01a1n\u2026)<\/p>\n<\/li>\n<li data-start=\"486\" data-end=\"540\">\n<p data-start=\"488\" data-end=\"540\">T\u00e1ch <strong data-start=\"493\" data-end=\"513\">h\u1ecd, t\u00ean \u0111\u1ec7m, t\u00ean<\/strong> t\u1eeb m\u1ed9t chu\u1ed7i h\u1ecd t\u00ean \u0111\u1ea7y \u0111\u1ee7<\/p>\n<\/li>\n<li data-start=\"541\" data-end=\"594\">\n<p data-start=\"543\" data-end=\"594\">L\u1ea5y m\u1ed9t ph\u1ea7n d\u1eef li\u1ec7u t\u1eeb <strong data-start=\"567\" data-end=\"594\">chu\u1ed7i k\u1ebft h\u1ee3p s\u1ed1 v\u00e0 ch\u1eef<\/strong><\/p>\n<\/li>\n<li data-start=\"595\" data-end=\"659\">\n<p data-start=\"597\" data-end=\"659\">T\u00e1ch <strong data-start=\"602\" data-end=\"622\">ng\u00e0y, th\u00e1ng, n\u0103m<\/strong> t\u1eeb m\u1ed9t chu\u1ed7i ng\u00e0y \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\" data-start=\"661\" data-end=\"780\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-478436 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-1.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"661\" data-end=\"780\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 chu\u1ed7i &#8220;HD202407&#8221; v\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n l\u1ea5y ra &#8220;2024&#8221;, h\u00e0m MID s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. T\u00f3m l\u1ea1i, h\u00e0m MID r\u1ea5t c\u1ea7n thi\u1ebft khi b\u1ea1n c\u1ea7n thao t\u00e1c v\u1edbi v\u0103n b\u1ea3n trong Excel \u0111\u1ec3 l\u1ecdc th\u00f4ng tin ch\u00ednh x\u00e1c theo v\u1ecb tr\u00ed.<\/p>\n<h2 data-start=\"719\" data-end=\"743\">Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m MID<\/h2>\n<p data-start=\"39\" data-end=\"175\">H\u00e0m MID c\u00f3 ch\u1ee9c n\u0103ng ch\u00ednh l\u00e0 tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n chu\u1ed7i v\u0103n b\u1ea3n, b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh v\u00e0 c\u00f3 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ee5 th\u1ec3. C\u1ee5 th\u1ec3, ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m MID bao g\u1ed3m:<\/p>\n<ul data-start=\"217\" data-end=\"844\">\n<li data-start=\"217\" data-end=\"359\">\n<p data-start=\"219\" data-end=\"359\"><strong data-start=\"219\" data-end=\"244\">C\u1eaft chu\u1ed7i theo v\u1ecb tr\u00ed<\/strong>: Gi\u00fap b\u1ea1n l\u1ea5y ra m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n n\u1eb1m gi\u1eefa chu\u1ed7i g\u1ed1c, thay v\u00ec ph\u1ea3i t\u00e1ch t\u1eeb \u0111\u1ea7u (nh\u01b0 LEFT) hay t\u1eeb cu\u1ed1i (nh\u01b0 RIGHT).<\/p>\n<\/li>\n<li data-start=\"360\" data-end=\"475\">\n<p data-start=\"362\" data-end=\"475\"><strong data-start=\"362\" data-end=\"392\">Tr\u00edch l\u1ecdc d\u1eef li\u1ec7u chi ti\u1ebft<\/strong>: V\u00ed d\u1ee5 nh\u01b0 l\u1ea5y m\u00e3 s\u1ed1 t\u1eeb chu\u1ed7i &#8220;SP_00123&#8221;, hay l\u1ea5y t\u00ean \u0111\u1ec7m t\u1eeb chu\u1ed7i &#8220;Nguy\u1ec5n V\u0103n A&#8221;.<\/p>\n<\/li>\n<li data-start=\"476\" data-end=\"660\">\n<p data-start=\"478\" data-end=\"660\"><strong data-start=\"478\" data-end=\"526\">K\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd chu\u1ed7i \u0111\u1ed9ng<\/strong>: MID th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m nh\u01b0 <code data-start=\"573\" data-end=\"579\">FIND<\/code>, <code data-start=\"581\" data-end=\"589\">SEARCH<\/code>, <code data-start=\"591\" data-end=\"596\">LEN<\/code>,&#8230; \u0111\u1ec3 linh ho\u1ea1t h\u01a1n khi x\u1eed l\u00fd d\u1eef li\u1ec7u c\u00f3 \u0111\u1ed9 d\u00e0i kh\u00f4ng c\u1ed1 \u0111\u1ecbnh.<\/p>\n<\/li>\n<li data-start=\"661\" data-end=\"844\">\n<p data-start=\"663\" data-end=\"844\"><strong data-start=\"663\" data-end=\"703\">\u1ee8ng d\u1ee5ng trong l\u1ecdc th\u00f4ng tin t\u1ef1 \u0111\u1ed9ng<\/strong>: R\u1ea5t hi\u1ec7u qu\u1ea3 khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn ch\u1ee9a chu\u1ed7i th\u00f4ng tin nh\u01b0 m\u00e3 s\u1ea3n ph\u1ea9m, s\u1ed1 h\u1ee3p \u0111\u1ed3ng, chu\u1ed7i ng\u00e0y th\u00e1ng, th\u00f4ng tin \u0111\u1ecbnh danh,&#8230;<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-478437 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-2.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"846\" data-end=\"874\"><em><strong data-start=\"846\" data-end=\"874\">V\u00ed d\u1ee5 ch\u1ee9c n\u0103ng th\u1ef1c t\u1ebf:<\/strong><\/em><\/p>\n<div class=\"_tableContainer_80l1q_1\">\n<div class=\"_tableWrapper_80l1q_14 group flex w-fit flex-col-reverse\">\n<table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"876\" data-end=\"1379\">\n<thead data-start=\"876\" data-end=\"975\">\n<tr data-start=\"876\" data-end=\"975\">\n<th data-start=\"876\" data-end=\"895\" data-col-size=\"sm\">Chu\u1ed7i g\u1ed1c<\/th>\n<th data-start=\"895\" data-end=\"927\" data-col-size=\"sm\">H\u00e0m MID s\u1eed d\u1ee5ng<\/th>\n<th data-start=\"927\" data-end=\"940\" data-col-size=\"sm\">K\u1ebft qu\u1ea3<\/th>\n<th data-start=\"940\" data-end=\"975\" data-col-size=\"sm\">Ch\u1ee9c n\u0103ng th\u1ef1c hi\u1ec7n<\/th>\n<\/tr>\n<\/thead>\n<tbody data-start=\"1077\" data-end=\"1379\">\n<tr data-start=\"1077\" data-end=\"1177\">\n<td data-start=\"1077\" data-end=\"1096\" data-col-size=\"sm\">&#8220;SP_202407&#8221;<\/td>\n<td data-start=\"1096\" data-end=\"1128\" data-col-size=\"sm\"><code data-start=\"1098\" data-end=\"1112\">=MID(A1,4,4)<\/code><\/td>\n<td data-start=\"1128\" data-end=\"1141\" data-col-size=\"sm\">2024<\/td>\n<td data-start=\"1141\" data-end=\"1177\" data-col-size=\"sm\">Tr\u00edch n\u0103m t\u1eeb chu\u1ed7i m\u00e3<\/td>\n<\/tr>\n<tr data-start=\"1178\" data-end=\"1278\">\n<td data-start=\"1178\" data-end=\"1197\" data-col-size=\"sm\">&#8220;Nguy\u1ec5n V\u0103n An&#8221;<\/td>\n<td data-start=\"1197\" data-end=\"1229\" data-col-size=\"sm\"><code data-start=\"1199\" data-end=\"1213\">=MID(A1,8,3)<\/code><\/td>\n<td data-start=\"1229\" data-end=\"1242\" data-col-size=\"sm\">V\u0103n<\/td>\n<td data-start=\"1242\" data-end=\"1278\" data-col-size=\"sm\">L\u1ea5y t\u00ean \u0111\u1ec7m<\/td>\n<\/tr>\n<tr data-start=\"1279\" data-end=\"1379\">\n<td data-start=\"1279\" data-end=\"1298\" data-col-size=\"sm\">&#8220;ABC123XYZ&#8221;<\/td>\n<td data-start=\"1298\" data-end=\"1330\" data-col-size=\"sm\"><code data-start=\"1300\" data-end=\"1314\">=MID(A1,4,3)<\/code><\/td>\n<td data-start=\"1330\" data-end=\"1343\" data-col-size=\"sm\">123<\/td>\n<td data-start=\"1343\" data-end=\"1379\" data-col-size=\"sm\">L\u1ea5y ph\u1ea7n s\u1ed1 n\u1eb1m gi\u1eefa<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h2 data-start=\"1052\" data-end=\"1092\">C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m MID trong Excel<\/h2>\n<p data-start=\"1094\" data-end=\"1116\">C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m: <strong>=MID(text, start_num, num_chars)<\/strong><\/p>\n<p data-start=\"1160\" data-end=\"1172\"><strong data-start=\"1160\" data-end=\"1172\">Tham s\u1ed1:\u00a0<\/strong><\/p>\n<ul>\n<li data-start=\"1160\" data-end=\"1172\">text: Chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t. C\u00f3 th\u1ec3 l\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i ho\u1eb7c chu\u1ed7i \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/li>\n<li data-start=\"1160\" data-end=\"1172\">start_num: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u tr\u00edch xu\u1ea5t (t\u00ednh t\u1eeb 1).<\/li>\n<li data-start=\"1160\" data-end=\"1172\">num_chars: S\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n l\u1ea5y k\u1ec3 t\u1eeb v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-478438 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-3.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"1160\" data-end=\"1172\"><strong data-start=\"1396\" data-end=\"1406\">L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu start_num &gt; \u0111\u1ed9 d\u00e0i chu\u1ed7i \u2192 k\u1ebft qu\u1ea3 l\u00e0 chu\u1ed7i r\u1ed7ng &#8220;&#8221;.<\/li>\n<li>N\u1ebfu num_chars &gt; ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a chu\u1ed7i \u2192 h\u00e0m ch\u1ec9 tr\u1ea3 v\u1ec1 \u0111\u1ebfn h\u1ebft chu\u1ed7i.<\/li>\n<\/ul>\n<p data-start=\"1160\" data-end=\"1172\"><code data-start=\"1176\" data-end=\"1182\"><\/code><\/p>\n<h2 data-start=\"1552\" data-end=\"1602\">V\u00ed d\u1ee5 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel<\/h2>\n<p data-start=\"1604\" data-end=\"1692\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 5 v\u00ed d\u1ee5 th\u1ef1c t\u1ebf minh h\u1ecda c\u00e1ch d\u00f9ng h\u00e0m MID trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau.<\/p>\n<h3 data-start=\"1694\" data-end=\"1741\">V\u00ed d\u1ee5 1: Tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 t\u1eeb chu\u1ed7i \u0111\u01a1n gi\u1ea3n<\/h3>\n<p data-start=\"1743\" data-end=\"1776\"><strong data-start=\"1743\" data-end=\"1755\">D\u1eef li\u1ec7u:<\/strong> \u00d4 A1 ch\u1ee9a &#8220;ABCD1234&#8221;<\/p>\n<p data-start=\"1778\" data-end=\"1792\"><strong data-start=\"1778\" data-end=\"1792\">C\u00f4ng th\u1ee9c: =MID(A1,5,4)<\/strong><\/p>\n<p data-start=\"1821\" data-end=\"1840\"><strong data-start=\"1821\" data-end=\"1833\">K\u1ebft qu\u1ea3:<\/strong> 1234<\/p>\n<p style=\"text-align: center;\" data-start=\"1821\" data-end=\"1840\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478441 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-6.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"1842\" data-end=\"1917\"><strong data-start=\"1842\" data-end=\"1857\">Gi\u1ea3i th\u00edch:<\/strong><br \/>\nTrong chu\u1ed7i &#8220;ABCD1234&#8221;, k\u00fd t\u1ef1 th\u1ee9 5 ch\u00ednh l\u00e0 &#8220;1&#8221;. H\u00e0m MID s\u1ebd l\u1ea5y 4 k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed n\u00e0y, l\u1ea7n l\u01b0\u1ee3t l\u00e0 &#8220;1&#8221;, &#8220;2&#8221;, &#8220;3&#8221;, v\u00e0 &#8220;4&#8221;, n\u00ean k\u1ebft qu\u1ea3 l\u00e0 &#8220;1234&#8221;. \u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t th\u1ec3 hi\u1ec7n ch\u1ee9c n\u0103ng c\u1eaft chu\u1ed7i theo v\u1ecb tr\u00ed v\u00e0 \u0111\u1ed9 d\u00e0i c\u1ed1 \u0111\u1ecbnh.<\/p>\n<h3 data-start=\"1924\" data-end=\"1966\">V\u00ed d\u1ee5 2: T\u00e1ch ng\u00e0y t\u1eeb chu\u1ed7i ng\u00e0y th\u00e1ng<\/h3>\n<p data-start=\"1968\" data-end=\"2009\"><strong data-start=\"1968\" data-end=\"1980\">D\u1eef li\u1ec7u:<\/strong> \u00d4 A1 ch\u1ee9a chu\u1ed7i &#8220;28\/07\/2025&#8221;<\/p>\n<p data-start=\"2011\" data-end=\"2025\"><strong data-start=\"2011\" data-end=\"2025\">C\u00f4ng th\u1ee9c: =MID(A1, 1, 2)<br \/>\n<\/strong><\/p>\n<p data-start=\"2054\" data-end=\"2071\"><strong data-start=\"2054\" data-end=\"2066\">K\u1ebft qu\u1ea3:<\/strong> 28<\/p>\n<p style=\"text-align: center;\" data-start=\"2054\" data-end=\"2071\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478442 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-7.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"2073\" data-end=\"2161\"><strong data-start=\"2073\" data-end=\"2088\">Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<p>Chu\u1ed7i &#8220;28\/07\/2025&#8221; c\u00f3 k\u00fd t\u1ef1 th\u1ee9 1 l\u00e0 &#8220;2&#8221; (ph\u1ea7n \u0111\u1ea7u c\u1ee7a ng\u00e0y). Khi l\u1ea5y 2 k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed n\u00e0y, ta \u0111\u01b0\u1ee3c &#8220;28&#8221; \u2013 ch\u00ednh l\u00e0 ng\u00e0y trong \u0111\u1ecbnh d\u1ea1ng ng\u00e0y DD-MM-YYYY. L\u01b0u \u00fd: chu\u1ed7i n\u00e0y l\u00e0 d\u1ea1ng text, kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb ng\u00e0y th\u1ef1c t\u1ebf c\u1ee7a Excel.<\/p>\n<h3 data-start=\"2168\" data-end=\"2215\">V\u00ed d\u1ee5 3: L\u1ea5y m\u00e3 s\u1ed1 trong chu\u1ed7i m\u00e3 nh\u00e2n vi\u00ean<\/h3>\n<p data-start=\"2217\" data-end=\"2268\"><strong data-start=\"2217\" data-end=\"2229\">D\u1eef li\u1ec7u:<\/strong> C\u1ed9t A ch\u1ee9a m\u00e3 nh\u00e2n vi\u00ean nh\u01b0 &#8220;NV_00123&#8221;<\/p>\n<p data-start=\"2270\" data-end=\"2284\"><strong data-start=\"2270\" data-end=\"2284\">C\u00f4ng th\u1ee9c: =MID(A1,4,5)<\/strong><\/p>\n<p data-start=\"2313\" data-end=\"2333\"><strong data-start=\"2313\" data-end=\"2325\">K\u1ebft qu\u1ea3:<\/strong> 00123<\/p>\n<p style=\"text-align: center;\" data-start=\"2313\" data-end=\"2333\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478443 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-8.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"2335\" data-end=\"2389\"><strong data-start=\"2335\" data-end=\"2350\">Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<p>M\u1ed7i m\u00e3 nh\u00e2n vi\u00ean c\u00f3 c\u1ea5u tr\u00fac &#8220;NV_&#8221; + m\u00e3 s\u1ed1. K\u00fd t\u1ef1 th\u1ee9 4 l\u00e0 &#8220;0&#8221;, b\u1eaft \u0111\u1ea7u chu\u1ed7i m\u00e3 s\u1ed1 5 k\u00fd t\u1ef1. MID s\u1ebd c\u1eaft t\u1eeb v\u1ecb tr\u00ed 4 v\u00e0 l\u1ea5y 5 k\u00fd t\u1ef1 li\u00ean ti\u1ebfp, k\u1ebft qu\u1ea3 l\u00e0 &#8220;00123&#8221;. \u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf: t\u00e1ch m\u00e3 nh\u00e2n vi\u00ean \u0111\u1ec3 so s\u00e1nh, l\u1ecdc d\u1eef li\u1ec7u, th\u1ed1ng k\u00ea,\u2026<\/p>\n<h3 data-start=\"2396\" data-end=\"2454\">V\u00ed d\u1ee5 4: K\u1ebft h\u1ee3p v\u1edbi h\u00e0m FIND \u0111\u1ec3 l\u1ea5y t\u00ean gi\u1eefa d\u1ea5u c\u00e1ch<\/h3>\n<p data-start=\"2456\" data-end=\"2493\"><strong data-start=\"2456\" data-end=\"2468\">D\u1eef li\u1ec7u:<\/strong> \u00d4 A1 ch\u1ee9a &#8220;Nguy\u1ec5n V\u0103n A&#8221;<\/p>\n<p data-start=\"2495\" data-end=\"2509\"><strong data-start=\"2495\" data-end=\"2509\">C\u00f4ng th\u1ee9c: =MID(A1,FIND(&#8221; &#8220;,A1)+1,FIND(&#8221; &#8220;,A1,FIND(&#8221; &#8220;,A1)+1)-FIND(&#8221; &#8220;,A1)-1)<\/strong><\/p>\n<p data-start=\"2592\" data-end=\"2610\"><strong data-start=\"2592\" data-end=\"2604\">K\u1ebft qu\u1ea3:<\/strong> V\u0103n<\/p>\n<p style=\"text-align: center;\" data-start=\"2592\" data-end=\"2610\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478444 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-9.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-start=\"2612\" data-end=\"2680\"><strong data-start=\"2612\" data-end=\"2627\">Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<ul>\n<li>FIND(&#8221; &#8220;,A1) t\u00ecm v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean (sau &#8220;Nguy\u1ec5n&#8221;).<\/li>\n<li>FIND(&#8221; &#8220;,A1,FIND(&#8221; &#8220;,A1)+1) t\u00ecm d\u1ea5u c\u00e1ch th\u1ee9 hai (sau &#8220;V\u0103n&#8221;).<\/li>\n<li>MID b\u1eaft \u0111\u1ea7u t\u1eeb sau d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean, v\u00e0 c\u1eaft \u0111\u1ebfn tr\u01b0\u1edbc d\u1ea5u c\u00e1ch th\u1ee9 hai \u2192 ra &#8220;V\u0103n&#8221;.<\/li>\n<\/ul>\n<p>H\u00e0m n\u00e0y k\u1ebft h\u1ee3p MID v\u1edbi FIND \u0111\u1ec3 l\u1ea5y ph\u1ea7n gi\u1eefa 2 kho\u1ea3ng tr\u1eafng \u2013 th\u01b0\u1eddng l\u00e0 t\u00ean \u0111\u1ec7m. C\u00e1ch l\u00e0m r\u1ea5t h\u1eefu \u00edch khi ph\u00e2n t\u00edch h\u1ecd t\u00ean trong d\u1eef li\u1ec7u nh\u00e2n s\u1ef1.<\/p>\n<h3 data-start=\"2687\" data-end=\"2733\">V\u00ed d\u1ee5 5: Tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n s\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/h3>\n<p data-start=\"2735\" data-end=\"2770\"><strong data-start=\"2735\" data-end=\"2747\">D\u1eef li\u1ec7u:<\/strong> A1 ch\u1ee9a &#8220;0901.234.567&#8221;<\/p>\n<p data-start=\"2772\" data-end=\"2786\"><strong data-start=\"2772\" data-end=\"2786\">C\u00f4ng th\u1ee9c: =MID(A1,6,3)<\/strong><\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary select-none rounded-t-2xl\"><strong data-start=\"2815\" data-end=\"2827\">K\u1ebft qu\u1ea3:<\/strong> 234<\/div>\n<div style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478445 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-10.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/div>\n<\/div>\n<p data-start=\"2835\" data-end=\"2916\"><strong data-start=\"2835\" data-end=\"2850\">Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<p>Chu\u1ed7i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u00f3 d\u1ea5u &#8220;.&#8221; ph\u00e2n c\u00e1ch. K\u00fd t\u1ef1 th\u1ee9 6 b\u1eaft \u0111\u1ea7u t\u1eeb &#8220;2&#8221; v\u00e0 MID l\u1ea5y ti\u1ebfp 3 k\u00fd t\u1ef1: &#8220;234&#8221;. \u0110\u00e2y l\u00e0 ph\u1ea7n gi\u1eefa s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh nh\u00e0 m\u1ea1ng, v\u00f9ng ho\u1eb7c nh\u00f3m kh\u00e1ch h\u00e0ng.<\/p>\n<h2 data-start=\"2923\" data-end=\"2951\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m MID<\/h2>\n<p data-start=\"31\" data-end=\"140\">Khi s\u1eed d\u1ee5ng <strong data-start=\"43\" data-end=\"54\">h\u00e0m MID<\/strong> trong Excel, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh l\u1ed7i, b\u1ea1n c\u1ea7n l\u01b0u \u00fd nh\u1eefng \u0111i\u1ec3m sau:<\/p>\n<ul data-start=\"142\" data-end=\"1751\">\n<li data-start=\"142\" data-end=\"462\">\n<p data-start=\"145\" data-end=\"462\"><strong data-start=\"145\" data-end=\"178\">Ch\u1ec9 \u00e1p d\u1ee5ng cho chu\u1ed7i v\u0103n b\u1ea3n<\/strong>: H\u00e0m MID ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng t\u1ed1t v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng <strong data-start=\"228\" data-end=\"236\">text<\/strong>. N\u1ebfu b\u1ea1n \u0111ang x\u1eed l\u00fd d\u1eef li\u1ec7u ki\u1ec3u <strong data-start=\"270\" data-end=\"285\">ng\u00e0y (date)<\/strong>, <strong data-start=\"287\" data-end=\"301\">gi\u1edd (time)<\/strong> ho\u1eb7c <strong data-start=\"307\" data-end=\"322\">s\u1ed1 (number)<\/strong>, h\u00e3y <strong data-start=\"328\" data-end=\"358\">chuy\u1ec3n \u0111\u1ed5i v\u1ec1 d\u1ea1ng v\u0103n b\u1ea3n<\/strong> tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng.<\/p>\n<\/li>\n<li data-start=\"464\" data-end=\"694\">\n<p data-start=\"467\" data-end=\"694\"><strong>Ch\u1ec9 s\u1ed1 b\u1eaft \u0111\u1ea7u (start_num) ph\u1ea3i \u2265 1:<\/strong> N\u1ebfu b\u1ea1n \u0111\u1eb7t start_num nh\u1ecf h\u01a1n 1 (v\u00ed d\u1ee5: 0 ho\u1eb7c s\u1ed1 \u00e2m), Excel s\u1ebd b\u00e1o l\u1ed7i #VALUE!. V\u1ecb tr\u00ed k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i l\u00e0 1, kh\u00f4ng ph\u1ea3i 0 nh\u01b0 trong m\u1ed9t s\u1ed1 ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh kh\u00e1c.<\/p>\n<\/li>\n<li data-start=\"696\" data-end=\"982\">\n<p data-start=\"699\" data-end=\"982\"><strong data-start=\"699\" data-end=\"747\">Chu\u1ed7i c\u00f3 th\u1ec3 ch\u1ee9a kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 \u1ea9n<\/strong>: N\u1ebfu k\u1ebft qu\u1ea3 tr\u00edch xu\u1ea5t kh\u00f4ng \u0111\u00fang nh\u01b0 k\u1ef3 v\u1ecdng, h\u00e3y ki\u1ec3m tra xem chu\u1ed7i g\u1ed1c c\u00f3 ch\u1ee9a <strong data-start=\"836\" data-end=\"860\">kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba<\/strong>, <strong data-start=\"862\" data-end=\"880\">k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/strong>, <strong data-start=\"882\" data-end=\"903\">d\u1ea5u xu\u1ed1ng d\u00f2ng \u1ea9n<\/strong> hay kh\u00f4ng.<\/p>\n<\/li>\n<li data-start=\"984\" data-end=\"1262\">\n<p data-start=\"987\" data-end=\"1262\"><strong data-start=\"987\" data-end=\"1036\">Kh\u00f4ng ph\u00e2n bi\u1ec7t n\u1ed9i dung, ch\u1ec9 quan t\u00e2m v\u1ecb tr\u00ed<\/strong>: H\u00e0m MID <strong data-start=\"1051\" data-end=\"1096\">kh\u00f4ng quan t\u00e2m \u0111\u1ebfn ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng<\/strong>, v\u00e0 c\u0169ng kh\u00f4ng t\u00ecm ki\u1ebfm theo n\u1ed9i dung gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m SEARCH() hay FIND(). MID ch\u1ec9 tr\u00edch xu\u1ea5t theo <strong data-start=\"1202\" data-end=\"1222\">v\u1ecb tr\u00ed v\u00e0 \u0111\u1ed9 d\u00e0i<\/strong> b\u1ea1n \u0111\u00e3 cung c\u1ea5p, b\u1ea5t k\u1ec3 n\u1ed9i dung l\u00e0 g\u00ec.<\/p>\n<\/li>\n<li data-start=\"1264\" data-end=\"1508\">\n<p data-start=\"1267\" data-end=\"1508\"><strong>K\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 ng\u1eafn h\u01a1n num_chars n\u1ebfu chu\u1ed7i k\u1ebft th\u00fac s\u1edbm:<\/strong> N\u1ebfu b\u1ea1n y\u00eau c\u1ea7u nhi\u1ec1u k\u00fd t\u1ef1 h\u01a1n s\u1ed1 c\u00f2n l\u1ea1i trong chu\u1ed7i, h\u00e0m MID kh\u00f4ng b\u00e1o l\u1ed7i, m\u00e0 ch\u1ec9 tr\u1ea3 v\u1ec1 \u0111\u1ebfn k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng. V\u00ed d\u1ee5: =MID(&#8220;abc&#8221;,2,5) s\u1ebd tr\u1ea3 v\u1ec1 &#8220;bc&#8221; thay v\u00ec l\u1ed7i.<\/p>\n<\/li>\n<li data-start=\"1510\" data-end=\"1751\">\n<p data-start=\"1513\" data-end=\"1751\"><strong data-start=\"1513\" data-end=\"1569\">K\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u0103ng t\u00ednh \u0111\u1ed9ng<\/strong>: MID th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi FIND, SEARCH, LEN \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c chu\u1ed7i c\u00f3 c\u1ea5u tr\u00fac kh\u00f4ng c\u1ed1 \u0111\u1ecbnh.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478439 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-4.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 data-start=\"366\" data-end=\"437\">So s\u00e1nh h\u00e0m MID v\u1edbi c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 (LEFT, RIGHT, MIDB)<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 ph\u1ea7n so s\u00e1nh chi ti\u1ebft gi\u1eefa h\u00e0m MID v\u00e0 c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u01b0 LEFT, RIGHT v\u00e0 MIDB, gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t, t\u1eeb \u0111\u00f3 ch\u1ecdn \u0111\u00fang h\u00e0m ph\u00f9 h\u1ee3p cho t\u1eebng t\u00ecnh hu\u1ed1ng trong Excel:<\/p>\n<table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"245\" data-end=\"2089\">\n<thead data-start=\"245\" data-end=\"445\">\n<tr data-start=\"245\" data-end=\"445\">\n<th data-start=\"245\" data-end=\"275\" data-col-size=\"sm\">Ti\u00eau ch\u00ed<\/th>\n<th data-start=\"275\" data-end=\"318\" data-col-size=\"sm\">MID<\/th>\n<th data-start=\"318\" data-end=\"359\" data-col-size=\"sm\">LEFT<\/th>\n<th data-start=\"359\" data-end=\"400\" data-col-size=\"sm\">RIGHT<\/th>\n<th data-start=\"400\" data-end=\"445\" data-col-size=\"md\">MIDB (phi\u00ean b\u1ea3n byte)<\/th>\n<\/tr>\n<\/thead>\n<tbody data-start=\"648\" data-end=\"2089\">\n<tr data-start=\"648\" data-end=\"866\">\n<td data-start=\"648\" data-end=\"677\" data-col-size=\"sm\"><strong data-start=\"650\" data-end=\"669\">Ch\u1ee9c n\u0103ng ch\u00ednh<\/strong><\/td>\n<td data-col-size=\"sm\" data-start=\"677\" data-end=\"720\">Tr\u00edch k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong chu\u1ed7i<\/td>\n<td data-col-size=\"sm\" data-start=\"720\" data-end=\"761\">L\u1ea5y k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i (tr\u00e1i sang)<\/td>\n<td data-col-size=\"sm\" data-start=\"761\" data-end=\"802\">L\u1ea5y k\u00fd t\u1ef1 t\u1eeb cu\u1ed1i chu\u1ed7i (ph\u1ea3i sang)<\/td>\n<td data-col-size=\"md\" data-start=\"802\" data-end=\"866\">T\u01b0\u01a1ng t\u1ef1 MID nh\u01b0ng \u0111\u1ebfm theo byte (2 byte\/ k\u00fd t\u1ef1 n\u1ebfu Unicode)<\/td>\n<\/tr>\n<tr data-start=\"867\" data-end=\"1069\">\n<td data-start=\"867\" data-end=\"896\" data-col-size=\"sm\"><strong data-start=\"869\" data-end=\"880\">C\u00fa ph\u00e1p<\/strong><\/td>\n<td data-col-size=\"sm\" data-start=\"896\" data-end=\"940\">=MID(text, start_num, num_chars)<\/td>\n<td data-col-size=\"sm\" data-start=\"940\" data-end=\"981\">=LEFT(text, num_chars)<\/td>\n<td data-col-size=\"sm\" data-start=\"981\" data-end=\"1022\">=RIGHT(text, num_chars)<\/td>\n<td data-col-size=\"md\" data-start=\"1022\" data-end=\"1069\">=MIDB(text, start_num, num_bytes)<\/td>\n<\/tr>\n<tr data-start=\"1070\" data-end=\"1272\">\n<td data-start=\"1070\" data-end=\"1099\" data-col-size=\"sm\"><strong data-start=\"1072\" data-end=\"1090\">V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u<\/strong><\/td>\n<td data-col-size=\"sm\" data-start=\"1099\" data-end=\"1142\">T\u00f9y ch\u1ecdn v\u1ecb tr\u00ed<\/td>\n<td data-col-size=\"sm\" data-start=\"1142\" data-end=\"1183\">Lu\u00f4n b\u1eaft \u0111\u1ea7u t\u1eeb tr\u00e1i<\/td>\n<td data-col-size=\"sm\" data-start=\"1183\" data-end=\"1224\">Lu\u00f4n b\u1eaft \u0111\u1ea7u t\u1eeb ph\u1ea3i<\/td>\n<td data-col-size=\"md\" data-start=\"1224\" data-end=\"1272\">T\u00f9y ch\u1ecdn (\u0111\u1ebfm theo byte)<\/td>\n<\/tr>\n<tr data-start=\"1273\" data-end=\"1475\">\n<td data-start=\"1273\" data-end=\"1302\" data-col-size=\"sm\"><strong data-start=\"1275\" data-end=\"1296\">S\u1ed1 k\u00fd t\u1ef1 tr\u00edch ra<\/strong><\/td>\n<td data-start=\"1302\" data-end=\"1345\" data-col-size=\"sm\">X\u00e1c \u0111\u1ecbnh r\u00f5 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1<\/td>\n<td data-start=\"1345\" data-end=\"1386\" data-col-size=\"sm\">X\u00e1c \u0111\u1ecbnh r\u00f5 t\u1eeb b\u00ean tr\u00e1i<\/td>\n<td data-start=\"1386\" data-end=\"1427\" data-col-size=\"sm\">X\u00e1c \u0111\u1ecbnh r\u00f5 t\u1eeb b\u00ean ph\u1ea3i<\/td>\n<td data-start=\"1427\" data-end=\"1475\" data-col-size=\"md\">X\u00e1c \u0111\u1ecbnh s\u1ed1 byte<\/td>\n<\/tr>\n<tr data-start=\"1476\" data-end=\"1683\">\n<td data-start=\"1476\" data-end=\"1505\" data-col-size=\"sm\"><strong data-start=\"1478\" data-end=\"1489\">\u01afu \u0111i\u1ec3m<\/strong><\/td>\n<td data-start=\"1505\" data-end=\"1548\" data-col-size=\"sm\">Linh ho\u1ea1t v\u1ecb tr\u00ed tr\u00edch xu\u1ea5t<\/td>\n<td data-start=\"1548\" data-end=\"1589\" data-col-size=\"sm\">D\u1ec5 d\u00f9ng khi lu\u00f4n c\u1ea7n \u0111\u1ea7u chu\u1ed7i<\/td>\n<td data-start=\"1589\" data-end=\"1630\" data-col-size=\"sm\">D\u1ec5 d\u00f9ng khi lu\u00f4n c\u1ea7n cu\u1ed1i chu\u1ed7i<\/td>\n<td data-start=\"1630\" data-end=\"1683\" data-col-size=\"md\">H\u1eefu \u00edch v\u1edbi ng\u00f4n ng\u1eef \u0111a byte (ti\u1ebfng Nh\u1eadt, Trung\u2026)<\/td>\n<\/tr>\n<tr data-start=\"1684\" data-end=\"1887\">\n<td data-start=\"1684\" data-end=\"1713\" data-col-size=\"sm\"><strong data-start=\"1686\" data-end=\"1700\">Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/strong><\/td>\n<td data-col-size=\"sm\" data-start=\"1713\" data-end=\"1756\">Ph\u1ea3i x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u<\/td>\n<td data-col-size=\"sm\" data-start=\"1756\" data-end=\"1799\">\u00cdt linh ho\u1ea1t n\u1ebfu chu\u1ed7i thay \u0111\u1ed5i c\u1ea5u tr\u00fac<\/td>\n<td data-col-size=\"sm\" data-start=\"1799\" data-end=\"1840\">\u00cdt linh ho\u1ea1t t\u01b0\u01a1ng t\u1ef1<\/td>\n<td data-col-size=\"md\" data-start=\"1840\" data-end=\"1887\">D\u1ec5 sai s\u00f3t n\u1ebfu kh\u00f4ng n\u1eafm byte k\u00fd t\u1ef1<\/td>\n<\/tr>\n<tr data-start=\"1888\" data-end=\"2089\">\n<td data-start=\"1888\" data-end=\"1917\" data-col-size=\"sm\"><strong data-start=\"1890\" data-end=\"1911\">\u1ee8ng d\u1ee5ng ph\u1ed5 bi\u1ebfn<\/strong><\/td>\n<td data-col-size=\"sm\" data-start=\"1917\" data-end=\"1959\">T\u00e1ch m\u00e3 trong chu\u1ed7i c\u00f3 c\u1ea5u tr\u00fac c\u1ed1 \u0111\u1ecbnh<\/td>\n<td data-col-size=\"sm\" data-start=\"1959\" data-end=\"2000\">L\u1ea5y m\u00e3 \u0111\u1ea7u d\u00f2ng, h\u1ecd trong t\u00ean<\/td>\n<td data-col-size=\"sm\" data-start=\"2000\" data-end=\"2041\">L\u1ea5y s\u1ed1 cu\u1ed1i, ph\u1ea7n m\u1edf r\u1ed9ng t\u1ec7p, m\u00e3 cu\u1ed1i<\/td>\n<td data-col-size=\"md\" data-start=\"2041\" data-end=\"2089\">T\u00e1ch chu\u1ed7i trong ng\u00f4n ng\u1eef \u0111a byte (Unicode)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"_tableContainer_80l1q_1\">\n<div class=\"_tableWrapper_80l1q_14 group flex w-fit flex-col-reverse\">\n<div class=\"sticky end-(--thread-content-margin) h-0 self-end select-none\">\n<div class=\"absolute end-0 flex items-end\">\n<h2 data-start=\"1456\" data-end=\"1509\">\u1ee8ng d\u1ee5ng h\u00e0m MID trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c<\/h2>\n<p>H\u00e0m MID kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ecdc thu\u1eadt trong Excel, m\u00e0 c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn trong m\u00f4i tr\u01b0\u1eddng l\u00e0m vi\u1ec7c chuy\u00ean nghi\u1ec7p, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00e1c l\u0129nh v\u1ef1c c\u1ea7n x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n, m\u00e3 \u0111\u1ecbnh danh hay th\u00f4ng tin chu\u1ed7i. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf m\u00e0 h\u00e0m MID c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 \u0111\u01a1n gi\u1ea3n h\u00f3a quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u:<\/p>\n<ul data-start=\"1620\" data-end=\"1789\">\n<li data-start=\"1620\" data-end=\"1647\">\n<p data-start=\"1622\" data-end=\"1647\">K\u1ebf to\u00e1n: Tr\u00edch m\u00e3 h\u00f3a \u0111\u01a1n<\/p>\n<\/li>\n<li data-start=\"1648\" data-end=\"1693\">\n<p data-start=\"1650\" data-end=\"1693\">Nh\u00e2n s\u1ef1: L\u1ea5y m\u00e3 nh\u00e2n vi\u00ean t\u1eeb chu\u1ed7i ph\u1ee9c t\u1ea1p<\/p>\n<\/li>\n<li data-start=\"1694\" data-end=\"1733\">\n<p data-start=\"1696\" data-end=\"1733\">Th\u1ed1ng k\u00ea: Ph\u00e2n t\u00edch chu\u1ed7i m\u00e3 s\u1ea3n ph\u1ea9m<\/p>\n<\/li>\n<li data-start=\"1734\" data-end=\"1789\">\n<p data-start=\"1736\" data-end=\"1789\">E-commerce: T\u00e1ch SKU, m\u00e3 ph\u00e2n lo\u1ea1i, v\u00f9ng kh\u00e1ch h\u00e0ng,\u2026<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-mid-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-478440 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-5.jpg\" alt=\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>H\u00e0m MID gi\u00fap t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u trong nhi\u1ec1u l\u0129nh v\u1ef1c: k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1, b\u00e1n h\u00e0ng, qu\u1ea3n l\u00fd kho, logistics,\u2026 Vi\u1ec7c n\u1eafm v\u1eefng v\u00e0 \u1ee9ng d\u1ee5ng linh ho\u1ea1t h\u00e0m MID s\u1ebd gi\u00fap b\u1ea1n t\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c, gi\u1ea3m sai s\u00f3t th\u1ee7 c\u00f4ng v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a nhi\u1ec1u b\u01b0\u1edbc trong quy tr\u00ecnh qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2 data-start=\"3419\" data-end=\"3668\">T\u1ea1m k\u1ebft<\/h2>\n<p data-start=\"697\" data-end=\"1138\">H\u00e0m MID trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 x\u1eed l\u00fd chu\u1ed7i kh\u00f4ng th\u1ec3 thi\u1ebfu khi b\u1ea1n c\u1ea7n thao t\u00e1c v\u1edbi d\u1eef li\u1ec7u v\u0103n b\u1ea3n c\u00f3 c\u1ea5u tr\u00fac c\u1ed1 \u0111\u1ecbnh ho\u1eb7c b\u00e1n c\u1ed1 \u0111\u1ecbnh. Qua nh\u1eefng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 m\u00e0 Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 chia s\u1ebb \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y MID kh\u00f4ng ch\u1ec9 d\u1ec5 s\u1eed d\u1ee5ng m\u00e0 c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 gi\u1ea3i quy\u1ebft nhi\u1ec1u b\u00e0i to\u00e1n th\u1ef1c t\u1ebf. H\u00e3y th\u1eed \u00e1p d\u1ee5ng ngay v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n \u0111\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c s\u1ef1 ti\u1ec7n l\u1ee3i m\u00e0 h\u00e0m MID mang l\u1ea1i trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n<p><em><strong>XEM TH\u00caM:<\/strong><\/em><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\">H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel-2\/\">10 th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch, b\u1eaft bu\u1ed9c ph\u1ea3i nh\u1edb<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean Excel, vi\u1ec7c tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n th\u00f4ng tin t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n l\u00e0 nhu c\u1ea7u r\u1ea5t ph\u1ed5 bi\u1ebfn. Excel cung c\u1ea5p nhi\u1ec1u h\u00e0m h\u1ed7 tr\u1ee3 l\u00e0m vi\u1ec7c v\u1edbi chu\u1ed7i, trong \u0111\u00f3 h\u00e0m MID l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n l\u1ea5y m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n n\u1eb1m [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":478446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-477857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft<\/title>\n<meta name=\"description\" content=\"T\u00ecm hi\u1ec3u chi ti\u1ebft h\u00e0m MID trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m 5 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"T\u00ecm hi\u1ec3u chi ti\u1ebft h\u00e0m MID trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m 5 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-30T01:51:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Lan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\"},\"headline\":\"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\",\"datePublished\":\"2025-07-30T01:51:09+00:00\",\"dateModified\":\"2025-07-30T01:51:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\"},\"wordCount\":2909,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\",\"name\":\"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg\",\"datePublished\":\"2025-07-30T01:51:09+00:00\",\"dateModified\":\"2025-07-30T01:51:09+00:00\",\"description\":\"T\u00ecm hi\u1ec3u chi ti\u1ebft h\u00e0m MID trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m 5 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-11\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"caption\":\"Vo Lan\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft","description":"T\u00ecm hi\u1ec3u chi ti\u1ebft h\u00e0m MID trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m 5 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft","og_description":"T\u00ecm hi\u1ec3u chi ti\u1ebft h\u00e0m MID trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m 5 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-07-30T01:51:09+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"13 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0"},"headline":"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft","datePublished":"2025-07-30T01:51:09+00:00","dateModified":"2025-07-30T01:51:09+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/"},"wordCount":2909,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/","name":"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg","datePublished":"2025-07-30T01:51:09+00:00","dateModified":"2025-07-30T01:51:09+00:00","description":"T\u00ecm hi\u1ec3u chi ti\u1ebft h\u00e0m MID trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m 5 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-mid-11.jpg","width":1200,"height":628,"caption":"ham-mid-trong-excel-cu-phap-va-cach-su-dung-kem-vi-du-minh-hoa-chi-tiet-11"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/477857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=477857"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/477857\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/478446"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=477857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=477857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=477857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}