{"id":5800,"date":"2024-12-20T20:39:30","date_gmt":"2024-12-20T20:39:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban\/"},"modified":"2024-12-20T20:39:30","modified_gmt":"2024-12-20T20:39:30","slug":"huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1 \u1edf \u0111\u1ea7u, \u1edf gi\u1eefa, \u1edf cu\u1ed1i trong \u0111o\u1ea1n v\u0103n b\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-l\u1ea5y-k\u00fd-t\u1ef1\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban.html?ham-lay-ky-tu\">\n<p>Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd v\u0103n b\u1ea3n hay k\u00fd t\u1ef1 text trong Excel, ch\u00fang ta th\u01b0\u1eddng bi\u1ebft t\u1edbi c\u00e1c h\u00e0m nh\u01b0 LEFT, MID, RIGHT, LEN, SEARCH\u2026 Nh\u01b0ng n\u1ebfu ch\u1ec9 bi\u1ebft t\u1eebng h\u00e0m ri\u00eang l\u1ebb th\u00ec kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 kh\u00f3 \u0111\u1ec3 bi\u1ebft h\u1ebft s\u1ee9c m\u1ea1nh c\u1ee7a c\u00e1c h\u00e0m n\u00e0y. V\u1eady th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y, h\u1eb3n b\u1ea1n s\u1ebd b\u1ea5t ng\u1edd khi bi\u1ebft c\u00e1c h\u00e0m n\u00e0y k\u1ebft h\u1ee3p v\u1edbi nhau t\u1ea1o ra hi\u1ec7u qu\u1ea3 \u0111\u00e1ng kinh ng\u1ea1c th\u1ebf n\u00e0o. Nguy\u00ean l\u00fd ho\u1ea1t \u0111\u1ed9ng c\u1ee7a <strong>h\u00e0m l\u1ea5y k\u00fd t\u1ef1.<\/strong> C\u00f9ng t\u00ecm hi\u1ec3u ngay n\u00e0o.<\/p>\n<\/blockquote>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6765d601c16cd\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban.html#Cong_thuc_loc_bo_ky_tu_o_dau_doan_van_ban\" title=\"C\u00f4ng th\u1ee9c l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u0111\u1ea7u\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n\">C\u00f4ng th\u1ee9c l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u0111\u1ea7u\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban.html#Cach_loc_bo_ky_tu_o_ben_phai_cua_doan_van_ban\" title=\"C\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf b\u00ean ph\u1ea3i c\u1ee7a\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n\">C\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf b\u00ean ph\u1ea3i c\u1ee7a\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban.html#Cach_loc_bo_ky_tu_o_giua_cua_doan_van_ban\" title=\"C\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf gi\u1eefa c\u1ee7a\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n\">C\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf gi\u1eefa c\u1ee7a\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_loc_bo_ky_tu_o_dau_doan_van_ban\"><\/span>C\u00f4ng th\u1ee9c l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u0111\u1ea7u\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u1ea7n l\u1ecdc b\u1ecf c\u00e1c k\u00fd t\u1ef1 t\u1eeb d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean tr\u1edf v\u1ec1 tr\u01b0\u1edbc (s\u1ed1 k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i t\u1edbi d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean)\u00a0\u0111\u1ec3 xem\u00a0\u0111u\u00f4i c\u1ee7a c\u00e1c trang\u00a0web l\u00e0 g\u00ec:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23546\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-loc-ten-mien-second-level-domain.png\" width=\"407\" height=\"141\" title=\"yeu-cau-loc-ten-mien-second-level-domain\"><\/p>\n<p>Ph\u1ea7n k\u00fd t\u1ef1 b\u00ean tr\u00e1i tr\u01b0\u1edbc d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean kh\u00f4ng h\u1ec1 c\u1ed1\u00a0\u0111\u1ecbnh l\u00e0 bao nhi\u00eau k\u00fd t\u1ef1 ph\u1ea3i kh\u00f4ng? V\u1eady l\u00e0m sao\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u tr\u00ean?<\/p>\n<p>B\u00ed quy\u1ebft n\u1eb1m\u00a0\u1edf d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean. Ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c d\u1ea5u ch\u1ea5m n\u00e0y b\u1eb1ng h\u00e0m SEARCH.<\/p>\n<p>Ph\u1ea7n k\u1ebft qu\u1ea3 c\u1ea7n l\u1ea5y l\u00e0 s\u1ed1 k\u00fd t\u1ef1 ph\u00eda <strong>b\u00ean ph\u1ea3i<\/strong> c\u1ee7a\u00a0\u0111o\u1ea1n text, sau v\u1ecb tr\u00ed d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean tr\u1edf\u00a0\u0111i. Do\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\">h\u00e0m SEARCH<\/a> t\u00ecm v\u1ecb tr\u00ed d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean<\/li>\n<li>S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\">h\u00e0m RIGHT<\/a> v\u1edbi s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y l\u00e0 T\u1ed5ng s\u1ed1 k\u00fd t\u1ef1\u00a0\u0111o\u1ea1n text tr\u1eeb \u0111i V\u1ecb tr\u00ed d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean<\/li>\n<\/ul>\n<p>H\u00e3y xem k\u1ebft qu\u1ea3 n\u00e0o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-phan-ben-trai-bang-ham-right-len-search.png\" width=\"637\" height=\"179\" title=\"tach-phan-ben-trai-bang-ham-right-len-search\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-509.gif\" title=\"ex101_92019-nho-509\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Th\u1ee9 1: H\u00e0m SEARCH(\u201c.\u201d,A2) d\u00f9ng\u00a0\u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean trong\u00a0\u00f4 A2. D\u1ea5u ch\u1ea5m l\u00e0 1 k\u00fd t\u1ef1 text n\u00ean c\u1ea7n\u00a0\u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p. K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m SEARCH l\u00e0 s\u1ed1 v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y c\u1ee7a d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean t\u00ecm\u00a0\u0111\u01b0\u1ee3c trong\u00a0\u0111o\u1ea1n text\u00a0\u1edf\u00a0\u00f4 A2<\/li>\n<li>Th\u1ee9 2: <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\">H\u00e0m LEN<\/a>(A2)\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh t\u1ed5ng s\u1ed1\u00a0k\u00fd t\u1ef1 c\u00f3 trong\u00a0\u00f4 A2.<\/li>\n<li>Th\u1ee9 3:\u00a0LEN(A2)-SEARCH(\u201c.\u201d,A2) s\u1ebd ra k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u00f2n l\u1ea1i n\u1eb1m\u00a0\u1edf b\u00ean ph\u1ea3i d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean, kh\u00f4ng c\u00f2n t\u00ednh nh\u1eefng k\u00fd t\u1ef1 b\u00ean tr\u00e1i d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ea7u ti\u00ean n\u1eefa.\u00a0\u0110\u00e2y ch\u00ednh l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch trong\u00a0\u00f4 A2 b\u1eb1ng h\u00e0m RIGHT.<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 vi\u1ebft h\u00e0m RIGHT(A2,LEN(A2)-SEARCH(\u201c.\u201d,A2)) s\u1ebd cho ch\u00fang ta k\u1ebft qu\u1ea3\u00a0\u0111\u00fang.<\/p>\n<p>\u0110\u00e2y l\u00e0 1 trong nh\u1eefng c\u00f4ng th\u1ee9c\u00a0t\u00e1ch l\u1ecdc ph\u1ea7n k\u00fd t\u1ef1 n\u0103m b\u00ean ph\u1ea3i\u00a0\u0111o\u1ea1n text th\u01b0\u1eddng xuy\u00ean\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng (hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 x\u00f3a b\u1ecf ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a\u00a0\u0111o\u1ea1n text)<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 thay h\u00e0m SEARCH b\u1eb1ng m\u1ed9t con s\u1ed1 c\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p lu\u00f4n lu\u00f4n x\u00f3a b\u1ecf bao nhi\u00eau k\u00fd t\u1ef1 n\u1eb1m b\u00ean tr\u00e1i\u00a0\u0111o\u1ea1n text.<\/p>\n<p>Tham kh\u1ea3o th\u00eam\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m SEARCH qua b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ung-dung-ham-search-va-countifs-de-thong-ke-tinh-trang-lam-viec.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m SEARCH v\u00e0 COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea t\u00ecnh tr\u1ea1ng l\u00e0m vi\u1ec7c<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_bo_ky_tu_o_ben_phai_cua_doan_van_ban\"><\/span>C\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf b\u00ean ph\u1ea3i c\u1ee7a\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch n\u00e0y ng\u01b0\u1ee3c l\u1ea1i v\u1edbi l\u1ecdc k\u00fd t\u1ef1 b\u00ean tr\u00e1i, c\u0169ng l\u00e0 s\u1ef1 ph\u1ed1i h\u1ee3p c\u1ee7a c\u00e1c h\u00e0m LEFT, LEN, SEARCH nh\u01b0ng ph\u1ee9c t\u1ea1p h\u01a1n 1 ch\u00fat. H\u00e3y xem v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23558\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-ky-tu-ben-trai-de-bai.png\" width=\"400\" height=\"211\" title=\"loc-ky-tu-ben-trai-de-bai\"><\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 c\u00e1c ID g\u1ed3m th\u00f4ng tin T\u00ean s\u1ea3n ph\u1ea9m &amp; N\u0103m &amp; Th\u00e1ng &amp; Ng\u00e0y &amp; N\u1ed9i dung. Y\u00eau c\u1ea7u l\u00e0 c\u1ea7n t\u00e1ch l\u1ecdc ra c\u00e1c t\u00ean s\u1ea3n ph\u1ea9m trong t\u1eebng ID.<\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh l\u00e0 3 hay 4 k\u00fd t\u1ef1, m\u00e0 thay\u00a0\u0111\u1ed5i theo t\u1eebng ID. C\u0103n c\u1ee9\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 k\u00e9o d\u00e0i t\u1edbi tr\u01b0\u1edbc con s\u1ed1 2018 (hay s\u1ed1 2\u00a0\u0111\u1ea7u ti\u00ean trong chu\u1ed7i)<\/p>\n<p>\u0110\u1ed9 d\u00e0i\u00a0\u0111o\u1ea1n text c\u1ea7n l\u1ecdc = Ph\u1ea7n ph\u00eda tr\u01b0\u1edbc v\u1ecb tr\u00ed s\u1ed1 2018 = SEARCH(\u201c2018\u201d,A2)-1<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23565\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-su-dung-ham-tach-ky-tu-ben-phai-02.png\" width=\"597\" height=\"257\" title=\"ket-qua-su-dung-ham-tach-ky-tu-ben-phai-02\"><\/p>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_bo_ky_tu_o_giua_cua_doan_van_ban\"><\/span>C\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1\u00a0\u1edf gi\u1eefa c\u1ee7a\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u1eafc\u00a0\u0111\u1ebfn k\u00fd t\u1ef1\u00a0\u1edf gi\u1eefa\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n, ch\u00fang ta th\u01b0\u1eddng ngh\u0129 t\u1edbi h\u00e0m MID. Nh\u01b0ng h\u00e0m n\u00e0y ch\u1ec9\u00a0\u0111\u01a1n gi\u1ea3n l\u00e0 \u201cX\u00e1c\u00a0\u0111\u1ecbnh k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa trong chu\u1ed7i text\u201d. V\u1eady n\u00ean vi\u1ec7c l\u1ecdc b\u1ecf nh\u1eefng k\u00fd t\u1ef1 n\u00e0y bao g\u1ed3m b\u1ea1n ph\u1ea3i c\u1eaft\u00a0\u0111o\u1ea1n text g\u1ed1c th\u00e0nh 3 ph\u1ea7n, lo\u1ea1i b\u1ecf ph\u1ea7n\u00a0\u1edf gi\u1eefa\u00a0\u0111i, sau\u00a0\u0111\u00f3 n\u1ed1i\u00a0\u0111o\u1ea1n\u00a0\u0111\u1ea7u v\u00e0\u00a0\u0111o\u1ea1n cu\u1ed1i l\u1ea1i v\u1edbi nhau. V\u1ea5n\u00a0\u0111\u1ec1 l\u00e0 ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0110o\u1ea1n\u00a0\u0111\u1ea7u v\u00e0\u00a0\u0110o\u1ea1n cu\u1ed1i nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<p>H\u00e3y xem v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23564\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bo-ngay-trong-doan-text.png\" width=\"402\" height=\"214\" title=\"bo-ngay-trong-doan-text\"><\/p>\n<p>Y\u00eau c\u1ea7u l\u00e0 ch\u00fang ta c\u1ea7n l\u1ea5y n\u1ed9i dung ID nh\u01b0ng b\u1ecf\u00a0\u0111i c\u00e1c con s\u1ed1 th\u1ec3 hi\u1ec7n th\u1eddi gian (n\u0103m + th\u00e1ng + ng\u00e0y), t\u1ed5ng c\u1ed9ng l\u00e0 8 k\u00fd t\u1ef1.<\/p>\n<p>V\u1eady trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>Ph\u1ea7n\u00a0\u0111o\u1ea1n text c\u1ea7n b\u1ecf\u00a0\u0111i: 8 k\u00fd t\u1ef1. B\u1eaft\u00a0\u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed h\u00e0m SEARCH(\u201c2018\u201d,A2), k\u1ebft th\u00fac v\u1edbi v\u1ecb tr\u00ed\u00a0SEARCH(\u201c2018\u201d,A2)+8-1<\/li>\n<li>Ph\u1ea7n b\u00ean tr\u00e1i: T\u1eeb k\u00fd t\u1eeb\u00a0\u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i t\u1edbi tr\u01b0\u1edbc v\u1ecb tr\u00ed\u00a0SEARCH(\u201c2018\u201d,A2)<\/li>\n<li>Ph\u1ea7n b\u00ean ph\u1ea3i: T\u1eeb k\u00fd t\u1ef1\u00a0\u0111\u1ea7u ti\u00ean b\u00ean ph\u1ea3i t\u1edbi sau v\u1ecb tr\u00ed\u00a0SEARCH(\u201c2018\u201d,A2)+8-1<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23566\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-loc-bo-gia-tri-o-giua.png\" width=\"633\" height=\"282\" title=\"ket-qua-loc-bo-gia-tri-o-giua\"><\/p>\n<p>N\u1ebfu kh\u00f4ng d\u00f9ng 2 c\u1ed9t C v\u00e0 D, ch\u00fang ta c\u00f3 th\u1ec3 l\u1ed3ng gh\u00e9p c\u00f4ng th\u1ee9c t\u1ea1i c\u00e1c c\u1ed9t n\u00e0y v\u00e0o trong c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 B2 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23567\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tong-hop-loc-bo-text-nam-giua.png\" width=\"1065\" height=\"76\" title=\"cong-thuc-tong-hop-loc-bo-text-nam-giua\"><\/p>\n<p>Nh\u00ecn kh\u00e1 d\u00e0i ph\u1ea3i kh\u00f4ng n\u00e0o. Nh\u01b0ng v\u00ec ch\u00fang ta\u00a0\u0111\u00e3 hi\u1ec3u b\u1ea3n ch\u1ea5t n\u00ean c\u0169ng kh\u00f4ng kh\u00f3\u00a0\u0111\u1ec3 vi\u1ebft ra c\u00f4ng th\u1ee9c n\u00e0y.<\/p>\n<p>Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y\u00a0\u0111\u01b0\u1ee3c vi\u1ec7c\u00a0\u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m trong\u00a0Excel di\u1ec5n ra nh\u01b0 th\u1ebf n\u00e0o. Th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c kh\u00f4ng ph\u1ea3i\u00a0\u0111\u01a1n gi\u1ea3n nh\u01b0 khi ch\u00fang ta h\u1ecdc, m\u00e0 n\u00f3 c\u1ea7n\u00a0\u0111\u01b0\u1ee3c ph\u00e2n t\u00edch, l\u00e0m r\u00f5 t\u00ednh logic tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 l\u00e0 qu\u00e1 tr\u00ecnh k\u1ebft h\u1ee3p c\u00e1c h\u00e0m\u00a0\u0111\u00e3 h\u1ecdc l\u1ea1i v\u1edbi nhau\u00a0\u0111\u1ec3 x\u1eed l\u00fd t\u1eebng b\u01b0\u1edbc, khi\u00a0\u0111\u00f3 m\u1edbi cho ch\u00fang ta k\u1ebft qu\u1ea3\u00a0\u0111\u00fang.<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-509.gif\" title=\"ex101_92019-nho-509\"><br \/>\n<\/a><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7 \u0111\u1ec1 sau \u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m LEFT trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-mid.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m mid<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumifs k\u1ebft h\u1ee3p h\u00e0m vlookup trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-509.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5801,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5800"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5800\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5801"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}