{"id":10908,"date":"2022-10-06T18:29:58","date_gmt":"2022-10-06T11:29:58","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10908"},"modified":"2022-11-03T13:38:29","modified_gmt":"2022-11-03T06:38:29","slug":"ham-mid-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/","title":{"rendered":"H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;10908&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (3 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh nh\u1eefng h\u00e0m t\u00ednh to\u00e1n trong Excel qu\u00e1 \u0111\u1ed7i quen thu\u1ed9c nh\u01b0 SUM, If, Max, Min,&#8230; Th\u00ec c\u0169ng c\u00f3 nh\u1eefng h\u00e0m t\u00ednh xa l\u1ea1 h\u01a1n, song l\u1ea1i mang \u0111\u1ebfn ti\u1ec7n \u00edch s\u1eed d\u1ee5ng tuy\u1ec7t v\u1eddi t\u1ed1i \u01b0u. V\u00e0 h\u00e0m MID c\u0169ng ch\u00ednh l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p nh\u01b0 b\u1ea1n. B\u1ea1n \u0111\u1ecdc \u0111ang t\u00f2 m\u00f2 mu\u1ed1n t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 h\u00e0m MID? <\/span><\/i><b><i>H\u00e0m MID trong Excel<\/i><\/b><i><span style=\"font-weight: 400;\"> s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, c\u00f3 \u0111\u01a1n gi\u1ea3n kh\u00f4ng? Teky s\u1ebd mang \u0111\u1ebfn \u0111\u1ea7y \u0111\u1ee7 v\u00e0 chi ti\u1ebft th\u00f4ng tin gi\u1ea3i \u0111\u00e1p d\u00e0nh cho b\u1ea1n \u0111\u1ecdc \u0111\u1ec3 gi\u00fap b\u1ea1n \u0111\u1ecdc \u00e1p d\u1ee5ng th\u00e0nh th\u1ea1o.<\/span><\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Ham_MID_la_gi_Cong_dung_cua_ham_MID_khi_su_dung_trong_Excel_ra_sao\" >H\u00e0m MID l\u00e0 g\u00ec? C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m MID khi s\u1eed d\u1ee5ng trong Excel ra sao?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Vay_ham_MID_la_gi\" >V\u1eady h\u00e0m MID l\u00e0 g\u00ec?\u00a0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Ham_MID_trong_Excel_su_dung_nhu_the_nao\" >H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Ham_MID_trong_Excel_su_dung_mot_minh\" >H\u00e0m MID trong Excel s\u1eed d\u1ee5ng m\u1ed9t m\u00ecnh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Ham_MID_ket_hop_LEN\" >H\u00e0m MID k\u1ebft h\u1ee3p LEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Ham_MID_trong_Excel_ket_hop_SEARCH\" >H\u00e0m MID trong Excel k\u1ebft h\u1ee3p SEARCH<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#Tong_ket_chung\" >T\u1ed5ng k\u1ebft chung<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_MID_la_gi_Cong_dung_cua_ham_MID_khi_su_dung_trong_Excel_ra_sao\"><\/span><b>H\u00e0m MID l\u00e0 g\u00ec? C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m MID khi s\u1eed d\u1ee5ng trong Excel ra sao?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft, trong Excel c\u00f3 v\u00f4 s\u1ed1 h\u00e0m t\u00ednh to\u00e1n nh\u1eb1m h\u1ed7 tr\u1ee3 cho vi\u1ec7c th\u1ef1c hi\u1ec7n b\u1ea3ng bi\u1ec3u, s\u1ed1 li\u1ec7u tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u01a1n. B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i lo t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u m\u00e0 thay v\u00e0o \u0111\u00f3 ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n. \u0110\u1eb7c bi\u1ec7t l\u00e0 \u0111\u1ed9 ch\u00ednh x\u00e1c l\u1ea1i c\u00f2n c\u1ef1c k\u1ef3 cao, g\u1ea7n nh\u01b0 l\u00e0 tuy\u1ec7t \u0111\u1ed1i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00ednh v\u00ec th\u1ebf n\u00ean khi s\u1eed d\u1ee5ng Excel hi\u1ec7n nay, h\u1ea7u h\u1ebft t\u1ea5t c\u1ea3 m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u t\u1eadn d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n. V\u00ed d\u1ee5 nh\u01b0 \u0111\u1ec3 t\u00ednh t\u1ed5ng th\u00ec d\u00f9ng h\u00e0m SUM, t\u00ednh trung b\u00ecnh th\u00ec d\u00f9ng h\u00e0m Average. C\u00f2n t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t hay nh\u1ecf nh\u1ea5t th\u00ec d\u00f9ng b\u1ed9 \u0111\u00f4i h\u00e0m Max\/Min.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00e0 b\u00ean c\u1ea1nh \u0111\u00f3, c\u00f2n c\u00f3 m\u1ed9t h\u00e0m \u00edt \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng h\u01a1n nh\u01b0ng l\u1ea1i v\u00f4 c\u00f9ng thi\u1ebft y\u1ebfu &#8211; \u0110\u00f3 ch\u00ednh l\u00e0 h\u00e0m MID.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT, RIGHT, MID \u0111\u1ec3 l\u1ea5y k\u00fd t\u1ef1 trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/tGOO0U1L2i4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vay_ham_MID_la_gi\"><\/span><b><i>V\u1eady h\u00e0m MID l\u00e0 g\u00ec?\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MID l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1. V\u1ec1 c\u00f4ng d\u1ee5ng, <\/span><b>h\u00e0m MID trong Excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c d\u00f9ng \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. Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 g\u1ed1c ban \u0111\u1ea7u. Hay c\u00f3 th\u1ec3 hi\u1ec3u l\u00e0 tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con t\u1eeb chu\u1ed7i k\u00fd t\u1ef1 m\u1eb9.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c h\u00e0m MID th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t t\u00ean\/h\u1ecd ho\u1eb7c m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 trong c\u00e2u. \u0110i\u1ec1u n\u00e0y kh\u00e1 thu\u1eadn l\u1ee3i cho b\u1ea1n v\u00ec s\u1eed d\u1ee5ng 1 c\u00f4ng th\u1ee9c h\u00e0m l\u00e0 \u0111\u00e3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m s\u1ed1 li\u1ec7u kh\u00e1c nhau. Ti\u1ebft ki\u1ec7m th\u1eddi gian m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3 v\u00e0 c\u0169ng h\u1ea1n ch\u1ebf nh\u1eefng sai s\u00f3t trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n. V\u00e0 \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MID th\u00ec c\u0169ng c\u1ea7n bi\u1ebft m\u1ed9t s\u1ed1 th\u00f4ng tin li\u00ean quan \u0111\u1ebfn c\u00e1ch s\u1eed d\u1ee5ng. C\u1ee5 th\u1ec3 ra sao s\u1ebd \u0111\u01b0\u1ee3c cung c\u1ea5p \u1edf ph\u1ea7n k\u1ebf ti\u1ebfp!<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_MID_trong_Excel_su_dung_nhu_the_nao\"><\/span><b>H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n t\u00f2 m\u00f2 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m MID? Li\u1ec7u kh\u00f3 hay d\u1ec5? H\u00e0m MID li\u1ec7u c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam v\u1edbi h\u00e0m t\u00ednh to\u00e1n n\u00e0o kh\u00f4ng? Th\u1ef1c t\u1ebf th\u00ec h\u00e0m MID t\u01b0\u01a1ng \u0111\u1ed1i d\u1ec5 s\u1eed d\u1ee5ng. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay sau \u0111\u00e2y, t\u1eeb d\u1ec5 \u0111\u1ebfn kh\u00f3 v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi m\u1ecdi phi\u00ean b\u1ea3n Excel 2010, 2013, 2016, 2018,&#8230;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3, <\/span><b>h\u00e0m MID trong Excel <\/b><span style=\"font-weight: 400;\">c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau: = MID(text, start_num, num_chars)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3 c\u00f3 th\u1ec3 gi\u1ea3i ngh\u0129a nh\u01b0 sau: MID l\u00e0 t\u00ean h\u00e0m. Text l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n t\u00e1ch (g\u1ed1c). Start_num l\u00e0 v\u1ecb tr\u00ed c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t ra t\u1eeb v\u0103n b\u1ea3n g\u1ed1c. C\u00f2n num_chars l\u1ea1i l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t ra t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Ham_MID_trong_Excel_su_dung_mot_minh\"><\/span><b><i>H\u00e0m MID trong Excel s\u1eed d\u1ee5ng m\u1ed9t m\u00ecnh<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 nh\u01b0 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 ABCHNA \u1edf \u00f4 B2. B\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t ra \u201cCHN\u201d t\u1eeb chu\u1ed7i k\u00fd t\u1ef1 n\u00e0y. Nh\u01b0 v\u1eady, c\u00f4ng th\u1ee9c MID b\u1ea1n s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">= MID(B2,3,3). C\u00f3 ngh\u0129a l\u00e0 l\u1ea5y 3 k\u00fd t\u1ef1 t\u1eeb chu\u1ed7i k\u00fd t\u1ef1 \u1edf \u00f4 B2, b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 3. T\u1ee9c l\u00e0 \u201cCHN\u201d. V\u00e0 \u1edf \u0111\u00e2y \u0111\u00e1p \u00e1n s\u1ebd l\u00e0 \u201cCHN\u201d \u1edf \u00f4 s\u1eed d\u1ee5ng h\u00e0m. C\u1ee5 th\u1ec3 h\u01a1n b\u1ea1n c\u00f3 th\u1ec3 h\u00ecnh dung trong nh\u1eefng h\u00ecnh \u1ea3nh h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_10910\" aria-describedby=\"caption-attachment-10910\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10910 size-medium\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-1-400x207.jpg\" alt=\"ham-mid-trong-excel-1\" width=\"400\" height=\"207\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-1-400x207.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-1.jpg 610w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10910\" class=\"wp-caption-text\">H\u00e0m mid trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n ch\u1ecdn v\u00e0o \u00f4 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m. Sau \u0111\u00f3 g\u00f5 \u201c=MID(\u201d. Ti\u1ebfp \u0111\u00f3 l\u00e0 ch\u1ecdn v\u00e0o \u00f4 B2 l\u00e0 \u00f4 c\u1ea7n tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 ra. G\u00f5 3, 3 theo h\u00ecnh b\u1edfi v\u00ec c\u1ea7n tr\u00edch xu\u1ea5t 3 k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 3.\u00a0<\/span><\/p>\n<figure id=\"attachment_10911\" aria-describedby=\"caption-attachment-10911\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10911\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-2-400x207.jpg\" alt=\"ham-mid-trong-excel-2\" width=\"400\" height=\"207\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-2-400x207.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-2.jpg 610w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10911\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 nh\u1eadn l\u1ea1i s\u1ebd l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 con \u201cCHN\u201d t\u1eeb chu\u1ed7i k\u00fd t\u1ef1 m\u1eb9 \u201cABCHNA\u201d<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1ebd t\u1eadn d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 s\u1eed d\u1ee5ng tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 cho nh\u1eefng s\u1ea3n ph\u1ea9m ti\u1ebfp theo. C\u1ee5 th\u1ec3 l\u00e0 b\u1ea1n di chu\u1ed9t v\u1ec1 \u00f4 C2. Sau \u0111\u00f3 \u0111\u1ec3 \u1edf v\u1ecb tr\u00ed g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 v\u00e0 ti\u1ebfn h\u00e0nh k\u00e9o r\u00ea chu\u1ed9t cho \u0111\u1ebfn \u00f4 C5. V\u00e0 k\u1ebft qu\u1ea3 nh\u1eadn l\u1ea1i s\u1ebd nh\u01b0 h\u00ecnh \u1ea3nh \u1edf tr\u00ean. <\/span><\/p>\n<figure id=\"attachment_10912\" aria-describedby=\"caption-attachment-10912\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10912\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-3-400x207.jpg\" alt=\"ham-mid-trong-excel-3\" width=\"400\" height=\"207\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-3-400x207.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-3.jpg 610w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10912\" class=\"wp-caption-text\">\u0110\u00e1p \u00e1n \u0111\u1ea3m b\u1ea3o ch\u00ednh x\u00e1c, nhanh ch\u00f3ng nh\u1edd vi\u1ec7c ch\u1ec9 d\u00f9ng 1 l\u1ea7n h\u00e0m cho t\u1ea5t c\u1ea3.<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng v\u1edbi nh\u1eefng c\u00f4ng \u0111o\u1ea1n tr\u00ean th\u00ec <\/span><b>h\u00e0m MID trong Excel<\/b><span style=\"font-weight: 400;\"> kh\u00e1 d\u1ec5 s\u1eed d\u1ee5ng. Song ngo\u00e0i c\u00e1ch d\u00f9ng c\u0103n b\u1ea3n \u1edf tr\u00ean th\u00ec ng\u01b0\u1eddi ta c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <\/span><i><span style=\"font-weight: 400;\">h\u00e0m MID k\u1ebft h\u1ee3p LEN<\/span><\/i><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Ham_MID_ket_hop_LEN\"><\/span><b><i>H\u00e0m MID k\u1ebft h\u1ee3p LEN<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN v\u1ed1n d\u0129 l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1. N\u00f3 \u0111\u1ebfm m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng v\u00e0 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3. V\u00e0 b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID m\u1ed9t c\u00e1ch linh ho\u1ea1t. V\u00ed d\u1ee5 c\u1ea7n l\u1ea5y k\u00fd t\u1ef1 th\u1ee9 3 v\u00e0 th\u1ee9 4 trong M\u00e3 SV \u0111\u1ec3 nh\u1eadp v\u00e0o c\u1ed9t S\u1ed1. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_10913\" aria-describedby=\"caption-attachment-10913\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10913\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-4-400x203.jpg\" alt=\"ham-mid-trong-excel-4\" width=\"400\" height=\"203\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-4-400x203.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-4.jpg 610w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10913\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh n\u00e0y gi\u00fap b\u1ea1n \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<figure id=\"attachment_10914\" aria-describedby=\"caption-attachment-10914\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10914\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5-400x203.jpg\" alt=\"ham-mid-trong-excel-5\" width=\"400\" height=\"203\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5-400x203.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg 610w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10914\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng khi s\u1eed d\u1ee5ng h\u00e0m MID k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEN<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Ham_MID_trong_Excel_ket_hop_SEARCH\"><\/span><strong><i>H\u00e0m<\/i><\/strong><b><i> MID<\/i><\/b><strong><i> tron<\/i><i>g<\/i><\/strong><b><i> Excel k\u1ebft h\u1ee3p SEARCH<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEN ra th\u00ec h\u00e0m MID c\u00f2n k\u1ebft h\u1ee3p \u0111\u01b0\u1ee3c v\u1edbi h\u00e0m SEARCH. H\u00e0m SEARCH l\u00e0 h\u00e0m t\u00ednh to\u00e1n gi\u00fap b\u1ea1n b\u1ecf \u0111i d\u1ea5u c\u00e1ch trong chu\u1ed7i k\u00fd t\u1ef1 khi x\u00e9t. C\u1ee5 th\u1ec3 v\u00ed d\u1ee5 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong danh s\u00e1ch h\u1ecdc sinh c\u1ee7a l\u1edbp, b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t h\u1ecd c\u1ee7a c\u00e1c th\u00e0nh vi\u00ean ra th\u00e0nh m\u1ed9t c\u1ed9t ri\u00eang. B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 sau: = MID(A2,1,SEARCH(\u201d\u201c,A2)-1). H\u00e0m n\u00e0y c\u00f3 ngh\u0129a l\u00e0 x\u00e9t chu\u1ed7i k\u00fd t\u1ef1 \u1edf \u00f4 A2. B\u1ecf m\u1ed9t k\u00fd t\u1ef1 l\u1ea5y 1 k\u00fd t\u1ef1 v\u00e0 b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 nh\u1ea5t. C\u1ee5 th\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o h\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_10916\" aria-describedby=\"caption-attachment-10916\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10916\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-6-400x203.jpg\" alt=\"ham-mid-trong-excel-6\" width=\"400\" height=\"203\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-6-400x203.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-6.jpg 610w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10916\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m MID k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SEARCH<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng m\u1ed9t m\u00ecnh th\u00ec<\/span><b> h\u00e0m MID trong Excel <\/b><span style=\"font-weight: 400;\">c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng chung v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c. Trong \u0111\u00f3 c\u00f3 h\u00e0m LEN, SEARCH,&#8230; B\u1ea1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng ch\u00fang \u0111\u1ec3 d\u1ec5 d\u00e0ng h\u01a1n trong vi\u1ec7c tinh to\u00e1n s\u1ed1 li\u1ec7u cho b\u1ea3ng t\u00ednh. Tr\u00e1nh nh\u1eefng sai s\u00f3t c\u01a1 b\u1ea3n.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tong_ket_chung\"><\/span><b>T\u1ed5ng k\u1ebft chung<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00f3m l\u1ea1i, v\u1edbi nh\u1eefng th\u00f4ng tin cung c\u1ea5p tr\u00ean v\u1ec1 h\u00e0m MID c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m MID trong Excel<\/b><span style=\"font-weight: 400;\"> ch\u1eafc h\u1eb3n \u0111\u00e3 gi\u00fap b\u1ea1n n\u1eafm r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y. H\u00e0m n\u00e0y chuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 trong chu\u1ed7i k\u00fd t\u1ef1 ban \u0111\u1ea7u khi c\u1ea7n thi\u1ebft. \u0110\u1ea3m b\u1ea3o nhanh ch\u00f3ng, ti\u1ec7n l\u1ee3i v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t x\u1ea3y ra. V\u00ed d\u1ee5 nh\u01b0 tr\u00edch 2 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean \u0111\u1ec3 l\u00e0m m\u00e3 s\u1ea3n ph\u1ea9m, tr\u00edch xu\u1ea5t h\u1ecd v\u00e0 t\u00ean c\u1ee7a c\u00e1c th\u00e0nh vi\u00ean,&#8230;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ea3m \u01a1n b\u1ea1n \u0111\u1ecdc v\u00ec \u0111\u00e3 theo d\u00f5i nh\u1eefng th\u00f4ng tin c\u1ee7a Teky v\u1ec1 <\/span><b>h\u00e0m MID trong Excel <\/b><span style=\"font-weight: 400;\">tr\u00ean. Mong r\u1eb1ng nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean s\u1ebd c\u00f3 \u00edch \u0111\u1ed1i v\u1edbi b\u1ea1n khi s\u1eed d\u1ee5ng Excel trong l\u0129nh v\u1ef1c h\u00e0nh ch\u00ednh v\u0103n ph\u00f2ng hi\u1ec7n nay. C\u0169ng nh\u01b0 trong h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c. H\u00e3y \u0111\u00f3n \u0111\u1ecdc nh\u1eefng chuy\u00ean m\u1ee5c ti\u1ebfp theo c\u1ee7a ch\u00fang t\u00f4i v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n kh\u00e1c trong Excel nh\u00e9! <\/span><span style=\"font-weight: 400;\">Ch\u00fang t\u00f4i tin r\u1eb1ng ch\u00fang s\u1ebd th\u1ef1c s\u1ef1 c\u00f3 \u00edch \u0111\u1ed1i v\u1edbi b\u1ea1n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>B\u00ean c\u1ea1nh nh\u1eefng h\u00e0m t\u00ednh to\u00e1n trong Excel qu\u00e1 \u0111\u1ed7i quen thu\u1ed9c nh\u01b0 SUM, If, Max, Min,&#8230; Th\u00ec c\u0169ng c\u00f3 nh\u1eefng h\u00e0m t\u00ednh xa l\u1ea1 h\u01a1n, song l\u1ea1i mang \u0111\u1ebfn ti\u1ec7n \u00edch s\u1eed d\u1ee5ng tuy\u1ec7t v\u1eddi t\u1ed1i \u01b0u. V\u00e0 h\u00e0m MID c\u0169ng ch\u00ednh l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p nh\u01b0 b\u1ea1n. B\u1ea1n \u0111\u1ecdc \u0111ang t\u00f2 m\u00f2 mu\u1ed1n &hellip;<\/p>\n","protected":false},"author":3,"featured_media":10914,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-10908","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tham kh\u1ea3o nhanh: H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/title>\n<meta name=\"description\" content=\"H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 g\u00ec? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Teky t\u00ecm hi\u1ec3u chi ti\u1ebft ngay sau \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:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tham kh\u1ea3o nhanh: H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 g\u00ec? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Teky t\u00ecm hi\u1ec3u chi ti\u1ebft ngay sau \u0111\u00e2y\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-06T11:29:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-03T06:38:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"610\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o\",\"datePublished\":\"2022-10-06T11:29:58+00:00\",\"dateModified\":\"2022-11-03T06:38:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\"},\"wordCount\":2054,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\",\"name\":\"Tham kh\u1ea3o nhanh: H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg\",\"datePublished\":\"2022-10-06T11:29:58+00:00\",\"dateModified\":\"2022-11-03T06:38:29+00:00\",\"description\":\"H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 g\u00ec? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Teky t\u00ecm hi\u1ec3u chi ti\u1ebft ngay sau \u0111\u00e2y\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg\",\"width\":610,\"height\":310,\"caption\":\"K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng khi s\u1eed d\u1ee5ng h\u00e0m MID k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEN\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tham kh\u1ea3o nhanh: H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?","description":"H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 g\u00ec? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Teky t\u00ecm hi\u1ec3u chi ti\u1ebft ngay sau \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:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Tham kh\u1ea3o nhanh: H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?","og_description":"H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 g\u00ec? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Teky t\u00ecm hi\u1ec3u chi ti\u1ebft ngay sau \u0111\u00e2y","og_url":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-10-06T11:29:58+00:00","article_modified_time":"2022-11-03T06:38:29+00:00","og_image":[{"width":610,"height":310,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o","datePublished":"2022-10-06T11:29:58+00:00","dateModified":"2022-11-03T06:38:29+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/"},"wordCount":2054,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/","name":"Tham kh\u1ea3o nhanh: H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg","datePublished":"2022-10-06T11:29:58+00:00","dateModified":"2022-11-03T06:38:29+00:00","description":"H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 g\u00ec? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Teky t\u00ecm hi\u1ec3u chi ti\u1ebft ngay sau \u0111\u00e2y","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-mid-trong-excel-5.jpg","width":610,"height":310,"caption":"K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng khi s\u1eed d\u1ee5ng h\u00e0m MID k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEN"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-mid-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m MID trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10908"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10908\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10914"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}