{"id":4542,"date":"2025-11-13T09:40:41","date_gmt":"2025-11-13T02:40:41","guid":{"rendered":"https:\/\/autofillform.com\/blog\/so-sanh-ham-find-va-search-trong-excel-khac-nhau-nhu-the-nao\/"},"modified":"2025-11-13T09:40:41","modified_gmt":"2025-11-13T02:40:41","slug":"so-sanh-ham-find-va-search-trong-excel-khac-nhau-nhu-the-nao","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/so-sanh-ham-find-va-search-trong-excel-khac-nhau-nhu-the-nao\/","title":{"rendered":"So s\u00e1nh h\u00e0m FIND v\u00e0 SEARCH trong Excel: Kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m FIND v\u00e0 SEARCH l\u00e0 hai c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u0103n b\u1ea3n trong Excel, nh\u01b0ng m\u1ed7i h\u00e0m l\u1ea1i c\u00f3 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng kh\u00e1c nhau. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u s\u1ef1 kh\u00e1c bi\u1ec7t, c\u00e1ch d\u00f9ng t\u1eebng h\u00e0m v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 thao t\u00e1c d\u1eef li\u1ec7u nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n

\"SoSo s\u00e1nh h\u00e0m FIND v\u00e0 SEARCH trong Excel<\/em><\/p>\n

\n

1. H\u00e0m FIND<\/h2>\n<\/div>\n

H\u00e0m FIND trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n n\u1eb1m b\u00ean trong chu\u1ed7i kh\u00e1c.<\/p>\n

C\u00fa ph\u00e1p s\u1eed d\u1ee5ng:<\/strong> =FIND(find_text, within_text, start_num)<\/p>\n

Gi\u1ea3i th\u00edch c\u00e1c th\u00e0nh ph\u1ea7n:<\/strong><\/p>\n

    \n
  • find_text:<\/strong> ph\u1ea7n k\u00fd t\u1ef1 ho\u1eb7c \u0111o\u1ea1n ch\u1eef m\u00e0 b\u1ea1n mu\u1ed1n d\u00f2 t\u00ecm.<\/li>\n
  • within_text:<\/strong> chu\u1ed7i d\u1eef li\u1ec7u ch\u1ee9a n\u1ed9i dung c\u1ea7n t\u00ecm.<\/li>\n
  • start_num (t\u00f9y ch\u1ecdn): <\/strong>v\u1ecb tr\u00ed trong within_text m\u00e0 b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u qu\u00e1 tr\u00ecnh t\u00ecm ki\u1ebfm.<\/li>\n<\/ul>\n

    Khi th\u1ef1c thi, FIND s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean kh\u1edbp v\u1edbi find_text trong within_text. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e0m s\u1ebd b\u00e1o l\u1ed7i.<\/p>\n

    V\u00ed d\u1ee5 h\u00e0m FIND: <\/strong>T\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 \u201cH<\/strong>\u201d trong t\u00ean H\u01b0ng<\/strong> b\u1eb1ng h\u00e0m FIND.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =FIND(“H”, B2, 1)<\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> v\u00e0 Excel s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a k\u00fd t\u1ef1 \u201cH\u201d trong chu\u1ed7i \u1edf \u00f4 B2<\/p>\n

    \"D\u00f9ngV\u00ed d\u1ee5 h\u00e0m FIND t\u00ecm v\u1ecb tr\u00ed ch\u1eef H\u00a0<\/em><\/p>\n

    M\u1ed9t v\u00e0i \u0111i\u1ec3m c\u1ea7n ch\u00fa \u00fd khi d\u00f9ng h\u00e0m FIND:<\/strong><\/p>\n

      \n
    • FIND c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng, n\u00ean \u201cH\u201d v\u00e0 \u201ch\u201d s\u1ebd cho ra v\u1ecb tr\u00ed kh\u00e1c nhau.<\/li>\n
    • Tham s\u1ed1 start_num<\/em> l\u00e0 t\u00f9y ch\u1ecdn, m\u1eb7c \u0111\u1ecbnh b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 1 trong chu\u1ed7i.<\/li>\n
    • FIND lu\u00f4n tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a find_text<\/em> trong within_text<\/em>.<\/li>\n
    • Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 t\u00ednh t\u1eeb tr\u00e1i sang ph\u1ea3i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n
    • N\u1ebfu find_text<\/em> kh\u00f4ng t\u1ed3n t\u1ea1i trong within_text<\/em>, h\u00e0m s\u1ebd b\u00e1o l\u1ed7i #VALUE!<\/strong>.<\/li>\n<\/ul>\n
      Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m SEARCH, SEARCHB trong Excel k\u00e8m v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u<\/div>\n
      \n

      2. H\u00e0m SEARCH<\/h2>\n<\/div>\n

      H\u00e0m SEARCH<\/strong> trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n b\u00ean trong chu\u1ed7i kh\u00e1c, \u0111\u1eb7c bi\u1ec7t l\u00e0 kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng<\/strong>.<\/p>\n

      C\u00fa ph\u00e1p:<\/strong> =SEARCH(find_text, within_text, start_num)<\/p>\n

      Gi\u1ea3i th\u00edch tham s\u1ed1:<\/strong><\/p>\n

        \n
      • find_text:<\/strong> \u0111o\u1ea1n ch\u1eef ho\u1eb7c k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n d\u00f2 t\u00ecm.<\/li>\n
      • within_text:<\/strong> chu\u1ed7i d\u1eef li\u1ec7u ch\u1ee9a n\u1ed9i dung c\u1ea7n ki\u1ec3m tra.<\/li>\n
      • start_num:<\/strong> \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u qu\u00e1 tr\u00ecnh t\u00ecm ki\u1ebfm trong within_text.<\/li>\n<\/ul>\n

        Sau khi ch\u1ea1y h\u00e0m, SEARCH s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean kh\u1edbp v\u1edbi find_text trong within_text. N\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p, h\u00e0m s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i.<\/p>\n

        V\u00ed d\u1ee5 h\u00e0m SEARCH: T\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 \u201cO<\/strong>\u201d trong t\u00ean CAO TH\u1eca THU TRANG<\/strong> b\u1eb1ng h\u00e0m SEARCH.<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 (C6), nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

        =SEARCH(“o”, B3, 1) ho\u1eb7c =SEARCH(“O”, B3, 1)<\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>, Excel s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u1ee7a ch\u1eef \u201co<\/strong>\u201d trong \u00f4 B3<\/strong>, v\u00e0 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb l\u00e0 3<\/strong> nh\u01b0 trong h\u00ecnh.<\/p>\n

        \"D\u00f9ngV\u00ed d\u1ee5 h\u00e0m SEARCH t\u00ecm v\u1ecb tr\u00ed ch\u1eef o<\/em><\/p>\n

        M\u1ed9t v\u00e0i \u0111i\u1ec3m quan tr\u1ecdng khi d\u00f9ng h\u00e0m SEARCH:<\/strong><\/p>\n

          \n
        • SEARCH kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/strong>, n\u00ean \u201cO\u201d v\u00e0 \u201co\u201d \u0111\u1ec1u \u0111\u01b0\u1ee3c xem l\u00e0 gi\u1ed1ng nhau.<\/li>\n
        • C\u1ea7n l\u01b0u \u00fd th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 trong h\u00e0m SEARCH; n\u1ebfu nh\u1eadp sai v\u1ecb tr\u00ed ho\u1eb7c \u0111\u1ea3o ng\u01b0\u1ee3c, c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!<\/strong>.<\/li>\n
        • V\u1edbi c\u00e1c tr\u01b0\u1eddng h\u1ee3p chu\u1ed7i t\u00ecm ki\u1ebfm kh\u00f4ng t\u1ed3n t\u1ea1i trong v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam h\u00e0m IFERROR<\/strong> \u0111\u1ec3 tr\u00e1nh b\u00e1o l\u1ed7i v\u00e0 thay b\u1eb1ng th\u00f4ng b\u00e1o th\u00e2n thi\u1ec7n h\u01a1n.<\/li>\n<\/ul>\n
          \n

          3. So s\u00e1nh h\u00e0m FIND v\u00e0 h\u00e0m SEARCH trong Excel<\/h2>\n<\/div>\n
          \n

          3.1. Ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/h3>\n<\/div>\n

          FIND c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng, c\u00f2n SEARCH th\u00ec kh\u00f4ng<\/strong><\/p>\n

          V\u00ed d\u1ee5:<\/strong><\/p>\n

            \n
          • C\u00f4ng th\u1ee9c =SEARCH(“e”, A2)<\/strong> cho k\u1ebft qu\u1ea3 1<\/strong>, v\u00ec SEARCH xem \u201cE\u201d v\u00e0 \u201ce\u201d l\u00e0 gi\u1ed1ng nhau.<\/li>\n<\/ul>\n

            \"D\u00f9ngK\u1ebft qu\u1ea3 SEARCH t\u00ecm ch\u1eef e trong chu\u1ed7i Excel<\/em><\/p>\n

              \n
            • Ng\u01b0\u1ee3c l\u1ea1i, =FIND(“e”, A2)<\/strong> tr\u1ea3 v\u1ec1 4<\/strong>, do FIND ch\u1ec9 nh\u1eadn \u0111\u00fang k\u00fd t\u1ef1 tr\u00f9ng kh\u1edbp v\u1ec1 c\u1ea3 ki\u1ec3u ch\u1eef.<\/li>\n<\/ul>\n

              D\u00f9ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm t\u00ecm k\u00fd t\u1ef1 \"e\" trong chu\u1ed7i ExcelFIND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng khi t\u00ecm k\u00fd t\u1ef1 trong Excel<\/em><\/p>\n

              \n

              3.2. K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n gi\u1eefa FIND v\u00e0 SEARCH<\/h3>\n<\/div>\n

              H\u00e0m FIND<\/strong> kh\u00f4ng h\u1ed7 tr\u1ee3 k\u00fd t\u1ef1 thay th\u1ebf, trong khi SEARCH<\/strong> cho ph\u00e9p b\u1ea1n d\u00f9ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u1ec3 linh ho\u1ea1t h\u01a1n khi t\u00ecm ki\u1ebfm.<\/p>\n

              Trong \u0111\u1ed1i s\u1ed1 find_text<\/em> c\u1ee7a SEARCH, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng:<\/p>\n

                \n
              • ?<\/strong> \u0111\u1ec3 thay th\u1ebf cho \u0111\u00fang m\u1ed9t k\u00fd t\u1ef1 b\u1ea5t k\u1ef3<\/strong>.<\/li>\n
              • *<\/strong> \u0111\u1ec3 \u0111\u1ea1i di\u1ec7n cho m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 b\u1ea5t k\u1ef3<\/strong>.<\/li>\n<\/ul>\n

                V\u00ed d\u1ee5:<\/strong> C\u00f4ng th\u1ee9c =SEARCH(“function*2025”, A2)<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed k\u00fd t\u1ef1 \u201cf\u201d n\u1ebfu trong \u00f4 A2 c\u00f3 xu\u1ea5t hi\u1ec7n \u201cfunction\u201d v\u00e0 \u201c2025\u201d, d\u00f9 gi\u1eefa hai ph\u1ea7n n\u00e0y c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 kh\u00e1c \u0111i n\u1eefa.<\/p>\n

                \"H\u00e0mSEARCH t\u00ecm chu\u1ed7i theo m\u1eabu c\u00f3 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong Excel<\/em><\/p>\n

                Xem th\u00eam: <\/strong>5 C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n n\u00ean bi\u1ebft<\/div>\n
                \n

                4. V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m FIND v\u00e0 SEARCH<\/h2>\n<\/div>\n

                Trong th\u1ef1c t\u1ebf, c\u00e1c h\u00e0m FIND<\/strong> v\u00e0 SEARCH<\/strong> th\u01b0\u1eddng kh\u00f4ng d\u00f9ng m\u1ed9t m\u00ecnh m\u00e0 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m nh\u01b0 LEFT<\/strong>, RIGHT<\/strong> ho\u1eb7c MID<\/strong> \u0111\u1ec3 t\u00e1ch d\u1eef li\u1ec7u.<\/p>\n

                \n

                4.1. D\u00f9ng LEFT\/RIGHT k\u1ebft h\u1ee3p FIND\/SEARCH<\/h3>\n<\/div>\n

                Gi\u1ea3 s\u1eed \u00f4 A2 ch\u1ee9a h\u1ecd t\u00ean \u201cNguy\u1ec5n V\u0103n Anh\u201d, b\u1ea1n mu\u1ed1n t\u00e1ch ri\u00eang ph\u1ea7n H\u1ecd.<\/p>\n

                L\u1ea5y h\u1ecd:<\/strong> B\u1ea1n d\u00f9ng LEFT \u0111\u1ec3 l\u1ea5y k\u00fd t\u1ef1 b\u00ean tr\u00e1i, c\u00f2n FIND\/SEARCH d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean:<\/p>\n

                =LEFT(A2, FIND(” “, A2) – 1)<\/p>\n

                ho\u1eb7c<\/p>\n

                =LEFT(A2, SEARCH(” “, A2) – 1)<\/p>\n

                LEFT s\u1ebd l\u1ea5y s\u1ed1 k\u00fd t\u1ef1 t\u00ednh t\u1eeb b\u00ean tr\u00e1i. FIND\/SEARCH gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch, v\u00e0 b\u1ea1n tr\u1eeb \u0111i 1 \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch kh\u1ecfi k\u1ebft qu\u1ea3.<\/p>\n

                \"H\u00e0mT\u00e1ch h\u1ecd b\u1eb1ng LEFT k\u1ebft h\u1ee3p FIND\/SEARCH<\/em><\/p>\n

                L\u1ea5y t\u00ean:<\/strong> K\u1ebft h\u1ee3p RIGHT v\u1edbi LEN v\u00e0 FIND\/SEARCH \u0111\u1ec3 l\u1ea5y ph\u1ea7n n\u1eb1m b\u00ean ph\u1ea3i d\u1ea5u c\u00e1ch:<\/p>\n

                =RIGHT(A2, LEN(A2) – FIND(” “, A2))<\/p>\n

                ho\u1eb7c<\/p>\n

                =RIGHT(A2, LEN(A2) – SEARCH(” “, A2))<\/p>\n

                LEN tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i. Khi tr\u1eeb \u0111i v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch, b\u1ea1n s\u1ebd bi\u1ebft c\u1ea7n l\u1ea5y bao nhi\u00eau k\u00fd t\u1ef1 cho ph\u1ea7n t\u00ean.<\/p>\n

                \"H\u00e0mT\u00e1ch t\u00ean b\u1eb1ng RIGHT k\u1ebft h\u1ee3p FIND\/SEARCH<\/em><\/p>\n

                \n

                4.2. D\u00f9ng MID k\u1ebft h\u1ee3p FIND\/SEARCH<\/h3>\n<\/div>\n

                Gi\u1ea3 s\u1eed \u00f4 A2 = “Nguy\u1ec5n V\u0103n Anh”<\/strong> v\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y ph\u1ea7n “V\u0103n”<\/strong>.<\/p>\n

                B\u01b0\u1edbc 1: T\u00ecm v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean<\/strong><\/p>\n

                FIND(” “, A2)<\/p>\n

                C\u00f4ng th\u1ee9c n\u00e0y x\u00e1c \u0111\u1ecbnh d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean trong chu\u1ed7i h\u1ecd t\u00ean. V\u1edbi \u201cNguy\u1ec5n V\u0103n Anh\u201d, d\u1ea5u c\u00e1ch n\u1eb1m sau ch\u1eef \u201cNguy\u1ec5n\u201d, t\u1ee9c \u1edf v\u1ecb tr\u00ed 7.<\/p>\n

                B\u01b0\u1edbc 2: T\u00ecm v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch th\u1ee9 hai<\/strong><\/p>\n

                FIND(” “, A2, FIND(” “, A2) + 1)<\/p>\n

                \u1ede \u0111\u00e2y, Excel ti\u1ebfp t\u1ee5c t\u00ecm d\u1ea5u c\u00e1ch nh\u01b0ng b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed ngay sau d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean<\/strong>.<\/p>\n

                  \n
                • D\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean = 7<\/li>\n
                • B\u1eaft \u0111\u1ea7u t\u00ecm t\u1eeb v\u1ecb tr\u00ed 8 \u2192 D\u1ea5u c\u00e1ch ti\u1ebfp theo n\u1eb1m gi\u1eefa \u201cV\u0103n\u201d v\u00e0 \u201cAnh\u201d, t\u1ee9c \u1edf v\u1ecb tr\u00ed 11.<\/li>\n<\/ul>\n

                  B\u01b0\u1edbc 3: D\u00f9ng MID \u0111\u1ec3 l\u1ea5y ph\u1ea7n n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch<\/strong><\/p>\n

                  =MID(A2, FIND(” “, A2) + 1, FIND(” “, A2, FIND(” “, A2) + 1) – FIND(” “, A2) – 1)<\/p>\n

                  Gi\u1ea3i th\u00edch:<\/strong> S\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y: [v\u1ecb tr\u00ed kho\u1ea3ng tr\u1eafng th\u1ee9 hai] \u2013 [v\u1ecb tr\u00ed kho\u1ea3ng tr\u1eafng th\u1ee9 nh\u1ea5t] \u2013 1 \u2192 gi\u00fap lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng \u1edf hai b\u00ean.<\/p>\n

                  K\u1ebft qu\u1ea3: <\/strong>H\u00e0m MID s\u1ebd tr\u1ea3 v\u1ec1 ph\u1ea7n v\u0103n b\u1ea3n n\u1eb1m gi\u1eefa hai d\u1ea5u c\u00e1ch, v\u00ed d\u1ee5 \u201cV\u0103n\u201d trong chu\u1ed7i \u201cNguy\u1ec5n V\u0103n Anh\u201d.<\/p>\n

                  \"L\u1ea5yL\u1ea5y t\u00ean \u0111\u1ec7m b\u1eb1ng MID k\u1ebft h\u1ee3p FIND<\/em><\/p>\n

                  D\u00f9ng SEARCH c\u0169ng t\u01b0\u01a1ng t\u1ef1 FIND n\u1ebfu kh\u00f4ng c\u1ea7n ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng.<\/strong><\/p>\n

                  \n

                  5. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n<\/div>\n
                  \n

                  5.1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ecm v\u0103n b\u1ea3n trong m\u1ed9t \u00f4 Excel?<\/h3>\n<\/div>\n

                  B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm v\u0103n b\u1ea3n trong m\u1ed9t \u00f4 Excel b\u1eb1ng hai h\u00e0m:<\/p>\n

                    \n
                  • FIND<\/strong> \u0111\u1ec3 t\u00ecm c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng.<\/li>\n
                  • SEARCH<\/strong> \u0111\u1ec3 t\u00ecm kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng v\u00e0 h\u1ed7 tr\u1ee3 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n.<\/li>\n<\/ul>\n

                    N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y v\u0103n b\u1ea3n, c\u1ea3 hai h\u00e0m \u0111\u1ec1u tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!<\/strong>.<\/p>\n

                    \n

                    5.2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 d\u00f9ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm t\u1eeb b\u00ean ph\u1ea3i sang tr\u00e1i?<\/h3>\n<\/div>\n

                    \u0110\u1ec3 d\u00f9ng FIND<\/strong> t\u00ecm t\u1eeb b\u00ean ph\u1ea3i<\/strong> c\u1ee7a m\u1ed9t chu\u1ed7i, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEN<\/strong>, v\u00ec FIND ch\u1ec9 t\u00ecm t\u1eeb tr\u00e1i sang ph\u1ea3i.<\/p>\n

                    C\u00e1ch l\u00e0m l\u00e0 l\u1ea5y t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i, r\u1ed3i tr\u1eeb v\u1ecb tr\u00ed FIND t\u00ecm \u0111\u01b0\u1ee3c:<\/p>\n

                    =LEN(“cars”) + 1 – FIND(“r”, “cars”)<\/p>\n

                    C\u00f4ng th\u1ee9c tr\u00ean tr\u1ea3 v\u1ec1 2<\/strong>, ngh\u0129a l\u00e0 ch\u1eef \u201cr<\/strong>\u201d n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 2 t\u00ednh t\u1eeb b\u00ean ph\u1ea3i.<\/p>\n

                    \"D\u00f9ngX\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i b\u1eb1ng FIND v\u00e0 LEN<\/em><\/p>\n

                    N\u1eafm v\u1eefng FIND v\u00e0 SEARCH gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh h\u01a1n v\u00e0 l\u00e0m ch\u1ee7 Excel hi\u1ec7u qu\u1ea3 h\u01a1n. N\u1ebfu mu\u1ed1n h\u1ecdc th\u00eam nhi\u1ec1u m\u1eb9o thao t\u00e1c b\u1ea3ng t\u00ednh d\u1ec5 hi\u1ec3u v\u00e0 \u1ee9ng d\u1ee5ng ngay, h\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n

                    N\u1ebfu b\u1ea1n \u0111ang t\u00ecm b\u00e0n ph\u00edm, chu\u1ed9t hay c\u00e1c ph\u1ee5 ki\u1ec7n vi t\u00ednh h\u1ed7 tr\u1ee3 l\u00e0m vi\u1ec7c tr\u00ean Excel m\u01b0\u1ee3t h\u01a1n, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn nh\u1eefng s\u1ea3n ph\u1ea9m ch\u00ednh h\u00e3ng v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a b\u1ea1n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                    \u00a0 H\u00e0m FIND v\u00e0 SEARCH l\u00e0 hai c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u0103n b\u1ea3n trong Excel, nh\u01b0ng m\u1ed7i h\u00e0m l\u1ea1i c\u00f3 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng kh\u00e1c nhau. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u s\u1ef1 kh\u00e1c bi\u1ec7t, c\u00e1ch d\u00f9ng t\u1eebng h\u00e0m v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 thao t\u00e1c d\u1eef […]<\/p>\n","protected":false},"author":1,"featured_media":4543,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4542","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19263.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4542"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4542\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4543"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}