{"id":277142,"date":"2023-11-21T19:35:18","date_gmt":"2023-11-21T12:35:18","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=277142"},"modified":"2023-11-21T19:35:18","modified_gmt":"2023-11-21T12:35:18","slug":"ham-mid","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng chu\u1ed7i v\u0103n b\u1ea3n trong Excel, ch\u00fang ta s\u1ebd r\u1ea5t kh\u00f3 \u0111\u1ec3 t\u1ef1 ph\u00e2n t\u00e1ch d\u1eef li\u1ec7u b\u1eb1ng thao t\u00e1c th\u1ee7 c\u00f4ng. Thay v\u00e0o \u0111\u00f3, vi\u1ec7c s\u1eed d\u1ee5ng <strong>h\u00e0m MID<\/strong> mang \u0111\u1ebfn s\u1ef1 ti\u1ec7n l\u1ee3i v\u00e0 nhanh ch\u00f3ng h\u01a1n nhi\u1ec1u. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m n\u00e0y trong Excel<\/strong> \u0111\u1ec3 c\u1eaft chu\u1ed7i th\u00ec tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y!<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m MID trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n<p>Tr\u01b0\u1edbc khi \u0111i v\u00e0o t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng chi ti\u1ebft, ch\u00fang ta ph\u1ea3i n\u1eafm \u0111\u01b0\u1ee3c \u00fd ngh\u0129a h\u00e0m MID l\u00e0 g\u00ec. \u0110\u00e2y v\u1ed1n l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c c\u1eaft chu\u1ed7i th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel. <span style=\"font-weight: 400;\">Nguy\u00ean l\u00fd ho\u1ea1t \u0111\u1ed9ng c\u1ee7a k\u1ef9 thu\u1eadt n\u00e0y l\u00e0 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c theo v\u1ecb tr\u00ed m\u00e0 ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 \u0111\u1ecbnh ph\u00e2n t\u00edch.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m MID khi mu\u1ed1n l\u1ea5y ra m\u1ed9t chu\u1ed7i con c\u00e1c th\u00f4ng tin c\u1ea7n thi\u1ebft b\u1ea5t k\u1ef3 tr\u00ean to\u00e0n b\u1ed9 chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c. Thao t\u00e1c tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 r\u1ea5t nhanh ch\u00f3ng, t\u1eeb \u0111\u00f3 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian cho ng\u01b0\u1eddi d\u00f9ng v\u00e0 mang t\u00ednh ch\u00ednh x\u00e1c cao, g\u1ea7n nh\u01b0 kh\u00f4ng c\u00f3 sai s\u00f3t.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-277231 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh h\u00e0m <\/span><span style=\"font-weight: 400;\">SUM, IF hay MIN, MAX\u2026 th\u00ec <\/span><span style=\"font-weight: 400;\">h\u00e0m MID c\u0169ng l\u00e0 m\u1ed9t h\u00e0m v\u0103n b\u1ea3n th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel, \u0111\u1eb7c bi\u1ec7t l\u00e0 \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. Sau khi hi\u1ec3u r\u00f5 kh\u00e1i ni\u1ec7m v\u00e0 ch\u1ee9c n\u0103ng, ch\u00fang ta m\u1edbi c\u00f3 th\u1ec3 h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o. V\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 \u1ee9ng d\u1ee5ng n\u00f3 v\u00e0o th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n, th\u1ed1ng k\u00ea h\u00e0ng ng\u00e0y.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m MID trong Excel\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u1eb3n l\u00e0 nhi\u1ec1u ng\u01b0\u1eddi \u0111ang r\u1ea5t t\u00f2 m\u00f2 v\u1ec1 <\/span><span style=\"font-weight: 400;\">c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m MID? Li\u1ec7u c\u00f3 ph\u1ee9c t\u1ea1p kh\u00f4ng? Th\u1ef1c t\u1ebf, h\u00e0m n\u00e0y<\/span><span style=\"font-weight: 400;\">\u00a0hi\u1ec7n nay \u0111\u1ec1u c\u00f3 s\u1eb5n tr\u00ean h\u1ea7u h\u1ebft c\u00e1c phi\u00ean b\u1ea3n Microsoft Excel t\u1eeb 2007 tr\u1edf \u0111i.<\/span><span style=\"font-weight: 400;\"> \u0110\u1ed3ng th\u1eddi \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n c\u1ea3 tr\u00ean thi\u1ebft b\u1ecb Windows ho\u1eb7c MacOS v\u1edbi c\u00f9ng m\u1ed9t thao t\u00e1c. N\u00f3 t\u01b0\u01a1ng \u0111\u1ed1i d\u1ec5 d\u00f9ng n\u1ebfu ch\u00fang ta n\u1eafm r\u00f5 thao t\u00e1c th\u1ef1c hi\u1ec7n.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c chu\u1ea9n nh\u01b0 sau: <\/span><strong>=MID(<\/strong><span style=\"font-weight: 400;\"><strong>text; start_num; num_chars)<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u1eefng th\u1ee9 n\u1eb1m \u1edf ph\u00eda b\u00ean trong hai d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 trong h\u00e0m n\u00e0y, c\u1ee5 th\u1ec3 l\u00e0:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">text: \u0110\u00e2y l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 ch\u1ee9a to\u00e0n b\u1ed9 ph\u1ea7n v\u0103n b\u1ea3n g\u1ed1c m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n ch\u1ec9 \u0111\u1ecbnh c\u1eaft.\u00a0 <\/span><\/li>\n<li>start_num: V\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n tr\u00edch ra t\u1eeb Text.<\/li>\n<li>num_chars: S\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n tr\u1ea3 v\u1ec1.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-277232 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">L\u01b0u \u00fd<\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c h\u00e0m MID \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp m\u1eb7c \u0111\u1ecbnh trong Excel. C\u00f3 m\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft khi ti\u1ebfn h\u00e0nh s\u1eed d\u1ee5ng n\u00f3 v\u00e0 xem k\u1ebft qu\u1ea3 c\u1eaft chu\u1ed7i. B\u1edfi n\u1ebfu \u00e1p d\u1ee5ng sai, ch\u00fang ta s\u1ebd t\u1ed1n th\u1eddi gian m\u00e0 kh\u00f4ng tri\u1ec3n khai \u0111\u01b0\u1ee3c \u0111\u00fang nh\u01b0 mong mu\u1ed1n.<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb start_num l\u1edbn h\u01a1n t\u1ed5ng chi\u1ec1u d\u00e0i k\u00fd t\u1ef1 c\u1ee7a v\u0103n b\u1ea3n g\u1ed1c mu\u1ed1n c\u1eaft. Sau ti\u1ebfn h\u00e0nh nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m n\u00e0y, k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng tr\u1ea3 v\u1ec1 l\u00e0 m\u1ed9t chu\u1ed7i \u00f4 r\u1ed7ng.<\/span><\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb start_num nh\u1ecf h\u01a1n 1, c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 b\u00e1o l\u1ed7i #VALUE.<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb num_chars b\u00e9 h\u01a1n 0 (l\u00e0 s\u1ed1 \u00e2m), c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m tr\u1ea3 v\u1ec1 b\u00e1o l\u1ed7i #VALUE.<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb num_chars b\u1eb1ng 0, k\u1ebft qu\u1ea3 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i \u00f4 r\u1ed7ng.<\/li>\n<li>N\u00ea\u0301u gi\u00e1 tr\u1ecb start_num nho\u0309 h\u01a1n chi\u1ec1u d\u00e0i k\u00fd t\u1ef1 c\u1ee7a v\u0103n b\u1ea3n g\u1ed1c c\u1ea7n c\u1eaft chu\u1ed7i. Nh\u01b0ng t\u1ed5ng gi\u00e1 tr\u1ecb start_num v\u00e0 num_chars khi c\u1ed9ng l\u1ea1i v\u1edbi nhau v\u01b0\u01a1\u0323t qua\u0301 \u0111\u00f4\u0323 da\u0300i chu\u1ed7i k\u00fd t\u1ef1. K\u1ebft qu\u1ea3 ha\u0300m tra\u0309 v\u00ea\u0300 s\u1ebd bao g\u1ed3m ca\u0301c ky\u0301 t\u01b0\u0323 b\u1eaft \u0111\u1ea7u t\u1eeb start_num \u0111\u00ea\u0301n cu\u00f4\u0301i c\u00f9ng cu\u0309a chu\u1ed7i k\u00fd t\u1ef1 g\u1ed1c ban \u0111\u1ea7u \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i<\/span><\/h2>\n<p>Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng m\u1ed9t m\u00ecnh, h\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c trong Excel \u0111\u1ec3 vi\u1ec7c c\u1eaft chu\u1ed7i \u0111\u01b0\u1ee3c chi ti\u1ebft h\u01a1n. V\u00ed d\u1ee5 nh\u01b0 h\u00e0m <span style=\"font-weight: 400;\">SEARCH, LEN hay VALUE. N\u1eafm r\u00f5 t\u1eebng c\u00e1ch m\u1ed9t s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1eadn d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch t\u1ed1i \u0111a tr\u00ean b\u1ea3ng t\u00ednh, \u0111\u1ed3ng th\u1eddi r\u00fat ng\u1eafn th\u1eddi gian l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng H\u00e0m MID m\u1ed9t m\u00ecnh<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 c\u00e1ch d\u00f9ng c\u0103n b\u1ea3n v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t c\u1ee7a h\u00e0m c\u1eaft chu\u1ed7i. Khi s\u1eed d\u1ee5ng \u0111\u1ed9c l\u1eadp, ch\u00fang ta ch\u1ee7 y\u1ebfu s\u1ebd ch\u1ec9 c\u1eaft \u0111\u01b0\u1ee3c nh\u1eefng chu\u1ed7i k\u00fd t\u1ef1 trong v\u0103n b\u1ea3n ng\u1eafn g\u1ecdn, \u0111\u01a1n gi\u1ea3n.<\/span><\/p>\n<p>V\u00ed d\u1ee5: T\u1eeb chu\u1ed7i k\u00fd t\u1ef1 v\u0103n b\u1ea3n g\u1ed1c HOANGHAMOBILE \u1edf \u00f4 A1 trong h\u00e0m Excel. B\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 &#8220;MOBILE&#8221; t\u1eeb v\u0103n b\u1ea3n g\u1ed1c b\u1eb1ng h\u00e0m n\u00e0y th\u00ec ph\u1ea3i l\u00e0m sao?<\/p>\n<p>\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c ban \u0111\u1ea7u ta s\u1ebd nh\u1eadp nh\u01b0 sau: <strong>=MID(A1;8;6)<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-277233 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Trong \u0111\u00f3: A1 ch\u00ednh l\u00e0 to\u00e0n b\u1ed9 chu\u1ed7i k\u00fd t\u1ef1 trong v\u0103n b\u1ea3n g\u1ed1c ban \u0111\u1ea7u &#8220;HOANGHAMOBILE&#8221;. 8 l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 con &#8220;MOBILE&#8221; m\u00e0 b\u1ea1n mu\u1ed1n t\u00e1ch t\u1eeb A1. 6 l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 c\u1ee7a c\u1ee5m t\u1eeb &#8220;MOBILE&#8221;. \u0110\u00e1p \u00e1n tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c \u1edf \u00f4 s\u1eed d\u1ee5ng h\u00e0m s\u1ebd l\u00e0 &#8220;MOBILE&#8221;.<\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m MID k\u1ebft h\u1ee3p SEARCH <\/span><span style=\"font-weight: 400;\">\u0111\u1ec3 tr\u00edch xu\u1ea5t h\u1ecd<\/span><\/h3>\n<p>Th\u1ed1ng k\u00ea t\u00ean trong file Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu. Tuy nhi\u00ean, v\u00ec gi\u1eefa h\u1ecd v\u00e0 t\u00ean lu\u00f4n t\u1ed3n t\u1ea1i nh\u1eefng kho\u1ea3ng tr\u1ed1ng c\u1ee7a d\u1ea5u c\u00e1ch. V\u00ec v\u1eady, ch\u00fang ta c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m n\u00e0y k\u1ebft h\u1ee3p v\u1edbi SEARCH th\u00ec m\u1edbi c\u00f3 th\u1ec3 t\u00e1ch \u0111\u01b0\u1ee3c theo \u0111\u00fang mong mu\u1ed1n. C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m SEARCH trong Excel ch\u00ednh l\u00e0 lo\u1ea1i b\u1ecf \u0111i d\u1ea5u c\u00e1ch, gi\u00fap cho vi\u1ec7c c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 kh\u00f4ng g\u1eb7p c\u1ea3n tr\u1edf.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>H\u1ecd v\u00e0 t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a t\u1eebng ng\u01b0\u1eddi n\u1eb1m trong c\u1ed9t B trong h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y, l\u1ea7n l\u01b0\u1ee3t t\u1eeb B2 \u0111\u1ebfn B5.<\/p>\n<p>Trong \u0111\u00f3, h\u1ecd v\u00e0 t\u00ean ng\u01b0\u1eddi \u1edf c\u1ed9t B2 l\u00e0 Nguy\u1ec5n L\u1ec7 Thu \u0111ang \u0111\u01b0\u1ee3c ng\u0103n c\u00e1ch b\u1edfi nh\u1eefng d\u1ea5u c\u00e1ch. C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00e1ch h\u1ecd s\u1ebd l\u00e0 <strong>=MID(B2,1,SEARCH(&#8221; &#8220;,B2)-1)<\/strong>. K\u1ebft qu\u1ea3 &#8220;Nguy\u1ec5n&#8221; \u0111\u01b0\u1ee3c l\u1ecdc v\u00e0 tr\u1ea3 v\u1ec1 \u1edf \u00f4 d\u00f9ng h\u00e0m (c\u1ed9t C).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277235 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Nh\u1ea5n Enter v\u00e0 k\u00e9o con tr\u1ecf chu\u1ed9t gi\u00f3ng th\u1eb3ng h\u00e0ng xu\u1ed1ng c\u1ed9t C (l\u00e0 c\u1ed9t d\u00f9ng h\u00e0m) \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u1edf nh\u1eefng h\u00e0ng c\u00f2n l\u1ea1i. K\u1ebft qu\u1ea3 h\u00e0ng 3 \u0111\u1ebfn 5 cho ra chu\u1ed7i \u0111\u00e3 c\u1eaft t\u01b0\u01a1ng t\u1ef1 d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c ban \u0111\u1ea7u.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277241 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m MID k\u1ebft h\u1ee3p LEN v\u00e0 TRIM \u0111\u1ec3 l\u1ecdc<\/span><span style=\"font-weight: 400;\">\u00a0t\u00ean ri\u00eang<\/span><\/h3>\n<p>N\u1ebfu h\u00e0m n\u00e0y k\u1ebft h\u1ee3p v\u1edbi m\u1ed7i SEARCH \u0111\u1ec3 t\u00e1ch ri\u00eang h\u1ecd th\u00ec ch\u00fang ta s\u1ebd d\u00f9ng n\u00f3 k\u00e8m th\u00eam c\u1ea3 h\u00e0m LEN v\u00e0 TRIM v\u00e0 khi mu\u1ed1n l\u1ecdc t\u00ean trong danh s\u00e1ch H\u1ecd v\u00e0 t\u00ean.<\/p>\n<p>B\u1ea1n v\u1eabn s\u1ebd c\u1ea7n \u0111\u1ebfn s\u1ef1 h\u1ed7 tr\u1ee3 c\u1ee7a h\u00e0m SEARCH \u0111\u1ec3 lo\u1ea1i c\u00e1c b\u1ecf d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean kh\u00f4ng c\u1ea7n thi\u1ebft. \u0110\u1ed3ng th\u1eddi s\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 gi\u1eef l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1ed1ng gi\u1eefa 2 t\u1eeb l\u00e0 t\u00ean \u0111\u1ec7m v\u00e0 t\u00ean ri\u00eang.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>H\u1ecd v\u00e0 t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a c\u1ed9t B2 l\u00e0 Nguy\u1ec5n L\u1ec7 Thu. \u0110\u1ec3 t\u00e1ch t\u00ean ri\u00eang, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau: <strong>=TRIM(MID(B2,SEARCH(\u201d \u201c),B2),LEN(B2)))<\/strong>. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c \u1edf c\u1ed9t C2 d\u00f9ng h\u00e0m s\u1ebd l\u00e0 &#8220;L\u1ec7 Thu&#8221;.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277243 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277246 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>C\u00e1c h\u00e0ng kh\u00e1c \u1edf c\u1ed9t C trong b\u1ea3ng Excel ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c c\u1eaft chu\u1ed7i t\u1eeb C2 l\u00e0 s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 v\u00f4 c\u00f9ng nhanh g\u1ecdn.<\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa 2 d\u1ea5u c\u00e1ch<\/span><\/h3>\n<p>Ngo\u00e0i 2 c\u00e1ch k\u1ec3 tr\u00ean, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 c\u1eaft chu\u1ed7i ri\u00eang t\u00ean \u0111\u1ec7m b\u1eb1ng h\u00e0m MID trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n thi\u1ebft.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>\u1ede c\u1ed9t B2 Nguy\u1ec5n L\u1ec7 Thu. \u0110\u1ec3 c\u1eaft chu\u1ed7i ri\u00eang t\u00ean \u0111\u1ec7m th\u00ec c\u1ea7n l\u00e0m nh\u01b0 sau:`<\/p>\n<p>Tr\u01b0\u1edbc ti\u00ean, ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m SEARCH \u0111\u1ec3 lo\u1ea1i b\u1ecf v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean \u0111\u1ee9ng tr\u01b0\u1edbc t\u00ean \u0111\u1ec7m. \u0110\u1ed3ng th\u1eddi c\u1ed9ng th\u00eam 1 \u0111\u1ec3 khi h\u00e0m c\u1eaft chu\u1ed7i th\u00ec n\u00f3 s\u1ebd t\u00ednh k\u00ed t\u1ef1 b\u1eaft \u0111\u1ea7u ngay sau d\u1ea5u c\u00e1ch \u0111\u00f3. C\u00f4ng th\u1ee9c l\u00e0: <strong>SEARCH(\u201d \u201c,B2)+1<\/strong><\/p>\n<p>Sau \u0111\u00f3, ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh num_chars c\u1ea7n c\u1eaft chu\u1ed7i. \u0110\u01b0\u1ee3c t\u00ednh t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean sau d\u1ea5u c\u00e1ch th\u1ee9 nh\u1ea5t cho t\u1edbi v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch th\u1ee9 2. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0: <strong>SEARCH(\u201d \u201c,B2,SEARCH(\u201d \u201c,B2)+1)<\/strong><\/p>\n<p>B\u01b0\u1edbc th\u1ee9 3, \u0111\u1ec3 l\u1ecdc ra \u0111\u00fang chu\u1ed7i k\u00fd t\u1ef1 mu\u1ed1n c\u1eaft, ch\u00fang ta s\u1ebd tr\u1eeb \u0111i ch\u1ed7 tr\u1ed1ng c\u1ee7a 2 d\u1ea5u c\u00e1ch ban \u0111\u1ea7u. C\u00f4ng th\u1ee9c l\u00e0: <strong>SEARCH (\u201d \u201c, B2, SEARCH (\u201d \u201c,B2)+1) \u2013 SEARCH (\u201d \u201c,B2).<\/strong><\/p>\n<p>Cu\u1ed1i c\u00f9ng, ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p 3 c\u00f4ng th\u1ee9c n\u00e0y l\u1ea1i v\u1edbi nhau v\u00e0 d\u00f9ng h\u00e0m MID \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa 2 d\u1ea5u c\u00e1ch.<\/p>\n<p>C\u00f4ng th\u1ee9c chu\u1ea9n s\u1ebd l\u00e0:\u00a0<strong>=MID(B2, SEARCH(\u201d \u201c,B2)+1, SEARCH (\u201d \u201c, B2, SEARCH (\u201d \u201c,B2)+1) \u2013 SEARCH (\u201d \u201c,B2)-1)<\/strong><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277247 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277248 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u1edf c\u1ed9t C s\u1ebd l\u1ea7n l\u01b0\u1ee3t l\u00e0 t\u00ean \u0111\u1ec7m \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t t\u1eeb c\u1ed9t B \u0111\u1ea7y \u0111\u1ee7 h\u1ecd v\u00e0 t\u00ean. N\u1ebfu b\u1ea1n \u00e1p d\u1ee5ng sai c\u00f4ng th\u1ee9c, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 b\u00e1o l\u1ed7i #VALUE.<\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m MID k\u1ebft h\u1ee3p VALUE \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1<\/span><\/h3>\n<p>Ngo\u00e0i vi\u1ec7c c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 ch\u1eef c\u00e1i \u0111\u01a1n thu\u1ea7n, ng\u01b0\u1eddi d\u00f9ng c\u00f2n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng h\u00e0m n\u00e0y trong Excel \u0111\u1ec3 l\u1ecdc ra ch\u1eef s\u1ed1. Ch\u1ec9 kh\u00e1c l\u00e0 ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m n\u00e0y c\u00f9ng v\u1edbi VALUE thay cho SEARCH hay LEN \u0111\u1ec3 t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c chu\u1ea9n x\u00e1c nh\u1ea5t. C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>Ch\u00fang ta s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t nh\u01b0 sau <strong>=VALUE(MID(text;start_num;num_chars))<\/strong><\/p>\n<p>\u0110\u1ec3 tr\u00edch m\u1ed9t chu\u1ed7i con ch\u1ec9 bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 trong to\u00e0n b\u1ed9 chu\u1ed7i v\u0103n b\u1ea3n \u1edf c\u1ed9t B2 &#8220;Hoanghamobile102phoxom&#8221;, c\u00f4ng th\u1ee9c l\u00e0\u00a0<span style=\"font-weight: 400;\">=VALUE(MID(B2,14,3))<\/span><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>VALUA c\u00f3 c\u00f4ng d\u1ee5ng l\u00e0 h\u00e0m \u0111\u1ed5i chu\u1ed7i k\u00fd t\u1ef1 th\u00e0nh s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/li>\n<li>Text: \u00d4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1.<\/li>\n<li>Start_num: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u b\u1eaft \u0111\u1ea7u m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y (sau hoanghamobile l\u00e0 v\u1ecb tr\u00ed th\u1ee9 14)<\/li>\n<li>Num_chars: S\u1ed1 k\u00fd t\u1ef1 b\u1ea1n c\u1ea7n l\u1ea5y 102 (3 s\u1ed1)<\/li>\n<\/ul>\n<p>\u0110\u00e1p \u00e1n tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c t\u1ea1i c\u1ed9t C2 s\u1ebd l\u00e0 102. C\u00e1ch l\u00e0m c\u0169ng t\u01b0\u01a1ng t\u1ef1 \u1edf nh\u1eefng h\u00e0ng c\u00f2n l\u1ea1i trong c\u1ed9t n\u00e0y.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277249 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-277252 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m MID khi \u1ee9ng d\u1ee5ng v\u00e0o cu\u1ed9c s\u1ed1ng<\/span><\/h2>\n<p>\u0110\u1ed1i v\u1edbi nh\u1eefng ai l\u00e0m v\u0103n ph\u00f2ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng ng\u00e0nh ngh\u1ec1 li\u00ean quan \u0111\u1ebfn th\u1ed1ng k\u00ea s\u1ed1 li\u1ec7u r\u1ea5t th\u01b0\u1eddng xuy\u00ean ph\u1ea3i d\u00f9ng Excel. \u0110i\u1ec1u \u0111\u00f3 \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c bi\u1ebft s\u1eed d\u1ee5ng h\u00e0m c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 mang l\u1ea1i r\u1ea5t h\u1eefu \u00edch cho b\u1ea1n. M\u1ed9t s\u1ed1 c\u00f4ng d\u1ee5ng \u0111i\u1ec3n h\u00ecnh ph\u1ea3i k\u1ec3 \u0111\u1ebfn nh\u01b0: L\u1ecdc ra th\u00f4ng tin d\u1ec5 d\u00e0ng, h\u1ed7 tr\u1ee3 t\u00ednh \u0111\u01a1n gi\u1ea3n nhanh ch\u00f3ng. T\u1eeb \u0111\u00f3 mang l\u1ea1i hi\u1ec7u qu\u1ea3 trong c\u00f4ng vi\u1ec7c, \u0111\u1ee1 t\u1ed1n th\u1eddi gian.<\/p>\n<h3><span style=\"font-weight: 400;\">C\u1eaft chu\u1ed7i v\u00e0 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 nhanh ch\u00f3ng<\/span><\/h3>\n<p>V\u1edbi \u0111\u1ecbnh ngh\u0129a h\u00e0m MID l\u00e0 g\u00ec m\u00e0 Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 gi\u1ea3i \u0111\u00e1p \u1edf ph\u1ea7n \u0111\u1ea7u th\u00ec c\u00f4ng d\u1ee5ng ch\u1ee7 y\u1ebfu c\u1ee7a n\u00f3 ch\u00ednh l\u00e0 c\u1eaft chu\u1ed7i trong Excel. Thu\u1eadt to\u00e1n n\u00e0y d\u00f9ng ph\u1ee5c v\u1ee5 cho r\u1ea5t nhi\u1ec1u c\u00f4ng vi\u1ec7c kh\u00e1c nhau. T\u1eeb ng\u01b0\u1eddi l\u00e0m kinh doanh, k\u1ebf to\u00e1n hay gi\u00e1o vi\u00ean,&#8230; \u0111\u1ec1u n\u00ean bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m n\u00e0y \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o, ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Nh\u01b0 v\u1eady, khi b\u1ea1n mu\u1ed1n l\u1ecdc b\u1ea5t k\u1ef3 k\u00fd t\u1ef1, ch\u1eef s\u1ed1 trong danh s\u00e1ch d\u1eef li\u1ec7u l\u1edbn \u0111\u1ec1u d\u1ec5 d\u00e0ng v\u00e0 kh\u00f4ng m\u1ea5t th\u1eddi gian.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286958 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12.jpg\" alt=\"cach-su-dung-ham-MID-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/cach-su-dung-ham-MID-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f9ng nhi\u1ec1u h\u00e0m kh\u00e1c \u1edf Excel<\/span><\/h3>\n<p>Trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m. M\u1ed7i h\u00e0m s\u1ebd l\u1ea1i c\u00f3 m\u1ed9t c\u00f4ng d\u1ee5ng kh\u00e1c nhau. V\u00e0 khi ch\u00fang ta k\u1ebft h\u1ee3p ch\u00fang l\u1ea1i trong c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c s\u1ebd gi\u00fap ph\u00e2n t\u00edch d\u1eef li\u1ec7u tuy\u1ec7t v\u1eddi. M\u1eb7t kh\u00e1c, \u0111\u1ed9 chu\u1ea9n x\u00e1c khi c\u1eaft chu\u1ed7i b\u1eb1ng h\u00e0m MID s\u1ebd cao h\u01a1n nhi\u1ec1u so v\u1edbi t\u1ef1 l\u00e0m th\u1ee7 c\u00f4ng. T\u1eeb \u0111\u00f3, b\u1ea1n s\u1ebd h\u1ea1n ch\u1ebf ph\u1ea7n n\u00e0o sai s\u00f3t khi l\u00e0m vi\u1ec7c.<\/p>\n<h2>L\u1eddi k\u1ebft<\/h2>\n<p>To\u00e0n b\u1ed9 b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m MID trong Excel<\/strong>. \u0110i k\u00e8m v\u1edbi \u0111o l\u00e0 nh\u1eefng v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t c\u1ee5 th\u1ec3. Hy v\u1ecdng b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng v\u00e0 bi\u1ebft c\u00e1ch c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 nhanh ch\u00f3ng. N\u1ebfu th\u1ea5y th\u00f4ng tin n\u00e0y b\u1ed5 \u00edch h\u00e3y chia s\u1ebb cho b\u1ea1n b\u00e8 ngay nh\u00e9. \u0110\u1eebng qu\u00ean truy c\u1eadp Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 \u0111\u1ecdc th\u00eam nh\u1eefng b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-search\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng chu\u1ed7i v\u0103n b\u1ea3n trong Excel, ch\u00fang ta s\u1ebd r\u1ea5t kh\u00f3 \u0111\u1ec3 t\u1ef1 ph\u00e2n t\u00e1ch d\u1eef li\u1ec7u b\u1eb1ng thao t\u00e1c th\u1ee7 c\u00f4ng. Thay v\u00e0o \u0111\u00f3, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m MID mang \u0111\u1ebfn s\u1ef1 ti\u1ec7n l\u1ee3i v\u00e0 nhanh ch\u00f3ng h\u01a1n nhi\u1ec1u. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y trong Excel [&hellip;]<\/p>\n","protected":false},"author":51,"featured_media":277230,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-277142","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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>C\u00e1ch d\u00f9ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0 tr\u00edch xu\u1ea5t n\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. T\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0 tr\u00edch xu\u1ea5t n\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. T\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/\" \/>\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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-21T12:35:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.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=\"Autumn\" \/>\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=\"Autumn\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 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\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/\"},\"author\":{\"name\":\"Autumn\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/d305515240b66d3e1c686cffa6244071\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i\",\"datePublished\":\"2023-11-21T12:35:18+00:00\",\"dateModified\":\"2023-11-21T12:35:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/\"},\"wordCount\":3120,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/\",\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg\",\"datePublished\":\"2023-11-21T12:35:18+00:00\",\"dateModified\":\"2023-11-21T12:35:18+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0 tr\u00edch xu\u1ea5t n\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. T\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-su-dung-ham-MID-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i\"}]},{\"@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\/d305515240b66d3e1c686cffa6244071\",\"name\":\"Autumn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0e7975e2174b86be067583c9c2cbd276.jpg?ver=1775469964\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0e7975e2174b86be067583c9c2cbd276.jpg?ver=1775469964\",\"caption\":\"Autumn\"},\"description\":\"M\u00ecnh l\u00e0 Thu v\u1edbi h\u01a1n 5 n\u0103m kinh nghi\u1ec7m vi\u1ebft content. M\u00ecnh y\u00eau th\u00edch vi\u1ec7c t\u00ecm hi\u1ec3u c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 xu h\u01b0\u1edbng c\u00f4ng ngh\u1ec7 m\u1edbi, sau \u0111\u00f3 chia s\u1ebb ki\u1ebfn th\u1ee9c th\u00e0nh b\u00e0i vi\u1ebft d\u01b0\u1edbi g\u00f3c nh\u00ecn tr\u1ea3i nghi\u1ec7m \u0111\u1ec3 b\u1ea1n \u0111\u1ecdc c\u00f9ng bi\u1ebft th\u00eam nhi\u1ec1u th\u00f4ng tin b\u1ed5 \u00edch.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/thu-le\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch d\u00f9ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","description":"S\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0 tr\u00edch xu\u1ea5t n\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. T\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!","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\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i","og_description":"S\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0 tr\u00edch xu\u1ea5t n\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. T\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-21T12:35:18+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg","type":"image\/jpeg"}],"author":"Autumn","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Autumn","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/"},"author":{"name":"Autumn","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/d305515240b66d3e1c686cffa6244071"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i","datePublished":"2023-11-21T12:35:18+00:00","dateModified":"2023-11-21T12:35:18+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/"},"wordCount":3120,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/","name":"C\u00e1ch d\u00f9ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg","datePublished":"2023-11-21T12:35:18+00:00","dateModified":"2023-11-21T12:35:18+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0 tr\u00edch xu\u1ea5t n\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. T\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-su-dung-ham-MID-trong-excel.jpg","width":1200,"height":628,"caption":"cach-su-dung-ham-MID-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i"}]},{"@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\/d305515240b66d3e1c686cffa6244071","name":"Autumn","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0e7975e2174b86be067583c9c2cbd276.jpg?ver=1775469964","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0e7975e2174b86be067583c9c2cbd276.jpg?ver=1775469964","caption":"Autumn"},"description":"M\u00ecnh l\u00e0 Thu v\u1edbi h\u01a1n 5 n\u0103m kinh nghi\u1ec7m vi\u1ebft content. M\u00ecnh y\u00eau th\u00edch vi\u1ec7c t\u00ecm hi\u1ec3u c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 xu h\u01b0\u1edbng c\u00f4ng ngh\u1ec7 m\u1edbi, sau \u0111\u00f3 chia s\u1ebb ki\u1ebfn th\u1ee9c th\u00e0nh b\u00e0i vi\u1ebft d\u01b0\u1edbi g\u00f3c nh\u00ecn tr\u1ea3i nghi\u1ec7m \u0111\u1ec3 b\u1ea1n \u0111\u1ecdc c\u00f9ng bi\u1ebft th\u00eam nhi\u1ec1u th\u00f4ng tin b\u1ed5 \u00edch.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/thu-le\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/277142","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\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=277142"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/277142\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/277230"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=277142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=277142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=277142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}