{"id":6032,"date":"2025-12-08T18:20:46","date_gmt":"2025-12-08T11:20:46","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-len-trong-excel-de-dem-ky-tu-cuc-don-gian\/"},"modified":"2025-12-08T18:20:46","modified_gmt":"2025-12-08T11:20:46","slug":"cach-su-dung-ham-len-trong-excel-de-dem-ky-tu-cuc-don-gian","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-len-trong-excel-de-dem-ky-tu-cuc-don-gian\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Trong Excel, vi\u1ec7c \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 gi\u00fap b\u1ea1n ki\u1ec3m tra \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n, chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u n\u1ed9i dung m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e0m LEN l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u01b0ng r\u1ea5t m\u1ea1nh m\u1ebd \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y. B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN chi ti\u1ebft, d\u1ec5 hi\u1ec3u v\u00e0 ph\u00f9 h\u1ee3p cho c\u1ea3 ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u l\u1eabn ng\u01b0\u1eddi c\u1ea7n x\u1eed l\u00fd d\u1eef li\u1ec7u chuy\u00ean s\u00e2u.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1<\/em><\/p>\n

\n

1. C\u00f4ng th\u1ee9c h\u00e0m LEN<\/h2>\n<\/div>\n

H\u00e0m LEN tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t.<\/p>\n

C\u00fa ph\u00e1p:<\/strong> =LEN(text)<\/p>\n

Trong \u0111\u00f3 text:<\/strong> L\u00e0 chu\u1ed7i ho\u1eb7c \u00f4 d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u1ebfm k\u00fd t\u1ef1.<\/p>\n

\"C\u00faC\u00f4ng th\u1ee9c h\u00e0m LEN trong Excel<\/em><\/p>\n

L\u01b0u \u00fd:<\/strong><\/p>\n

    \n
  • H\u00e0m LEN ch\u1ec9 th\u1ef1c hi\u1ec7n nhi\u1ec7m v\u1ee5 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1, n\u00ean khi b\u1ea1n s\u1eed d\u1ee5ng, d\u1eef li\u1ec7u g\u1ed1c ho\u00e0n to\u00e0n kh\u00f4ng b\u1ecb thay \u0111\u1ed5i. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i kh\u00e1c nh\u01b0 SUM, RIGHT, LEFT ho\u1eb7c MID \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n (\u0111\u00e3 tr\u00ecnh b\u00e0y chi ti\u1ebft \u1edf ph\u1ea7n d\u01b0\u1edbi).<\/li>\n
  • H\u00e0m LEN kh\u00f4ng th\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 trong d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng, b\u1edfi Excel l\u01b0u ng\u00e0y th\u00e1ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1 seri, kh\u00f4ng ph\u1ea3i chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<\/ul>\n
    \n

    2. C\u00e1ch d\u00f9ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1<\/h2>\n<\/div>\n

    \u0110\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 b\u1ea5t k\u1ef3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c: =LEN(text), Excel s\u1ebd tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c ch\u1eef \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng ki\u1ec3m tra \u0111\u1ed9 d\u00e0i m\u00e3 s\u1ea3n ph\u1ea9m, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n ho\u1eb7c x\u00e1c \u0111\u1ecbnh ph\u1ea7n v\u0103n b\u1ea3n c\u1ea7n x\u1eed l\u00fd.<\/p>\n

    \"C\u00e1chV\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m Len<\/em><\/p>\n

    V\u00ed d\u1ee5: <\/strong>Trong \u00f4 A1 ch\u1ee9a c\u1ee5m t\u1eeb \u201cXin ch\u00e0o\u201d c\u00f4ng th\u1ee9c =LEN(A1) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 7. Excel c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 hi\u1ec7n c\u00f3 trong \u00f4 \u0111\u00f3, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, hay k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng n\u1ebfu c\u00f3.<\/p>\n

    Xem th\u00eam: <\/strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/div>\n
    \n

    3. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel<\/h2>\n<\/div>\n

    B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi TRIM, SEARCH ho\u1eb7c FIND \u0111\u1ec3 l\u00e0m s\u1ea1ch v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m LEN b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/p>\n

    \n

    3.1. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m SUM<\/h3>\n<\/div>\n

    Trong Excel, khi b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng \u0111\u1ed9 d\u00e0i k\u00fd t\u1ef1 c\u1ee7a nhi\u1ec1u \u00f4 d\u1eef li\u1ec7u, vi\u1ec7c \u0111\u1ebfm th\u1ee7 c\u00f4ng t\u1eebng \u00f4 s\u1ebd m\u1ea5t th\u1eddi gian v\u00e0 d\u1ec5 g\u00e2y sai s\u00f3t. H\u00e0m LEN k\u1ebft h\u1ee3p v\u1edbi SUM gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng k\u00fd t\u1ef1 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

    C\u00f4ng th\u1ee9c:<\/strong> =SUM(LEN(text); LEN(text); LEN(text))<\/p>\n

    Trong \u0111\u00f3:<\/strong><\/p>\n

      \n
    • LEN(text); LEN(text); LEN(text): <\/strong>\u0110\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong t\u1eebng \u00f4, bao g\u1ed3m ch\u1eef, s\u1ed1, kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t.<\/li>\n
    • SUM(…) ho\u1eb7c ph\u00e9p c\u1ed9ng \u0111\u01a1n gi\u1ea3n:<\/strong> T\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 t\u1eeb nhi\u1ec1u \u00f4 th\u00e0nh m\u1ed9t gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/li>\n<\/ul>\n

      V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>Cho b\u1ea3ng d\u1eef li\u1ec7u, h\u00e3y t\u00ednh t\u1ed5ng k\u00fd t\u1ef1 trong c\u00e1c \u00f4 ph\u00eda d\u01b0\u1edbi:<\/p>\n\n\n\n\n\n\n\n
      \u00d4 d\u1eef li\u1ec7u<\/th>\nN\u1ed9i dung<\/th>\n<\/tr>\n<\/thead>\n
      A1<\/td>\n\u0110\u1ed7 B\u1ea3o Nam Blog<\/td>\n<\/tr>\n
      A2<\/td>\nNguy\u1ec5n Qu\u1ef3nh Anh<\/td>\n<\/tr>\n
      A3<\/td>\nNguy\u1ec5n \u0110\u1ee9c C\u1ea3nh<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 b\u1ea5t k\u1ef3 nh\u1eadp c\u00f4ng th\u1ee9c: =SUM(LEN(A1); LEN(A2); LEN(A3))<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>, K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0: 52<\/strong>, l\u00e0 t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong ba \u00f4.<\/p>\n

      \"K\u1ebftV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m SUM<\/em><\/p>\n

      \n

      3.2. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m TRIM<\/h3>\n<\/div>\n

      Trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u, d\u1eef li\u1ec7u th\u01b0\u1eddng c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf \u0111\u1ea7u, cu\u1ed1i ho\u1eb7c gi\u1eefa c\u00e1c t\u1eeb, d\u1eabn \u0111\u1ebfn sai l\u1ec7ch s\u1ed1 k\u00fd t\u1ef1 khi \u0111\u1ebfm. H\u00e0m TRIM s\u1ebd lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba, ch\u1ec9 gi\u1eef l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb. Khi k\u1ebft h\u1ee3p TRIM v\u1edbi LEN, b\u1ea1n s\u1ebd \u0111\u1ebfm ch\u00ednh x\u00e1c s\u1ed1 k\u00fd t\u1ef1 th\u1ef1c s\u1ef1 trong chu\u1ed7i.<\/p>\n

      C\u00f4ng th\u1ee9c:<\/strong> =LEN(TRIM(text))<\/p>\n

      Trong \u0111\u00f3:<\/strong><\/p>\n

        \n
      • TRIM(text):<\/strong> Lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf \u0111\u1ea7u, cu\u1ed1i v\u00e0 ch\u1ec9 gi\u1eef m\u1ed9t kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb.<\/li>\n
      • LEN(…): <\/strong>\u0110\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 sau khi \u0111\u00e3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba.<\/li>\n<\/ul>\n

        V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>\u00d4 A1 ch\u1ee9a “H\u1ecdc Excel ” (c\u00f3 kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba \u1edf cu\u1ed1i). H\u00e3y \u0111\u1ebfm ch\u00ednh x\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i A1.<\/p>\n

        B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c: =LEN(TRIM(A1))<\/p>\n

        B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter <\/strong>v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 9<\/strong>, \u0111\u00e2y ch\u00ednh x\u00e1c s\u1ed1 k\u00fd t\u1ef1 th\u1ef1c s\u1ef1 trong chu\u1ed7i “H\u1ecdc Excel<\/strong>“.<\/p>\n

        \"K\u1ebftV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m TRIM<\/em><\/p>\n

        \n

        3.3. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m SUBSTITUTE<\/h3>\n<\/div>\n

        SUBSTITUTE thay th\u1ebf m\u1ed9t k\u00fd t\u1ef1 trong chu\u1ed7i b\u1eb1ng k\u00fd t\u1ef1 kh\u00e1c. Khi k\u1ebft h\u1ee3p v\u1edbi LEN, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 m\u00e0 kh\u00f4ng t\u00ednh kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n.<\/p>\n

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

        =LEN(SUBSTITUTE(text;old_text;new_text;instance_num))<\/p>\n

        Trong \u0111\u00f3:<\/strong><\/p>\n

          \n
        • text: <\/strong>\u00d4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n x\u1eed l\u00fd ho\u1eb7c \u0111\u1ebfm.<\/li>\n
        • old_text: <\/strong>K\u00fd t\u1ef1 mu\u1ed1n x\u00f3a, v\u00ed d\u1ee5 kho\u1ea3ng tr\u1eafng (” “).<\/li>\n
        • new_text:<\/strong> K\u00fd t\u1ef1 thay th\u1ebf, \u0111\u1ec3 tr\u1ed1ng (“”) n\u1ebfu mu\u1ed1n x\u00f3a.<\/li>\n
        • Instance_Num:<\/strong> Th\u1ee9 t\u1ef1 k\u00fd t\u1ef1 c\u0169, kh\u00f4ng b\u1eaft bu\u1ed9c nh\u1eadp.<\/li>\n<\/ul>\n

          \"K\u1ebftC\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m SUBSTITUTE<\/em><\/p>\n

          V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>\u0110\u1ebfm k\u00fd t\u1ef1 trong chu\u1ed7i: \u201cNguy\u1ec5n Qu\u1ef3nh Anh\u201d. (L\u01b0u \u00fd kh\u00f4ng \u0111\u1ebfm kho\u1ea3ng tr\u1eafng).<\/p>\n

          B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c: =LEN(SUBSTITUTE(A1, ” “, “”)).<\/p>\n

          Trong \u0111\u00f3:<\/strong> K\u00fd t\u1ef1 x\u00f3a l\u00e0 kho\u1ea3ng tr\u1eafng (” “) v\u00e0 mu\u1ed1n thay th\u1ebf l\u00e0 \u0111\u1ec3 tr\u1ed1ng (“”).<\/p>\n

          B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter <\/strong>v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 14<\/strong>.<\/p>\n

          \"\u0110\u1ebfmV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m SUBSTITUTE<\/em><\/p>\n

          \n

          3.4. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m LEFT v\u00e0 SEARCH<\/h3>\n<\/div>\n

          Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng m\u00e3 s\u1ea3n ph\u1ea9m, m\u00e3 \u0111\u01a1n h\u00e0ng, k\u00fd hi\u1ec7u ph\u00e2n lo\u1ea1i\u2026 b\u1ea1n th\u01b0\u1eddng c\u1ea7n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 \u0111\u1ee9ng tr\u01b0\u1edbc m\u1ed9t k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0 d\u1ea5u “-“, “_”, “\/” ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 ph\u00e2n t\u00e1ch kh\u00e1c. Vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c h\u00e0m LEN, LEFT v\u00e0 SEARCH s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 t\u1ef1 \u0111\u1ed9ng.<\/p>\n

          T\u1ea1i m\u1ed9t \u00f4 b\u1ea5t k\u1ef3, nh\u1eadp c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

          =LEN(LEFT(text; SEARCH(find_text; within_text; start_num)))<\/p>\n

          Trong \u0111\u00f3:<\/strong><\/p>\n

            \n
          • text:<\/strong> \u00d4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm k\u00fd t\u1ef1.<\/li>\n
          • find_text: <\/strong>K\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed (v\u00ed d\u1ee5: “-“, “_”, “\/”).<\/li>\n
          • within_text: <\/strong>Ch\u00ednh l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm k\u00fd t\u1ef1 c\u1ea7n t\u00ecm.<\/li>\n
          • start_num: <\/strong>V\u1ecb tr\u00ed k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u00ecm (th\u01b0\u1eddng c\u00f3 th\u1ec3 b\u1ecf qua).<\/li>\n<\/ul>\n

            V\u00ed d\u1ee5:<\/strong> Trong \u00f4 A1 ch\u1ee9a d\u1eef li\u1ec7u nh\u01b0: SP-120, h\u00e3y \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 n\u1eb1m b\u00ean tr\u00e1i d\u1ea5u “-“.<\/p>\n

            B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

            =LEN(LEFT(A1; SEARCH(“-“; A1) – 1))<\/p>\n

            Trong \u0111\u00f3:<\/strong><\/p>\n

              \n
            • SEARCH(“-“; A1) x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u “-” trong chu\u1ed7i t\u1ea1i \u00f4 A1.<\/li>\n
            • LEFT(A1; v\u1ecb_tr\u00ed – 1) l\u1ea5y to\u00e0n b\u1ed9 k\u00fd t\u1ef1 tr\u01b0\u1edbc d\u1ea5u “-“.<\/li>\n
            • LEN(…) \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 l\u1ea5y \u0111\u01b0\u1ee3c.<\/li>\n
            • Vi\u1ec7c th\u00eam \u201c-1\u201d l\u00e0 \u0111\u1ec3 lo\u1ea1i b\u1ecf ch\u00ednh k\u00fd t\u1ef1 “-” kh\u1ecfi chu\u1ed7i c\u1ea7n \u0111\u1ebfm.<\/li>\n<\/ul>\n

              B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter<\/strong> k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 2<\/strong>. \u0110\u00e2y l\u00e0 s\u1ed1 k\u00fd t\u1ef1 n\u1eb1m b\u00ean tr\u00e1i c\u1ee7a d\u1ea5u “-” trong \u00f4 d\u1eef li\u1ec7u.<\/p>\n

              \"K\u1ebftV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m LEFT v\u00e0 SEARCH<\/em><\/p>\n

              \n

              3.5. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m RIGHT v\u00e0 SEARCH<\/h3>\n<\/div>\n

              Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 n\u1eb1m \u1edf cu\u1ed1i chu\u1ed7i, th\u01b0\u1eddng l\u00e0 sau m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c d\u1ea5u ph\u00e2n c\u00e1ch nh\u01b0 “-“, “_”, “\/”. Khi \u0111\u00f3, vi\u1ec7c k\u1ebft h\u1ee3p LEN v\u00e0 RIGHT c\u00f9ng SEARCH s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

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

              =LEN(RIGHT(text; LEN(text) – SEARCH(“k\u00fd t\u1ef1 m\u1ed1c”;text)))<\/p>\n

              Trong \u0111\u00f3:<\/strong><\/p>\n

                \n
              • text:<\/strong> V\u00f9ng \u00f4 ch\u1ee9a chu\u1ed7i c\u1ea7n x\u1eed l\u00fd.<\/li>\n
              • k\u00fd t\u1ef1 m\u1ed1c: <\/strong>D\u1ea5u ho\u1eb7c k\u00fd t\u1ef1 d\u00f9ng l\u00e0m \u0111i\u1ec3m chia \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ph\u1ea7n cu\u1ed1i c\u1ea7n \u0111\u1ebfm.<\/li>\n
              • SEARCH(“k\u00fd t\u1ef1 m\u1ed1c”, text): <\/strong>X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 m\u1ed1c trong chu\u1ed7i.<\/li>\n
              • LEN(text) – SEARCH(…):<\/strong> T\u00ednh s\u1ed1 k\u00fd t\u1ef1 t\u1eeb k\u00fd t\u1ef1 m\u1ed1c \u0111\u1ebfn cu\u1ed1i chu\u1ed7i.<\/li>\n
              • RIGHT(text, \u2026): <\/strong>L\u1ea5y ph\u1ea7n chu\u1ed7i n\u1eb1m b\u00ean ph\u1ea3i k\u00fd t\u1ef1 m\u1ed1c.<\/li>\n
              • LEN(…):<\/strong> \u0110\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong ph\u1ea7n chu\u1ed7i v\u1eeba l\u1ea5y.<\/li>\n<\/ul>\n

                V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>Trong \u00f4 A1 ch\u1ee9a chu\u1ed7i: SP-120 – H\u00e3y \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 sau d\u1ea5u “-“.<\/p>\n

                B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

                =LEN(RIGHT(A1; LEN(A1) – SEARCH(“-“, A1)))<\/p>\n

                Trong \u0111\u00f3:<\/strong><\/p>\n

                  \n
                • SEARCH(“-“, A1) x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed d\u1ea5u “-” t\u1ea1i \u00f4 A1.<\/li>\n
                • LEN(A1) t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i.<\/li>\n
                • LEN(A1) – SEARCH(“-“, A1) t\u00ednh s\u1ed1 k\u00fd t\u1ef1 sau d\u1ea5u “-“.<\/li>\n
                • RIGHT(A1) l\u1ea5y ph\u1ea7n chu\u1ed7i n\u1eb1m b\u00ean ph\u1ea3i d\u1ea5u \u201c-\u201d.<\/li>\n
                • LEN(RIGHT) \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a ph\u1ea7n chu\u1ed7i cu\u1ed1i.<\/li>\n<\/ul>\n

                  B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1: 3<\/strong> \u2013 ch\u00ednh l\u00e0 s\u1ed1 k\u00fd t\u1ef1 n\u1eb1m sau d\u1ea5u “-“.<\/p>\n

                  \"K\u1ebftV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m RIGHT v\u00e0 SEARCH<\/em><\/p>\n

                  \n

                  3.6. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m MID<\/h3>\n<\/div>\n

                  Khi b\u1ea1n ch\u1ec9 mu\u1ed1n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 \u1edf m\u1ed9t ph\u1ea7n c\u1ee5 th\u1ec3 c\u1ee7a chu\u1ed7i thay v\u00ec to\u00e0n b\u1ed9, vi\u1ec7c k\u1ebft h\u1ee3p LEN v\u00e0 MID l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1i \u01b0u. C\u00e1ch n\u00e0y gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p, ch\u1eb3ng h\u1ea1n nh\u01b0 tr\u00edch xu\u1ea5t m\u00e3, k\u00fd t\u1ef1 gi\u1eefa chu\u1ed7i, hay c\u00e1c ph\u1ea7n c\u1ea7n ph\u00e2n t\u00edch ri\u00eang bi\u1ec7t.<\/p>\n

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

                  =LEN(MID(text, start_Num, LEN(text) – s\u1ed1_k\u00fd_t\u1ef1_mu\u1ed1n_lo\u1ea1i_b\u1ecf))<\/p>\n

                  Trong \u0111\u00f3:<\/strong><\/p>\n

                    \n
                  • text: <\/strong>\u00d4 d\u1eef li\u1ec7u ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n x\u1eed l\u00fd.<\/li>\n
                  • start_Num:<\/strong> V\u1ecb tr\u00ed k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u tr\u00edch xu\u1ea5t.<\/li>\n
                  • s\u1ed1_k\u00fd_t\u1ef1_mu\u1ed1n_lo\u1ea1i_b\u1ecf:<\/strong> S\u1ed1 k\u00fd t\u1ef1 \u1edf ph\u1ea7n \u0111\u1ea7u v\u00e0\/ho\u1eb7c cu\u1ed1i kh\u00f4ng mu\u1ed1n t\u00ednh, th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 kh\u00f4ng c\u1ea7n thi\u1ebft.<\/li>\n
                  • MID(text, start_num, num_chars):<\/strong> L\u1ea5y ra \u0111o\u1ea1n chu\u1ed7i b\u1eaft \u0111\u1ea7u t\u1eeb start_num v\u1edbi \u0111\u1ed9 d\u00e0i num_chars.<\/li>\n
                  • LEN(…): <\/strong>\u0110\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a \u0111o\u1ea1n chu\u1ed7i v\u1eeba tr\u00edch xu\u1ea5t.<\/li>\n<\/ul>\n

                    V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>\u00d4 A1 ch\u1ee9a chu\u1ed7i: SP-ABC-12, h\u00e3y \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa ph\u1ea7n \u0111\u1ea7u v\u00e0 ph\u1ea7n cu\u1ed1i c\u1ee7a chu\u1ed7i (t\u1ee9c l\u00e0 ch\u1ec9 \u201cABC\u201d).<\/p>\n

                    B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn v\u00e0o \u00f4 b\u1ea5t k\u1ef3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c: =LEN(MID(A1, 4, LEN(A1)-6))<\/p>\n

                    Trong \u0111\u00f3:<\/strong><\/p>\n

                      \n
                    • LEN(A1)<\/strong> t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i<\/li>\n
                    • LEN(A1) – 6<\/strong> l\u00e0 lo\u1ea1i b\u1ecf 3 k\u00fd t\u1ef1 \u0111\u1ea7u (“SP-“) v\u00e0 3 k\u00fd t\u1ef1 cu\u1ed1i (“-12”). T\u1ed5ng l\u00e0 c\u00f3 6 k\u00fd t\u1ef1 mu\u1ed1n lo\u1ea1i b\u1ecf<\/li>\n
                    • MID(A1, 4) <\/strong>k\u00fd t\u1ef1 mu\u1ed1n \u0111\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed 4 \u2192 “ABC”.<\/li>\n
                    • LEN(MID(…))<\/strong> \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 \u0111o\u1ea1n v\u1eeba tr\u00edch xu\u1ea5t<\/li>\n<\/ul>\n

                      B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter <\/strong>v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 3<\/strong>, \u0111\u00e2y ch\u00ednh l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i n\u1eb1m gi\u1eefa ph\u1ea7n \u0111\u1ea7u v\u00e0 ph\u1ea7n cu\u1ed1i.<\/p>\n

                      \"K\u1ebftV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m MID<\/em><\/p>\n

                      \n

                      3.7. K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m IF<\/h3>\n<\/div>\n

                      Khi c\u1ea7n ki\u1ec3m tra \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u00e0 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3, vi\u1ec7c k\u1ebft h\u1ee3p LEN v\u1edbi IF l\u00e0 c\u00e1ch l\u00e0m hi\u1ec7u qu\u1ea3. C\u00e1ch n\u00e0y gi\u00fap t\u1ef1 \u0111\u1ed9ng x\u00e1c th\u1ef1c d\u1eef li\u1ec7u, ki\u1ec3m tra \u0111\u1ed9 d\u00e0i k\u00fd t\u1ef1, v\u00e0 \u0111\u01b0a ra c\u1ea3nh b\u00e1o ho\u1eb7c gi\u00e1 tr\u1ecb thay th\u1ebf ph\u00f9 h\u1ee3p.<\/p>\n

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

                      =IF(LEN(\u00f4_tham_chi\u1ebfu) \u0111i\u1ec1u_ki\u1ec7n, gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang, gi\u00e1_tr\u1ecb_n\u1ebfu_sai)<\/p>\n

                      Trong \u0111\u00f3:<\/strong><\/p>\n

                        \n
                      • \u00f4_tham_chi\u1ebfu:<\/strong> \u00d4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra.<\/li>\n
                      • \u0111i\u1ec1u_ki\u1ec7n:<\/strong> So s\u00e1nh \u0111\u1ed9 d\u00e0i chu\u1ed7i (v\u00ed d\u1ee5: >, , =).<\/li>\n
                      • gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n
                      • gi\u00e1_tr\u1ecb_n\u1ebfu_sai:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n

                        H\u00e0m LEN <\/strong>s\u1ebd \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong \u00f4, bao g\u1ed3m ch\u1eef, s\u1ed1, d\u1ea5u c\u00e1ch v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. H\u00e0m IF <\/strong>s\u1ebd th\u1ef1c hi\u1ec7n ph\u00e9p so s\u00e1nh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

                        V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>T\u1ea1i \u00f4 A1<\/strong> ch\u1ee9a m\u00e3 s\u1ea3n ph\u1ea9m, b\u1ea1n mu\u1ed1n ki\u1ec3m tra xem m\u00e3 n\u00e0y c\u00f3 h\u01a1n 5 k\u00fd t\u1ef1 hay kh\u00f4ng.<\/p>\n

                        B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp v\u00e0o \u00f4 b\u1ea5t k\u1ef3 v\u1edbi c\u00f4ng th\u1ee9c:<\/p>\n

                        =IF(LEN(A1)>5, “H\u1ee3p l\u1ec7”, “Kh\u00f4ng h\u1ee3p l\u1ec7”).<\/p>\n

                        Trong \u0111\u00f3:<\/strong><\/p>\n

                          \n
                        • LEN(A1)<\/strong> t\u00ednh s\u1ed1 k\u00fd t\u1ef1 trong \u00f4 A1.<\/li>\n
                        • >5<\/strong> \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m tra \u0111\u1ed9 d\u00e0i l\u1edbn h\u01a1n 5 k\u00fd t\u1ef1.<\/li>\n
                        • IF(…)<\/strong> \u2192 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, tr\u1ea3 v\u1ec1 “H\u1ee3p l\u1ec7”, n\u1ebfu sai, tr\u1ea3 v\u1ec1 “Kh\u00f4ng h\u1ee3p l\u1ec7”.<\/li>\n<\/ul>\n

                          B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong><\/p>\n

                            \n
                          • K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a SP123456 l\u00e0 \u201cH\u1ee3p l\u1ec7\u201d<\/li>\n
                          • K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a SP123 l\u00e0 \u201cKh\u00f4ng h\u1ee3p l\u1ec7\u201d<\/li>\n<\/ul>\n

                            \"K\u1ebftV\u00ed d\u1ee5 minh h\u1ecda k\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m IF<\/em><\/p>\n

                            \n

                            4. L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel<\/h2>\n<\/div>\n

                            Khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m LEN, b\u1ea1n c\u1ea7n ghi nh\u1edb m\u1ed9t s\u1ed1 \u0111i\u1ec3m sau \u0111\u1ec3 tr\u00e1nh sai s\u1ed1 v\u00e0 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c:<\/p>\n

                              \n
                            • LEN v\u1eabn t\u00ednh to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng, bao g\u1ed3m c\u1ea3 d\u1ea5u c\u00e1ch gi\u1eefa c\u00e1c t\u1eeb v\u00e0 nh\u1eefng k\u00fd t\u1ef1 \u201cv\u00f4 h\u00ecnh\u201d nh\u01b0 tab ho\u1eb7c xu\u1ed1ng d\u00f2ng. V\u00ec v\u1eady, n\u1ebfu d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u kho\u1ea3ng tr\u1eafng th\u1eeba, \u0111\u1ed9 d\u00e0i c\u00f3 th\u1ec3 l\u1edbn h\u01a1n b\u1ea1n d\u1ef1 \u0111o\u00e1n.<\/li>\n
                            • H\u00e0m LEN kh\u00f4ng \u00e1p d\u1ee5ng tr\u1ef1c ti\u1ebfp cho d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y ho\u1eb7c gi\u1edd. N\u1ebfu mu\u1ed1n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1, b\u1ea1n ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb ng\u00e0y\/gi\u1edd sang d\u1ea1ng v\u0103n b\u1ea3n (Text) tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng.<\/li>\n
                            • M\u1ecdi k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0 @, #, %, &, \u2026 \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u00ednh nh\u01b0 m\u1ed9t k\u00fd t\u1ef1 \u0111\u1ed9c l\u1eadp.<\/li>\n
                            • N\u1ebfu \u00f4 d\u1eef li\u1ec7u tr\u1ed1ng ho\u00e0n to\u00e0n, h\u00e0m LEN s\u1ebd tr\u1ea3 v\u1ec1 0.<\/li>\n
                            • Khi k\u1ebft h\u1ee3p LEN v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i nh\u01b0 TRIM ho\u1eb7c SUBSTITUTE, b\u1ea1n c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 th\u1eeba m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i d\u1eef li\u1ec7u g\u1ed1c, nh\u1edd \u0111\u00f3 vi\u1ec7c ki\u1ec3m tra v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u tr\u1edf n\u00ean an to\u00e0n h\u01a1n.<\/li>\n<\/ul>\n

                              Vi\u1ec7c n\u1eafm v\u1eefng h\u00e0m LEN v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 qu\u00e1 tr\u00ecnh x\u1eed l\u00fd v\u00e0 chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u trong Excel. \u00c1p d\u1ee5ng \u0111\u00fang c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd gi\u00fap c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. H\u00e3y luy\u1ec7n t\u1eadp th\u01b0\u1eddng xuy\u00ean \u0111\u1ec3 khai th\u00e1c t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh c\u1ee7a Excel trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n

                              \u0110\u1eebng qu\u00ean 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 bi\u1ebft th\u00eam nhi\u1ec1u m\u1eb9o hay Excel h\u1eefu \u00edch.<\/p>\n

                              >> S\u1eafm ngay cho m\u00ecnh chi\u1ebfc \u0111i\u1ec7n tho\u1ea1i th\u00f4ng minh, m\u00e1y t\u00ednh b\u1ea3ng \u0111\u1ec3 ph\u1ee5c v\u1ee5 h\u1ecdc t\u1eadp Excel hi\u1ec7u qu\u1ea3 v\u1edbi m\u1ee9c gi\u00e1 \u01b0u \u0111\u00e3i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                              \u00a0 Trong Excel, vi\u1ec7c \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 gi\u00fap b\u1ea1n ki\u1ec3m tra \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n, chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u n\u1ed9i dung m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e0m LEN l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u01b0ng r\u1ea5t m\u1ea1nh m\u1ebd \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y. B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng […]<\/p>\n","protected":false},"author":1,"featured_media":6033,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-6032","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\/12\/19618.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/6032","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=6032"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/6032\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/6033"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=6032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=6032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=6032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}