{"id":2628,"date":"2024-12-02T08:15:13","date_gmt":"2024-12-02T08:15:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-find-va-search-voi-cac-cong-thuc-vi-du\/"},"modified":"2024-12-02T08:15:13","modified_gmt":"2024-12-02T08:15:13","slug":"ham-find-va-search-voi-cac-cong-thuc-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-find-va-search-voi-cac-cong-thuc-vi-du\/","title":{"rendered":"H\u00e0m FIND v\u00e0 SEARCH v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, <a href=\"http:\/\/blog.ezworkapp.com\"><strong>Ho\u0323c Excel Online<\/strong><\/a> se\u0303 h\u01b0\u1edbng d\u1eabn n\u00e0y gi\u1ea3i th\u00edch c\u00fa ph\u00e1p c\u1ee7a <strong>h\u00e0m FIND v\u00e0 SEARCH<\/strong> v\u00e0 \u0111\u01b0a ra c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c r\u1ea5t h\u1eefu \u00edch trong c\u00f4ng vi\u1ec7c. Na\u0300o ha\u0303y cu\u0300ng ti\u0300m hi\u00ea\u0309u nhe\u0301.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d6c90a658d\" 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\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html#Ham_FIND\" title=\"H\u00e0m FIND:\">H\u00e0m FIND:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html#Ham_FIND_%E2%80%93_nhung_dieu_can_nho\" title=\"H\u00e0m FIND \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb!\">H\u00e0m FIND \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb!<\/a><\/li>\n<\/ul>\n<\/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\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html#Ham_SEARCH_trong_Excel\" title=\"H\u00e0m SEARCH trong Excel:\">H\u00e0m SEARCH trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html#So_sanh_FIND_voi_SEARCH\" title=\"So s\u00e1nh FIND v\u1edbi SEARCH:\">So s\u00e1nh FIND v\u1edbi SEARCH:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html#Cac_vi_du_ve_cong_thuc_FIND_va_SEARCH\" title=\"C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c FIND v\u00e0 SEARCH:\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c FIND v\u00e0 SEARCH:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_FIND\"><\/span><strong>H\u00e0m FIND:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m FIND trong Excel l\u00e0 <strong>h\u00e0m d\u00f2 t\u00ecm k\u00fd t\u1ef1 trong excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 hay chu\u1ed7i ph\u1ee5 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Find nh\u01b0 sau:<\/p>\n<p><strong><code class=\"excel-formula-inline\">FIND (find_text, within_text, [start_num])<\/code><\/strong><\/p>\n<p>Hai \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, cu\u1ed1i c\u00f9ng l\u00e0 t\u00f9y ch\u1ecdn.<\/p>\n<ul>\n<li><strong>Find_text<\/strong>\u00a0\u2013 k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i ph\u1ee5 b\u1ea1n mu\u1ed1n t\u00ecm.<\/li>\n<li><strong>Within_text<\/strong>\u00a0\u2013 chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm.\u00a0Th\u00f4ng th\u01b0\u1eddng n\u00f3 \u0111\u01b0\u1ee3c xem nh\u01b0 m\u1ed9t \u00f4 tham chi\u1ebfu, nh\u01b0ng b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 g\u00f5 chu\u1ed7i tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Start_num<\/strong>\u00a0\u2013 m\u1ed9t \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 m\u00e0 b\u1ea1n b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm.\u00a0N\u1ebfu kh\u00f4ng nh\u1eadp, Excel s\u1ebd t\u00ecm ki\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb\u00a0k\u00fd t\u1ef1 th\u1ee9 nh\u1ea5t c\u1ee7a chu\u1ed7i <strong>Within_text<\/strong>.<\/li>\n<\/ul>\n<p>N\u1ebfu h\u00e0m FIND kh\u00f4ng t\u00ecm th\u1ea5y k\u00fd t\u1ef1 find_text, Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/p>\n<p>V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c\u00a0<code class=\"excel-formula-inline\"><strong>=FIND(\"d\", \"find\") <\/strong><\/code>tr\u1ea3 v\u1ec1 4 v\u00ec \u201cd\u201d l\u00e0\u00a0k\u00fd t\u1ef1 th\u1ee9 4\u00a0trong t\u1eeb \u201d\u00a0<em>find<\/em>\u00a0\u201c.\u00a0C\u00f4ng th\u1ee9c\u00a0<strong><code class=\"excel-formula-inline\">=FIND(\"a\", \"find\")<\/code><\/strong> tr\u1ea3 v\u1ec1 l\u1ed7i v\u00ec kh\u00f4ng c\u00f3 \u201ca\u201d trong \u201d\u00a0<em>find<\/em>\u00a0\u201c.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-85.gif\" title=\"vba101_92019-nho-85\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-203.gif\" title=\"ex101_92019-nho-203\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Excel FIND function\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-function.png\" alt=\"Excel FIND function\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FIND_%E2%80%93_nhung_dieu_can_nho\"><\/span><strong>H\u00e0m FIND \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c FIND \u2013 h\u00e0m d\u00f2 t\u00ecm k\u00fd t\u1ef1 trong excel, h\u00e3y ghi nh\u1edb nh\u1eefng \u0111i\u1ec1u \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:<\/p>\n<ul>\n<li>H\u00e0m FIND <strong>ph\u00e2n\u00a0bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/strong>\u00a0.<\/li>\n<li>H\u00e0m FIND trong Excel kh\u00f4ng cho ph\u00e9p s\u1eed d\u1ee5ng\u00a0<strong>k\u00fd t\u1ef1 <\/strong><strong>thay th\u1ebf<\/strong>\u00a0.<\/li>\n<li>N\u1ebfu \u0111\u1ed1i s\u1ed1 find_text ch\u1ee9a nhi\u1ec1u k\u00fd t\u1ef1, h\u00e0m FIND s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a\u00a0<strong>k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean<\/strong>\u00a0.\u00a0V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c FIND (\u201cap\u201d, \u201chappy\u201d) tr\u1ea3 v\u1ec1 2 v\u00ec \u201ca\u201d l\u00e0 k\u00fd t\u1ef1 th\u1ee9 hai trong t\u1eeb \u201d happy\u201d.<\/li>\n<li>N\u1ebfu trong ph\u1ea7n within_text\u00a0ch\u1ee9a\u00a0<strong>nhi\u1ec1u l\u1ea7n xu\u1ea5t hi\u1ec7n<\/strong>\u00a0c\u1ee7a\u00a0t\u1ec7p tin\u00a0find_text, l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.\u00a0V\u00ed d\u1ee5, FIND (\u201cl\u201d, \u201chello\u201d) tr\u1ea3 v\u1ec1 3, l\u00e0 v\u1ecb tr\u00ed c\u1ee7a ch\u1eef \u201cl\u201d \u0111\u1ea7u ti\u00ean trong t\u1eeb \u201chello\u201d.<\/li>\n<li>N\u1ebfu find_text l\u00e0 m\u1ed9t\u00a0<strong>chu\u1ed7i tr\u1ed1ng<\/strong>\u00a0\u201c\u201d, c\u00f4ng th\u1ee9c FIND Excel tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i t\u00ecm ki\u1ebfm.<\/li>\n<li>H\u00e0m FIND c\u1ee7a Excel tr\u1ea3 v\u1ec1\u00a0<strong>#VALUE!\u00a0<\/strong> n\u1ebfu x\u1ea3y ra b\u1ea5t k\u1ef3 tr\u01b0\u1eddng h\u1ee3p n\u00e0o sau \u0111\u00e2y:\n<ul>\n<li>Find_text kh\u00f4ng t\u1ed3n t\u1ea1i trong within_text.<\/li>\n<li>Start_num ch\u1ee9a nhi\u1ec1u k\u00fd t\u1ef1 h\u01a1n \u00a0within_text.<\/li>\n<li>Start_num l\u00e0 0 (kh\u00f4ng) ho\u1eb7c m\u1ed9t s\u1ed1 \u00e2m.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SEARCH_trong_Excel\"><\/span><strong>H\u00e0m SEARCH trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m SEARCH trong Excel r\u1ea5t gi\u1ed1ng v\u1edbi h\u00e0m FIND \u1edf ch\u1ed7 n\u00f3 c\u0169ng tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t chu\u1ed7i ph\u1ee5 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. C\u00fa ph\u00e1p v\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 FIND:<\/p>\n<p><strong><code class=\"excel-formula-inline\">SEARCH (find_text, within_text, [start_num])<\/code><\/strong><\/p>\n<p>Kh\u00f4ng gi\u1ed1ng nh\u01b0 FIND, h\u00e0m Search <strong>kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/strong>\u00a0v\u00e0 cho ph\u00e9p s\u1eed d\u1ee5ng c\u00e1c\u00a0<strong>k\u00fd t\u1ef1 thay th\u1ebf<\/strong>.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n c\u1ee7a SEARCH:<\/p>\n<p><strong>=SEARCH(\u201cmarket\u201d, \u201csupermarket\u201d)<\/strong>Tr\u1ea3 v\u1ec1 6 v\u00ec chu\u1ed7i \u201cmarket \u201d b\u1eaft \u0111\u1ea7u t\u1eeb\u00a0k\u00fd t\u1ef1 th\u1ee9 6 c\u1ee7a t\u1eeb \u201csupermarket\u201d.<\/p>\n<p><strong>=SEARCH(\u201ce\u201d, \u201cExcel\u201d)<\/strong>\u00a0Tr\u1ea3 v\u1ec1 1 v\u00ec \u201ce\u201d l\u00e0 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong t\u1eeb \u201cExcel\u201d, b\u1ea5t k\u1ec3 E hoa.<\/p>\n<p>Gi\u1ed1ng nh\u01b0 FIND, h\u00e0m SEARCH c\u1ee7a Excel tr\u1ea3 v\u1ec1 #VALUE!\u00a0L\u1ed7i n\u1ebfu:<\/p>\n<ul>\n<li>Kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a \u0111\u1ed1i s\u1ed1 find_text.<\/li>\n<li>\u0110\u1ed1i s\u1ed1 start_num l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i c\u1ee7a within_text.<\/li>\n<li>Start_num b\u1eb1ng ho\u1eb7c nh\u1ecf h\u01a1n 0 (kh\u00f4ng).<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Excel SEARCH function\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-search-function.png\" alt=\"Excel SEARCH function\"><\/p>\n<blockquote>\n<p>Xem ngay:\u00a0H\u1ecdc Excel n\u00e2ng cao \u1edf \u0111\u00e2u?<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_FIND_voi_SEARCH\"><\/span><strong>So s\u00e1nh FIND v\u1edbi SEARCH:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, h\u00e0m FIND v\u00e0 SEARCH trong Excel r\u1ea5t gi\u1ed1ng nhau v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng.\u00a0Tuy nhi\u00ean, ch\u00fang c\u0169ng c\u00f3 m\u1ed9t v\u00e0i s\u1ef1 kh\u00e1c bi\u1ec7t.<\/p>\n<ol>\n<li><strong> FIND ph\u00e2n bi\u1ec7t ch\u1eef Hoa, SEARCH kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa.<\/strong><\/li>\n<\/ol>\n<p>S\u1ef1 kh\u00e1c bi\u1ec7t c\u01a1 b\u1ea3n nh\u1ea5t gi\u1eefa h\u00e0m SEARCH v\u00e0 FIND l\u00e0 SEARCH l\u00e0 kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, trong khi FIND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng.<\/p>\n<p>V\u00ed d\u1ee5, SEARCH (\u201ce\u201d, \u201cExcel\u201d) tr\u1ea3 v\u1ec1 1 v\u00ec n\u00f3 nh\u1eadn \u201cE\u201d hoa , trong khi FIND (\u201ce\u201d, \u201cExcel\u201d) tr\u1ea3 v\u1ec1 4 v\u00ec n\u00f3 ph\u00e2n bi\u1ec7t E v\u00e0 e.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/07\/excel-case-sensitive-search.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25151\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-case-sensitive-search.png\" width=\"282\" height=\"100\" title=\"excel-case-sensitive-search\"><\/a><\/p>\n<ol start=\"2\">\n<li><strong> Search\u00a0v\u1edbi k\u00fd t\u1ef1 <\/strong><strong>thay th\u1ebf<\/strong><\/li>\n<\/ol>\n<p>Kh\u00f4ng gi\u1ed1ng nh\u01b0 h\u00e0m FIND, h\u00e0m SEARCH cho ph\u00e9p s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong \u0111\u1ed1i s\u1ed1 find_text:<\/p>\n<ul>\n<li>D\u1ea5u ch\u1ea5m h\u1ecfi (?) thay cho m\u1ed9t k\u00fd t\u1ef1, v\u00e0<\/li>\n<li>D\u1ea5u hoa th\u1ecb (*) thay cho b\u1ea5t k\u1ef3 chu\u1ed7i k\u00fd t\u1ef1 n\u00e0o.<\/li>\n<\/ul>\n<p>H\u00e3y xem n\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o tr\u00ean d\u1eef li\u1ec7u th\u1ef1c t\u1ebf:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Search with wildcard characters in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-wildcard-search.png\" alt=\"Search with wildcard characters in Excel\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u00f4ng th\u1ee9c SEARCH (\u201cfunctio*2013\u201d, A2) tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean (\u201cf\u201d) trong chu\u1ed7i ph\u1ee5 n\u1ebfu chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp trong within_text\u00a0 c\u00f3 ch\u1ee9a c\u1ea3 \u201cfunction \u201d V\u00e0 \u201c2013\u201d, b\u1ea5t k\u1ec3 c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 kh\u00e1c \u1edf gi\u1eefa.<\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>\u0110\u1ec3 th\u1ef1c s\u1ef1 t\u00ecm m\u1ed9t d\u1ea5u h\u1ecfi (?) ho\u1eb7c d\u1ea5u sao (*), g\u00f5 m\u1ed9t d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">Th\u1ee7 thu\u1eadt Excel n\u00e2ng cao<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cac_vi_du_ve_cong_thuc_FIND_va_SEARCH\"><\/span><strong>C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c FIND v\u00e0 SEARCH:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong th\u1ef1c t\u1ebf, c\u00e1c h\u00e0m FIND v\u00e0 SEARCH hi\u1ebfm khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.\u00a0Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng ch\u00fang k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 MID, LEFT ho\u1eb7c RIGHT,<\/p>\n<p><strong>V\u00ed d\u1ee5 1. T\u00ecm m\u1ed9t chu\u1ed7i tr\u01b0\u1edbc ho\u1eb7c theo sau m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/strong><\/p>\n<p>V\u00ed d\u1ee5 n\u00e0y cho th\u1ea5y c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm v\u00e0 tr\u00edch ra t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n \u1edf b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t h\u1ecd v\u00e0 t\u00ean (c\u1ed9t A) v\u00e0 b\u1ea1n mu\u1ed1n k\u00e9o T\u00ean v\u00e0 H\u1ecd sang c\u00e1c c\u1ed9t ri\u00eang.<\/p>\n<p>\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m FIND (ho\u1eb7c SEARCH) k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEFT:<\/p>\n<p><strong>=LEFT(A2, FIND(\u201d \u201c, A2)-1)<\/strong><\/p>\n<p>ho\u1eb7c l\u00e0<\/p>\n<p><strong>=LEFT(A2, SEARCH(\u201d \u201c, A2)-1)<\/strong><\/p>\n<p>H\u00e0m Excel LEFT tr\u1ea3 v\u1ec1 s\u1ed1 k\u00fd t\u1ef1 b\u00ean t\u1eeb b\u00ean tr\u00e1i qua trong m\u1ed9t chu\u1ed7i.\u00a0V\u00e0 b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a kho\u1ea3ng tr\u1eafng (\u201c\u201d) \u0111\u1ec3 cho ph\u00e9p LEFT bi\u1ebft \u0111\u01b0\u1ee3c c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 \u0111\u1ec3 tr\u00edch xu\u1ea5t.\u00a0T\u1ea1i \u0111\u00f3, b\u1ea1n -1 t\u1eeb v\u1ecb tr\u00ed c\u1ee7a kho\u1ea3ng tr\u1eafng v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n gi\u00e1 tr\u1ecb tr\u1ea3 l\u1ea1i g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng.<\/p>\n<p>\u0110\u1ec3 tr\u00edch xu\u1ea5t ph\u1ea7n H\u1ecc, s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m RIGHT, FIND \/ SEARCH v\u00e0 LEN.\u00a0H\u00e0m LEN \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i, t\u1eeb \u0111\u00f3 b\u1ea1n tr\u1eeb \u0111i v\u1ecb tr\u00ed c\u1ee7a kho\u1ea3ng tr\u1eafng:<\/p>\n<p><strong>=RIGHT(A2,LEN(A2)-FIND(\u201d \u201c,A2))<\/strong><\/p>\n<p>ho\u1eb7c l\u00e0<\/p>\n<p><strong>=RIGHT(A2,LEN(A2)-SEARCH(\u201d \u201c,A2))<\/strong><\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau minh h\u1ecda k\u1ebft qu\u1ea3:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Splitting the first name and last names into separate columns.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-substring.png\" alt=\"Splitting the first name and last names into separate columns.\"><\/p>\n<p><strong>V\u00ed d\u1ee5 2. T\u00ecm s\u1ef1 xu\u1ea5t hi\u1ec7n th\u1ee9 N c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n<\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 chu\u1ed7i v\u0103n b\u1ea3n trong c\u1ed9t A, ch\u1eb3ng h\u1ea1n m\u1ed9t danh s\u00e1ch SKU, v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch th\u1ee9 hai (-) trong m\u1ed9t chu\u1ed7i.\u00a0Ta c\u00f3 c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/p>\n<p><strong>=FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1)<\/strong><\/p>\n<p>Hai \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean x\u00e1c \u0111\u1ecbnh d\u1ea5u g\u1ea1ch ngang (\u201c-\u201c) trong \u00f4 A2.\u00a0S\u1ed1 th\u1ee9 ba (start_num), b\u1ea1n nh\u00fang m\u1ed9t h\u00e0m FIND \u0111\u1ec3 Excel \u0111\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm t\u1eeb\u00a0<strong>L\u1ea7n th\u1ee9 2 xu\u1ea5t hi\u1ec7n<\/strong> c\u1ee7a d\u1ea5u g\u1ea1ch ngang (FIND ( \u201c-\u201c, A2) +1).<\/p>\n<p>\u0110\u1ec3 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed c\u1ee7a <strong>l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 3<\/strong>\u00a0, b\u1ea1n nh\u00fang c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o \u0111\u1ed1i s\u1ed1 start_num c\u1ee7a m\u1ed9t h\u00e0m FIND kh\u00e1c v\u00e0 th\u00eam 2 v\u00e0o gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1:<\/p>\n<p><strong>=FIND(\u201c-\u201c,A2, FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1) +2)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"FIND formulas to find the position of 2&lt;sup&gt;nd&lt;\/sup&gt; and 3&lt;sup&gt;rd&lt;\/sup&gt; occurrences of a specific character in a string\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-n-occurrence.png\" alt=\"FIND formulas to find the position of 2&lt;sup&gt;nd&lt;\/sup&gt; and 3&lt;sup&gt;rd&lt;\/sup&gt; occurrences of a specific character in a string\"><\/p>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c v\u00e0 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n \u0111\u1ec3 t\u00ecm s\u1ef1 xu\u1ea5t hi\u1ec7n th\u1ee9 N c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh l\u00e0 s\u1eed d\u1ee5ng h\u00e0m FIND k\u1ebft h\u1ee3p v\u1edbi CHAR v\u00e0 SUBSTITUTE:<\/p>\n<p><strong>=FIND(CHAR(1),SUBSTITUTE(A2,\u201d-\u201c,CHAR(1),3))<\/strong><\/p>\n<p>Trong \u0111\u00f3 \u201c-\u201d l\u00e0 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp v\u00e0 \u201c3\u201d l\u00e0 l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 N m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm.<\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean, h\u00e0m SUBSTITUTE s\u1ebd thay th\u1ebf l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 3 c\u1ee7a d\u1ea5u g\u1ea1ch (\u201c-\u201c) v\u1edbi CHAR (1), l\u00e0 k\u00fd t\u1ef1 \u201cB\u1eaft \u0111\u1ea7u c\u1ee7a Ti\u00eau \u0111\u1ec1\u201d kh\u00f4ng b\u1eaft bu\u1ed9c k\u00fd t\u1ef1 trong h\u1ec7 th\u1ed1ng ASCII.\u00a0Thay v\u00ec CHAR (1), b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c kh\u00e1c t\u1eeb 1 \u0111\u1ebfn 31. V\u00e0 sau \u0111\u00f3, h\u00e0m FIND tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u00f3 trong chu\u1ed7i v\u0103n b\u1ea3n.\u00a0V\u00ec v\u1eady, c\u00f4ng th\u1ee9c chung l\u00e0 nh\u01b0 sau:<\/p>\n<p><strong>= FIND (CHAR (1), SUBSTITUTE (\u00a0<em>\u00f4<\/em>\u00a0,\u00a0<em>k\u00fd t\u1ef1<\/em>\u00a0, CHAR (1),\u00a0<em>l\u1ea7n th\u1ee9 N x\u1ea3y ra<\/em>\u00a0)<\/strong><\/p>\n<p>Tho\u1ea1t nh\u00ecn, c\u00f3 v\u1ebb nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean \u00edt c\u00f3 gi\u00e1 tr\u1ecb th\u1ef1c ti\u1ec5n, nh\u01b0ng v\u00ed d\u1ee5 ti\u1ebfp theo s\u1ebd cho th\u1ea5y s\u1ef1 h\u1eefu \u00edch c\u1ee7a ch\u00fang trong vi\u1ec7c gi\u1ea3i quy\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c th\u1ef1c s\u1ef1.<\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>H\u00e3y nh\u1edb r\u1eb1ng h\u00e0m FIND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng.\u00a0Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, \u0111i\u1ec1u n\u00e0y kh\u00f4ng c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t, nh\u01b0ng n\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c ch\u1eef c\u00e1i v\u00e0 b\u1ea1n mu\u1ed1n m\u1ed9t\u00a0ch\u00fang\u00a0<strong>kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/strong>\u00a0, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SEARCH\u00a0 thay v\u00ec FIND.<\/p>\n<p><strong>V\u00ed d\u1ee5 3.Tr\u00edch xu\u1ea5t N k\u00fd t\u1ef1 sau m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/strong><\/p>\n<p>\u0110\u1ec3 t\u00ecm m\u1ed9t chu\u1ed7i ph\u1ee5 c\u00f3 \u0111\u1ed9 d\u00e0i nh\u1ea5t \u0111\u1ecbnh trong b\u1ea5t k\u1ef3 chu\u1ed7i v\u0103n b\u1ea3n n\u00e0o, s\u1eed d\u1ee5ng h\u00e0m FIND ho\u1eb7c Excel SEARCH k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID.<\/p>\n<p>Trong danh s\u00e1ch c\u00e1c SKU c\u1ee7a ch\u00fang ta, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n t\u00ecm 3 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean sau d\u1ea5u g\u1ea1ch \u0111\u1ea7u ti\u00ean v\u00e0 k\u00e9o ch\u00fang v\u00e0o m\u1ed9t c\u1ed9t kh\u00e1c.<\/p>\n<p>N\u1ebfu nh\u00f3m c\u00e1c k\u00fd t\u1ef1 tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch \u0111\u1ea7u ti\u00ean lu\u00f4n c\u00f3 c\u00f9ng \u0111\u1ed9 d\u00e0i (v\u00ed d\u1ee5: 2 k\u00fd t\u1ef1), \u0111\u00e2y s\u1ebd l\u00e0 m\u1ed9t vi\u1ec7c d\u1ec5.\u00a0B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 tr\u1ea3 l\u1ea1i 3 k\u00fd t\u1ef1 t\u1eeb m\u1ed9t chu\u1ed7i, b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed 4 (b\u1ecf qua 2 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean v\u00e0 d\u1ea5u g\u1ea1ch ngang):<\/p>\n<p><strong>=MID(A2, 4, 3)<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c th\u1ee9c cho ho\u1ea1t \u0111\u1ed9ng nh\u01b0 sau: \u201cT\u00ecm trong \u00f4 A2, b\u1eaft \u0111\u1ea7u tr\u00edch xu\u1ea5t t\u1eeb \u200b\u200bk\u00fd t\u1ef1 4, v\u00e0 tr\u1ea3 v\u1ec1 3 k\u00fd t\u1ef1\u201d.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The MID formula to extract 3 characters following a dash\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-mid-formula.png\" alt=\"The MID formula to extract 3 characters following a dash\"><\/p>\n<p>Tuy nhi\u00ean, trong c\u00e1c trang t\u00ednh th\u1ef1c t\u1ebf, chu\u1ed7i ph\u1ee5 b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u b\u1ea5t c\u1ee9 \u0111\u00e2u trong chu\u1ed7i v\u0103n b\u1ea3n.\u00a0Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bi\u1ebft bao nhi\u00eau k\u00fd t\u1ef1 \u0111\u1ee9ng tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch \u0111\u1ea7u ti\u00ean.\u00a0\u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec3m xu\u1ea5t ph\u00e1t c\u1ee7a chu\u1ed7i con m\u00e0 b\u1ea1n mu\u1ed1n truy xu\u1ea5t.<\/p>\n<p>C\u00f4ng th\u1ee9c FIND \u0111\u1ec3 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed c\u1ee7a \u0111\u1ea7u ti\u00ean c\u1ee7a\u00a0d\u1ea5u g\u1ea1ch ngang nh\u01b0 sau:<\/p>\n<p><strong>=FIND(\u201c-\u201c,A2)<\/strong><\/p>\n<p>B\u1edfi v\u00ec b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u v\u1edbi k\u00fd t\u1ef1 ngay sau d\u1ea5u g\u1ea1ch ngang, h\u00e3y th\u00eam 1 v\u00e0o gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 v\u00e0 nh\u00fang h\u00e0m \u1edf tr\u00ean trong \u0111\u1ed1i s\u1ed1 th\u1ee9 hai (start_num) c\u1ee7a h\u00e0m MID:<\/p>\n<p><strong>=MID(A2, FIND(\u201c-\u201c,A2)+1, 3)<\/strong><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e0m SEARCH ho\u1ea1t \u0111\u1ed9ng t\u1ed1t:<\/p>\n<p><strong>=MID(A2, SEARCH(\u201c-\u201c,A2)+1, 3)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Use the FIND function to determine the starting point of the substring you want to extract.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-n-characters.png\" alt=\"Use the FIND function to determine the starting point of the substring you want to extract.\">Th\u1eadt tuy\u1ec7t v\u1eddi, nh\u01b0ng n\u1ebfu nh\u00f3m c\u00e1c k\u00fd t\u1ef1 tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch \u0111\u1ea7u ti\u00ean c\u00f3 \u0111\u1ed9 d\u00e0i kh\u00e1c nhau?\u00a0\u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The group of chars preceding the first dash contains a different number of characters\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-n-characters2.png\" alt=\"The group of chars preceding the first dash contains a different number of characters\"><\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ho\u00e0n h\u1ea3o cho h\u00e0ng 1 v\u00e0 2. Trong c\u00e1c h\u00e0ng 4 v\u00e0 5, nh\u00f3m th\u1ee9 hai ch\u1ee9a 4 k\u00fd t\u1ef1, nh\u01b0ng ch\u1ec9 c\u00f3 3 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.\u00a0Trong c\u00e1c h\u00e0ng 6 v\u00e0 7, ch\u1ec9 c\u00f3 2 k\u00fd t\u1ef1 trong nh\u00f3m th\u1ee9 hai v\u00e0 do \u0111\u00f3 c\u00f4ng th\u1ee9c Search\u00a0c\u1ee7a ch\u00fang ta tr\u1ea3 v\u1ec1 m\u1ed9t d\u1ea5u g\u1ea1ch ngang n\u1eefa.<\/p>\n<blockquote>\n<p>Ta\u0300i li\u00ea\u0323u h\u01b0\u0303u i\u0301ch:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1\u00a0<strong>t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 gi\u1eefa 2 l\u1ea7n xu\u1ea5t hi\u1ec7n<\/strong>\u00a0c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 n\u00e0o \u0111\u00f3 (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 d\u1ea5u g\u1ea1ch ngang)? Th\u00ec \u0111\u00e2y l\u00e0 c\u00e2u tr\u1ea3 l\u1eddi:<\/p>\n<p><strong>=MID(A2, FIND(\u201c-\u201c,A2)+1, FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1) \u2013 FIND(\u201c-\u201c,A2)-1)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The FIND formula to return all characters between the first and second occurrences of a specific character\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-n-characters3.png\" alt=\"The FIND formula to return all characters between the first and second occurrences of a specific character\"><\/p>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00f4ng th\u1ee9c MID n\u00e0y, ch\u00fang ta h\u00e3y xem x\u00e9t t\u1eebng ph\u1ea7n t\u1eed c\u1ee7a n\u00f3:<\/p>\n<ul>\n<li>Ph\u1ea7n \u0111\u1ea7u ti\u00ean (v\u0103n b\u1ea3n).\u00a0\u0110\u00f3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u00f4 A2.<\/li>\n<li>Ph\u1ea7n t\u1eed th\u1ee9 hai (v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u).\u00a0Ch\u1ec9 \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.\u00a0B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm d\u1ea5u \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u00e0 th\u00eam 1 v\u00e0o gi\u00e1 tr\u1ecb \u0111\u00f3 b\u1edfi v\u00ec b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u v\u1edbi k\u00fd t\u1ef1 \u0111i sau d\u1ea5u g\u1ea1ch ngang: FIND (\u201c-\u201c, A2) +1.<\/li>\n<li>Ph\u1ea7n t\u1eed\u00a0th\u1ee9 ba (num_chars).\u00a0Ch\u1ec9 \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1.\u00a0Trong c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta, \u0111\u00e2y l\u00e0 ph\u1ea7n kh\u00f3 kh\u0103n nh\u1ea5t.\u00a0B\u1ea1n s\u1eed d\u1ee5ng hai h\u00e0m FIND (ho\u1eb7c SEARCH), m\u1ed9t s\u1ebd x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch \u0111\u1ea7u ti\u00ean: FIND (\u201c-\u201c, A2).\u00a0V\u00e0 h\u00e0m th\u1ee9 hai tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch ngang th\u1ee9 hai: FIND (\u201c-\u201c, A2, SEARCH (\u201c-\u201c, A2) +1).\u00a0Sau \u0111\u00f3, b\u1ea1n tr\u1eeb c\u00e1i tr\u01b0\u1edbc \u0111\u1ebfn sau, r\u1ed3i sau \u0111\u00f3 tr\u1eeb 1 v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n l\u1ea5y c\u1ea3 d\u1ea5u g\u1ea1ch ngang.\u00a0K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c s\u1ed1 k\u00fd t\u1ef1 gi\u1eefa\u00a0d\u1ea5u g\u1ea1ch ngang th\u1ee9 nh\u1ea5t v\u00e0 th\u1ee9 hai, \u0111\u00f3 l\u00e0 ch\u00ednh x\u00e1c nh\u1eefng g\u00ec ch\u00fang ta \u0111ang t\u00ecm ki\u1ebfm.\u00a0V\u00ec v\u1eady, b\u1ea1n \u0111\u01b0a gi\u00e1 tr\u1ecb \u0111\u00f3 cho \u0111\u1ed1i s\u1ed1 num_chars c\u1ee7a h\u00e0m MID.<\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3 l\u1ea1i 3 k\u00fd t\u1ef1 sau\u00a0d\u1ea5u th\u1ee9 hai:<\/p>\n<p><strong>=MID(A2, FIND(\u201c-\u201c,A2, FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1) +2), 3)<\/strong><\/p>\n<p>Ho\u1eb7c, tr\u00edch xu\u1ea5t t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 gi\u1eefa\u00a0d\u1ea5u g\u1ea1ch ngang th\u1ee9 hai v\u00e0 th\u1ee9 ba\u00a0:<\/p>\n<p><strong>=MID(A2, FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1)+1, FIND(\u201c-\u201c,A2, FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1) +2) \u2013 FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1)-1)<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/6-3.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7636\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-3.bmp\" width=\"600\" height=\"224\" title=\"6-3\"><\/a><\/p>\n<blockquote>\n<p>\u0110\u0103ng ki\u0301 ngay kho\u0301a <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">ho\u0323c Word Excel c\u01a1 ba\u0309n<\/a><\/p>\n<\/blockquote>\n<p><strong>V\u00ed d\u1ee5 4. T\u00ecm v\u0103n b\u1ea3n gi\u1eefa c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u01a1n<\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 chu\u1ed7i v\u0103n b\u1ea3n d\u00e0i trong c\u1ed9t A v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm v\u00e0 tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n n\u1eb1m trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n.<\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u1ea7n h\u00e0m MID \u0111\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 k\u00fd t\u1ef1 mong mu\u1ed1n t\u1eeb m\u1ed9t chu\u1ed7i, v\u00e0 c\u1ea3 h\u00e0m FIND ho\u1eb7c SEARCH \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u v\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t.<\/p>\n<p><strong>=MID(A2,SEARCH(\u201c(\u201c,A2)+1, SEARCH(\u201c)\u201d,A2)-SEARCH(\u201c(\u201c,A2)-1)<\/strong><\/p>\n<p>Logic c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y t\u01b0\u01a1ng t\u1ef1 v\u1edbi logic m\u00e0 ch\u00fang ta \u0111\u00e3 b\u00e0n t\u1edbi trong v\u00ed d\u1ee5 tr\u01b0\u1edbc.\u00a0V\u00e0 c\u0169ng nh\u01b0 th\u1ebf, ph\u1ea7n ph\u1ee9c t\u1ea1p nh\u1ea5t l\u00e0 \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng cho bi\u1ebft c\u00f4ng th\u1ee9c c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i.\u00a0Bi\u1ec3u th\u1ee9c trong \u0111\u1ed1i s\u1ed1 num_chars kh\u00e1 d\u00e0i:<\/p>\n<ul>\n<li>Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n t\u00ecm th\u1ea5y v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u \u0111\u00f3ng ngo\u1eb7c:\u00a0<strong>SEARCH(\u201c)\u201d,A2)<\/strong><\/li>\n<li>Sau \u0111\u00f3 b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1edf ngo\u1eb7c:\u00a0<strong>SEARCH(\u201c(\u201c,A2)<\/strong><\/li>\n<li>V\u00e0 sau \u0111\u00f3, b\u1ea1n t\u00ednh to\u00e1n s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u \u0111\u00f3ng v\u00e0 m\u1edf ngo\u1eb7c \u00a0v\u00e0 tr\u1eeb 1 t\u1eeb con s\u1ed1 \u0111\u00f3, b\u1edfi v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00f3 hai d\u1ea5u ngo\u1eb7c \u0111\u01a1n trong k\u1ebft qu\u1ea3:\u00a0<strong>SEARCH(\u201c)\u201d,A2)-SEARCH(\u201c(\u201c,A2))-1<\/strong><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Excel SEARCH formula to find and extract text between parentheses\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-text-between-parentheses.png\" alt=\"Excel SEARCH formula to find and extract text between parentheses\"><\/p>\n<p>\u0110\u01b0\u01a1ng nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m FIND thay v\u00ec SEARCH, b\u1edfi v\u00ec kh\u00f4ng c\u1ea7n quan t\u00e2m \u0111\u1ebfn vi\u1ec7c ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 th\u01b0\u1eddng trong v\u00ed d\u1ee5 n\u00e0y.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">kh\u00f3a h\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-85.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2629,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2628","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2628","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=2628"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2628\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2629"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}