{"id":5450,"date":"2025-11-27T13:38:20","date_gmt":"2025-11-27T06:38:20","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-dung-ham-find-findb-trong-excel-chi-tiet-de-hieu\/"},"modified":"2025-11-27T13:38:20","modified_gmt":"2025-11-27T06:38:20","slug":"cach-dung-ham-find-findb-trong-excel-chi-tiet-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-dung-ham-find-findb-trong-excel-chi-tiet-de-hieu\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m FIND, FINDB trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m FIND v\u00e0 FINDB gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed chu\u1ed7i con trong v\u0103n b\u1ea3n, h\u1ed7 tr\u1ee3 t\u00e1ch k\u00fd t\u1ef1, l\u1ea5y h\u1ecd t\u00ean, m\u00e3 ph\u00f2ng ban hay x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh h\u01a1n trong Excel. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng t\u1eebng h\u00e0m, c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi LEFT\/MID\/RIGHT v\u00e0 c\u00e1ch x\u1eed l\u00fd l\u1ed7i th\u01b0\u1eddng g\u1eb7p \u0111\u1ec3 b\u1ea1n thao t\u00e1c ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n

\"H\u00e0mC\u00e1ch d\u00f9ng h\u00e0m FIND, FINDB trong Excel<\/em><\/p>\n

\n

1. C\u00f4ng th\u1ee9c h\u00e0m FIND, FINDB trong Excel<\/h2>\n<\/div>\n

H\u00e0m FIND v\u00e0 FINDB d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i kh\u00e1c, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a chu\u1ed7i c\u1ea7n t\u00ecm t\u00ednh t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a v\u0103n b\u1ea3n g\u1ed1c.<\/p>\n

C\u00fa ph\u00e1p:<\/strong><\/p>\n

    \n
  • =FIND(find_text, within_text, start_num)<\/li>\n
  • =FINDB(find_text, within_text, start_num)<\/li>\n<\/ul>\n

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

      \n
    • find_text (b\u1eaft bu\u1ed9c): <\/strong>Chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n tra c\u1ee9u.<\/li>\n
    • within_text (b\u1eaft bu\u1ed9c):<\/strong> V\u0103n b\u1ea3n d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm.<\/li>\n
    • start_num (t\u00f9y ch\u1ecdn):<\/strong> V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u d\u00f2 t\u00ecm, t\u00ednh t\u1eeb k\u00fd t\u1ef1 s\u1ed1 1. N\u1ebfu kh\u00f4ng nh\u1eadp, Excel m\u1eb7c \u0111\u1ecbnh t\u00ecm t\u1eeb \u0111\u1ea7u chu\u1ed7i.<\/li>\n<\/ul>\n

      C\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a FIND v\u00e0 FINDB:<\/strong><\/p>\n

        \n
      • Hai h\u00e0m FIND v\u00e0 FINDB kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 trong t\u1ea5t c\u1ea3 ng\u00f4n ng\u1eef c\u1ee7a Excel.<\/li>\n
      • FIND t\u00ednh m\u1ed7i k\u00fd t\u1ef1 l\u00e0 1 \u0111\u01a1n v\u1ecb, b\u1ea5t k\u1ec3 k\u00fd t\u1ef1 \u0111\u00f3 thu\u1ed9c b\u1ea3ng m\u00e3 byte \u0111\u01a1n hay byte k\u00e9p v\u00e0 kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o ng\u00f4n ng\u1eef m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng.<\/li>\n
      • FINDB ch\u1ec9 t\u00ednh k\u00fd t\u1ef1 d\u1ea1ng byte k\u00e9p (DBCS) l\u00e0 2 \u0111\u01a1n v\u1ecb khi b\u1ea1n \u0111\u00e3 k\u00edch ho\u1ea1t v\u00e0 \u0111\u1eb7t ng\u00f4n ng\u1eef h\u1ed7 tr\u1ee3 DBCS (nh\u01b0 ti\u1ebfng Nh\u1eadt, ti\u1ebfng Trung, ti\u1ebfng H\u00e0n) l\u00e0m m\u1eb7c \u0111\u1ecbnh. N\u1ebfu kh\u00f4ng, FINDB c\u0169ng s\u1ebd t\u00ednh m\u1ed7i k\u00fd t\u1ef1 nh\u01b0 1 \u0111\u01a1n v\u1ecb.<\/li>\n<\/ul>\n

        \"Bi\u1ec3uC\u00fa ph\u00e1p v\u00e0 th\u00e0nh ph\u1ea7n c\u1ee7a h\u00e0m FIND, FINDB trong Excel<\/em><\/p>\n

        \n

        2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel<\/h2>\n<\/div>\n
        \n

        2.1. C\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m FIND<\/h3>\n<\/div>\n

        Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch h\u1ecd t\u00ean d\u01b0\u1edbi \u0111\u00e2y v\u00e0 mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a ch\u1eef \u201cn\u201d trong m\u1ed7i t\u00ean (ch\u1eef th\u01b0\u1eddng).<\/p>\n

        V\u00ed d\u1ee5 v\u1edbi \u00f4 A2 ch\u1ee9a: <\/strong>Nguy\u1ec5n Minh Tu\u1ea5n<\/p>\n

        C\u00f4ng th\u1ee9c:<\/strong><\/p>\n

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

        H\u00e0m s\u1ebd d\u00f2 k\u00fd t\u1ef1 \u201cn\u201d (ch\u1eef th\u01b0\u1eddng) v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a n\u00f3 trong chu\u1ed7i.<\/p>\n

        \"V\u00edC\u00e1ch t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1 b\u1eb1ng h\u00e0m FIND<\/em><\/p>\n

        \n

        2.2. S\u1eed d\u1ee5ng h\u00e0m FIND k\u1ebft h\u1ee3p h\u00e0m LEFT<\/h3>\n<\/div>\n

        H\u00e0m LEFT k\u1ebft h\u1ee3p v\u1edbi FIND \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00e1ch ph\u1ea7n k\u00fd t\u1ef1 n\u1eb1m b\u00ean tr\u00e1i m\u1ed9t d\u1ea5u ph\u00e2n c\u00e1ch, th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 l\u1ea5y m\u00e3 ph\u00f2ng ban, m\u00e3 s\u1ea3n ph\u1ea9m ho\u1eb7c ph\u1ea7n \u0111\u1ea7u c\u1ee7a chu\u1ed7i.<\/p>\n

        V\u00ed d\u1ee5: <\/strong>T\u00e1ch m\u00e3 ph\u00f2ng ban trong \u00f4 A2 t\u1eeb tr\u00e1i sang ph\u1ea3i cho \u0111\u1ebfn khi g\u1eb7p d\u1ea5u c\u00e1ch \u0111\u1ea7u ti\u00ean.<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> Trong Excel, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

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

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

          \n
        • LEFT: <\/strong>L\u1ea5y chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i.<\/li>\n
        • A2: <\/strong>V\u1ecb tr\u00ed \u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00e1ch.<\/li>\n
        • FIND: <\/strong>T\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (\u1edf \u0111\u00e2y l\u00e0 d\u1ea5u c\u00e1ch ” “).<\/li>\n
        • -1: <\/strong>Lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch kh\u1ecfi k\u1ebft qu\u1ea3, ch\u1ec9 l\u1ea5y ph\u1ea7n m\u00e3.<\/li>\n<\/ul>\n

          B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n

          \"B\u1ea3ngT\u00e1ch m\u00e3 ph\u00f2ng ban b\u1eb1ng k\u1ebft h\u1ee3p h\u00e0m LEFT v\u00e0 FIND<\/em><\/p>\n

          Xem th\u00eam: <\/strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u<\/div>\n
          \n

          2.3. S\u1eed d\u1ee5ng h\u00e0m FIND k\u1ebft h\u1ee3p h\u00e0m MID<\/h3>\n<\/div>\n

          V\u00ed d\u1ee5:<\/strong> L\u1ea5y t\u00ean ph\u00f2ng ban trong \u00f4 A2, b\u1eaft \u0111\u1ea7u sau d\u1ea5u \u201c- \u201d (d\u1ea5u g\u1ea1ch + kho\u1ea3ng tr\u1eafng).<\/p>\n

          B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3:<\/p>\n

          =MID(A2, FIND(“- “, A2) + 2, LEN(A2))<\/p>\n

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

            \n
          • MID:<\/strong> L\u1ea5y chu\u1ed7i t\u1eeb v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh.<\/li>\n
          • A2:<\/strong> \u00d4 ch\u1ee9a d\u1eef li\u1ec7u.<\/li>\n
          • FIND(“- “,A2)+2: <\/strong>FIND t\u00ecm v\u1ecb tr\u00ed \u201c- \u201d, c\u1ed9ng 2 \u0111\u1ec3 b\u1ecf c\u1ea3 d\u1ea5u \u201c-\u201d v\u00e0 kho\u1ea3ng tr\u1eafng.<\/li>\n
          • LEN(A2):<\/strong> L\u1ea5y to\u00e0n b\u1ed9 ph\u1ea7n c\u00f2n l\u1ea1i \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o l\u1ea5y \u0111\u1ee7 t\u00ean ph\u00f2ng ban.<\/li>\n<\/ul>\n

            B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n

            \"B\u1ea3ngT\u00e1ch t\u00ean ph\u00f2ng ban b\u1eb1ng h\u00e0m FIND k\u1ebft h\u1ee3p MID<\/em><\/p>\n

            \n

            2.4. S\u1eed d\u1ee5ng h\u00e0m FIND k\u1ebft h\u1ee3p h\u00e0m RIGHT<\/h3>\n<\/div>\n

            B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3:<\/p>\n

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

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

              \n
            • FIND(” “, B3): <\/strong>T\u00ecm kho\u1ea3ng tr\u1eafng th\u1ee9 1<\/li>\n
            • FIND(” “, B3, FIND(” “, B3) + 1): <\/strong>T\u00ecm kho\u1ea3ng tr\u1eafng th\u1ee9 2<\/li>\n
            • RIGHT: <\/strong>L\u1ea5y ph\u1ea7n b\u00ean ph\u1ea3i t\u1eeb v\u1ecb tr\u00ed kho\u1ea3ng tr\u1eafng th\u1ee9 2 \u0111\u1ebfn h\u1ebft chu\u1ed7i \u2192 ch\u00ednh l\u00e0 T\u00ean<\/li>\n<\/ul>\n

              B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n

              \"V\u00edT\u00e1ch t\u00ean b\u1eb1ng h\u00e0m FIND k\u1ebft h\u1ee3p RIGHT<\/em><\/p>\n

              L\u01b0u \u00fd: <\/strong>C\u00e1ch k\u1ebft h\u1ee3p FIND + RIGHT ph\u00f9 h\u1ee3p v\u1edbi h\u1ecd t\u00ean c\u00f3 3 ch\u1eef (t\u1ee9c l\u00e0 c\u00f3 \u0111\u00fang 2 kho\u1ea3ng tr\u1eafng). N\u1ebfu \u00e1p d\u1ee5ng cho h\u1ecd t\u00ean 2 ch\u1eef ho\u1eb7c 4 ch\u1eef tr\u1edf l\u00ean, c\u00f4ng th\u1ee9c s\u1ebd c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 nh\u1eadn di\u1ec7n v\u1ecb tr\u00ed kho\u1ea3ng tr\u1eafng cu\u1ed1i c\u00f9ng.<\/p>\n

              \n

              3. S\u1eeda l\u1ed7i #VALUE! khi d\u00f9ng h\u00e0m FIND<\/h2>\n<\/div>\n
              \n

              3.1. Nguy\u00ean nh\u00e2n 1<\/h3>\n<\/div>\n

              H\u00e0m FIND c\u00f3 t\u00ednh ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng. Do \u0111\u00f3, n\u1ebfu c\u00f4ng th\u1ee9c t\u00ecm k\u00fd t\u1ef1 vi\u1ebft hoa nh\u01b0ng chu\u1ed7i d\u1eef li\u1ec7u ch\u1ec9 ch\u1ee9a k\u00fd t\u1ef1 vi\u1ebft th\u01b0\u1eddng (ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i), Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i nh\u01b0 v\u00ed d\u1ee5 minh h\u1ecda.<\/p>\n

              \"L\u1ed7iL\u1ed7i #VALUE! do ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng khi d\u00f9ng FIND<\/em><\/p>\n

              C\u00e1ch x\u1eed l\u00fd: <\/strong>R\u00e0 so\u00e1t l\u1ea1i k\u00fd t\u1ef1 c\u1ea7n t\u00ecm v\u00e0 ch\u1ec9nh c\u00f4ng th\u1ee9c cho tr\u00f9ng kh\u1edbp v\u1edbi ki\u1ec3u ch\u1eef trong d\u1eef li\u1ec7u.<\/p>\n

              \n

              3.2. Nguy\u00ean nh\u00e2n 2<\/h3>\n<\/div>\n

              L\u1ed7i c\u0169ng x\u1ea3y ra khi gi\u00e1 tr\u1ecb start_num \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u1edbn h\u01a1n s\u1ed1 k\u00fd t\u1ef1 th\u1ef1c t\u1ebf c\u1ee7a chu\u1ed7i. Khi \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm v\u01b0\u1ee3t qu\u00e1 \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n, Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd v\u00e0 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i.<\/p>\n

              \"L\u1ed7iL\u1ed7i #VALUE! khi \u0111\u1ed1i s\u1ed1 start_num l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i chu\u1ed7i<\/em><\/p>\n

              C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Xem l\u1ea1i tham s\u1ed1 start_num v\u00e0 \u0111i\u1ec1u ch\u1ec9nh v\u1ec1 v\u1ecb tr\u00ed ph\u00f9 h\u1ee3p trong chu\u1ed7i.<\/p>\n

              \n

              4. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m FIND<\/h2>\n<\/div>\n

              H\u00e0m FIND v\u00e0 FINDB c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng, v\u00ec v\u1eady k\u1ebft qu\u1ea3 s\u1ebd kh\u00e1c nhau t\u00f9y c\u00e1ch b\u1ea1n nh\u1eadp k\u00fd t\u1ef1 t\u00ecm ki\u1ebfm. N\u1ebfu mu\u1ed1n t\u00ecm ki\u1ebfm kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa\/ch\u1eef th\u01b0\u1eddng, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SEARCH ho\u1eb7c SEARCHB.<\/p>\n

              Hai h\u00e0m FIND\/FINDB s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p:<\/p>\n

                \n
              • K\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i c\u1ea7n t\u00ecm kh\u00f4ng xu\u1ea5t hi\u1ec7n trong v\u0103n b\u1ea3n.<\/li>\n
              • Gi\u00e1 tr\u1ecb start_num v\u01b0\u1ee3t qu\u00e1 s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i c\u1ea7n t\u00ecm.<\/li>\n
              • \u0110\u1ed1i s\u1ed1 start_num \u2264 0, kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm.<\/li>\n<\/ul>\n

                Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u c\u00f3 d\u1ea5u ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, n\u00ean ki\u1ec3m tra \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u00e0 v\u1ecb tr\u00ed k\u00fd t\u1ef1 \u0111\u1ec3 h\u1ea1n ch\u1ebf sai s\u00f3t.<\/p>\n

                N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m FIND gi\u00fap b\u1ea1n x\u1eed l\u00fd v\u0103n b\u1ea3n, t\u00e1ch chu\u1ed7i v\u00e0 ki\u1ec3m tra d\u1eef li\u1ec7u trong Excel ch\u00ednh x\u00e1c h\u01a1n. \u0110\u1ec3 h\u1ecdc th\u00eam nhi\u1ec1u m\u1eb9o l\u00e0m vi\u1ec7c nhanh v\u00e0 hi\u1ec7u qu\u1ea3, 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 \u0111\u1ec3 c\u1eadp nh\u1eadt n\u1ed9i dung m\u1edbi nh\u1ea5t.<\/p>\n

                N\u1ebfu b\u1ea1n mu\u1ed1n thao t\u00e1c Excel linh ho\u1ea1t h\u01a1n, tr\u1ea3i nghi\u1ec7m m\u01b0\u1ee3t m\u00e0 khi h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng ch\u00ednh h\u00e3ng t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn thi\u1ebft b\u1ecb ph\u00f9 h\u1ee3p.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                \u00a0 H\u00e0m FIND v\u00e0 FINDB gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed chu\u1ed7i con trong v\u0103n b\u1ea3n, h\u1ed7 tr\u1ee3 t\u00e1ch k\u00fd t\u1ef1, l\u1ea5y h\u1ecd t\u00ean, m\u00e3 ph\u00f2ng ban hay x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh h\u01a1n trong Excel. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng t\u1eebng h\u00e0m, c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi LEFT\/MID\/RIGHT v\u00e0 c\u00e1ch x\u1eed l\u00fd […]<\/p>\n","protected":false},"author":1,"featured_media":5451,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5450","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\/19479.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5450","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=5450"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5450\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5451"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}