{"id":64,"date":"2025-11-03T11:26:57","date_gmt":"2025-11-03T11:26:57","guid":{"rendered":"https:\/\/muatheme247.com\/?p=64"},"modified":"2026-03-22T21:21:31","modified_gmt":"2026-03-22T14:21:31","slug":"ham-left-trong-excel","status":"publish","type":"post","link":"https:\/\/muatheme247.com\/en\/ham-left-trong-excel\/","title":{"rendered":"Jaw LEFT in Excel: How to use syntax and examples, detailed illustrations"},"content":{"rendered":"\n

H\u00e0m LEFT trong Excel th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u. Nh\u1edd kh\u1ea3 n\u0103ng tr\u00edch xu\u1ea5t nhanh c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n, h\u00e0m n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 thao t\u00e1c hi\u1ec7u qu\u1ea3 h\u01a1n khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. Trong b\u00e0i vi\u1ebft n\u00e0y, muatheme247<\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT, gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p, \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf v\u00e0 nh\u1eefng l\u01b0u \u00fd quan tr\u1ecdng khi \u00e1p d\u1ee5ng trong Excel.<\/p>\n\n\n\n

<\/span>H\u00e0m LEFT trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n\n\n\n

H\u00e0m LEFT trong Excel cho ph\u00e9p l\u1ea5y ra m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 t\u00ednh t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u01b0ng \u0111\u01b0\u1ee3c d\u00f9ng r\u1ea5t ph\u1ed5 bi\u1ebfn khi c\u1ea7n t\u00e1ch th\u00f4ng tin nh\u01b0 m\u00e3 s\u1ea3n ph\u1ea9m, h\u1ecd t\u00ean, hay k\u00fd hi\u1ec7u. V\u1edbi c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb, h\u00e0m LEFT h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau.<\/p>\n\n\n\n

<\/span>C\u00fa ph\u00e1p h\u00e0m LEFT trong Excel v\u00e0 \u00fd ngh\u0129a t\u1eebng th\u00e0nh ph\u1ea7n<\/span><\/h2>\n\n\n\n

C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m LEFT trong Excel \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n\n\n\n

=LEFT(text, [num_chars])<\/div>\n\n\n\n

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

    \n
  • Text<\/strong>: L\u00e0 chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c \u00f4 ch\u1ee9a v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u.<\/li>\n\n\n\n
  • Num_chars<\/strong>: L\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y, b\u1eaft \u0111\u1ea7u t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i.<\/li>\n<\/ul>\n\n\n\n

    Hi\u1ec3u r\u00f5 hai th\u00e0nh ph\u1ea7n n\u00e0y s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 t\u00e1ch ho\u1eb7c truy xu\u1ea5t th\u00f4ng tin ch\u00ednh x\u00e1c theo nhu c\u1ea7u.<\/p>\n\n\n\n

    <\/span>C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m LEFT trong Excel<\/span><\/h2>\n\n\n\n

    H\u00e0m LEFT l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel, h\u1ed7 tr\u1ee3 hi\u1ec7u qu\u1ea3 cho vi\u1ec7c x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng c\u00f4ng d\u1ee5ng ch\u00ednh c\u1ee7a h\u00e0m m\u00e0 b\u1ea1n n\u00ean n\u1eafm r\u00f5:<\/p>\n\n\n\n

      \n
    • Tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 theo y\u00eau c\u1ea7u:<\/strong> H\u00e0m LEFT cho ph\u00e9p b\u1ea1n l\u1ea5y ra m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n, gi\u00fap d\u1ec5 d\u00e0ng s\u1eafp x\u1ebfp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/li>\n\n\n\n
    • X\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng:<\/strong> Khi l\u00e0m vi\u1ec7c v\u1edbi kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn, h\u00e0m LEFT gi\u00fap b\u1ea1n thao t\u00e1c v\u00e0 ph\u00e2n t\u00edch th\u00f4ng tin m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng, ti\u1ebft ki\u1ec7m \u0111\u00e1ng k\u1ec3 th\u1eddi gian.<\/li>\n\n\n\n
    • Tr\u00edch xu\u1ea5t th\u00f4ng tin c\u1ee5 th\u1ec3:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m LEFT \u0111\u1ec3 t\u00e1ch t\u00ean, m\u00e3 s\u1ed1 ho\u1eb7c c\u00e1c ph\u1ea7n d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n
        \n
      • T\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c:<\/strong> Vi\u1ec7c \u00e1p d\u1ee5ng h\u00e0m LEFT th\u01b0\u1eddng xuy\u00ean gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c.<\/li>\n<\/ul>\n\n\n\n

        V\u1edbi nh\u1eefng \u01b0u \u0111i\u1ec3m tr\u00ean, \u0111\u1eebng qu\u00ean t\u00ecm hi\u1ec3u k\u1ef9 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong ph\u1ea7n d\u01b0\u1edbi \u0111\u1ec3 \u1ee9ng d\u1ee5ng linh ho\u1ea1t v\u00e0o c\u00e1c t\u00e1c v\u1ee5 Excel h\u1eb1ng ng\u00e0y nh\u00e9!<\/p>\n\n\n\n

        <\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel chi ti\u1ebft (k\u00e8m v\u00ed d\u1ee5)<\/span><\/h2>\n\n\n\n

        Ngay sau \u0111\u00e2y l\u00e0 ph\u1ea7n h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 b\u1ea1n ti\u1ec7n theo d\u00f5i v\u00e0 \u00e1p d\u1ee5ng.<\/p>\n\n\n\n

        <\/span>C\u00e1ch d\u00f9ng h\u00e0m LEFT c\u01a1 b\u1ea3n \u0111\u1ec3 t\u00e1ch k\u00fd t\u1ef1<\/span><\/h3>\n\n\n\n

        V\u1edbi h\u00e0m LEFT, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u1ea5y c\u00e1c k\u00fd t\u1ef1 n\u1eb1m \u1edf ph\u00eda b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n theo s\u1ed1 l\u01b0\u1ee3ng mong mu\u1ed1n.<\/p>\n\n\n\n

        V\u00ed d\u1ee5<\/strong>: Cho 1 b\u1ea3ng sinh vi\u00ean, \u00e1p d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 tr\u00edch xu\u1ea5t 2 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t l\u1edbp.<\/p>\n\n\n\n

        \"V\u00ed
        V\u00ed d\u1ee5 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 l\u1ea5y k\u00fd t\u1ef1 t\u1eeb chu\u1ed7i d\u1eef li\u1ec7u.<\/figcaption><\/figure>\n\n\n\n

        \u0110\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh, sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n\n\n\n

        =LEFT(D4,2)<\/strong> v\u00e0 nh\u1ea5n Enter<\/strong>.<\/p>\n\n\n\n

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

          \n
        • D4<\/strong>: L\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/li>\n\n\n\n
        • 2<\/strong>: L\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 2 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean.<\/li>\n<\/ul>\n\n\n\n

          Khi nh\u1ea5n Enter, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2 k\u00fd t\u1ef1 b\u00ean tr\u00e1i trong \u00f4 D4<\/strong>.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Sau khi nh\u1ea5n Enter<\/strong>, Excel s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u201c12\u201d<\/strong>, ch\u00ednh l\u00e0 2 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean n\u1eb1m b\u00ean tr\u00e1i c\u1ee7a l\u1edbp sinh vi\u00ean trong \u00f4 D4.<\/p>\n\n\n\n

          N\u1ebfu mu\u1ed1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i, b\u1ea1n ch\u1ec9 c\u1ea7n di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3, khi con tr\u1ecf chuy\u1ec3n th\u00e0nh d\u1ea5u \u201c+\u201d, h\u00e3y gi\u1eef chu\u1ed9t tr\u00e1i v\u00e0 k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 ph\u00eda d\u01b0\u1edbi. H\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng d\u00f2ng.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Nh\u1edd s\u1eed d\u1ee5ng h\u00e0m LEFT, b\u1ea1n c\u00f3 th\u1ec3 r\u00fat ng\u1eafn \u0111\u00e1ng k\u1ec3 th\u1eddi gian x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, gi\u00fap c\u00f4ng vi\u1ec7c tr\u00ean Excel tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n\n\n\n

          <\/span>K\u1ebft h\u1ee3p h\u00e0m LEFT v\u00e0 VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u s\u1ed1<\/span><\/h3>\n\n\n\n

          Khi s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 v\u1eabn \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 v\u0103n b\u1ea3n n\u00ean b\u1ea1n kh\u00f4ng th\u1ec3 t\u00ednh to\u00e1n tr\u1ef1c ti\u1ebfp. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEFT v\u1edbi h\u00e0m VALUE nh\u1eb1m chuy\u1ec3n chu\u1ed7i k\u00fd t\u1ef1 \u0111\u00f3 v\u1ec1 d\u1ea1ng s\u1ed1.<\/p>\n\n\n\nC\u00fa ph\u00e1p:

          =VALUE(LEFT(text, num_chars))<\/div>\n\n\n\n

          V\u00ed d\u1ee5: V\u1edbi b\u1ea3ng th\u00f4ng tin sinh vi\u00ean, d\u00f9ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m VALUE \u0111\u1ec3 l\u1ea5y ph\u1ea7n s\u1ed1 n\u1eb1m b\u00ean tr\u00e1i trong \u00f4 ch\u1ee9a th\u00f4ng tin l\u1edbp.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          \u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c =VALUE(LEFT(D4,2))<\/strong>, sau \u0111\u00f3 nh\u1ea5n Enter<\/strong>.<\/p>\n\n\n\n

          Trong \u0111\u00f3: D4<\/strong> l\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t, c\u00f2n 2<\/strong> l\u00e0 s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i. C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap chuy\u1ec3n ph\u1ea7n k\u00fd t\u1ef1 \u0111\u00f3 v\u1ec1 d\u1ea1ng s\u1ed1 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng trong c\u00e1c ph\u00e9p t\u00ednh.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t vi\u1ec7c tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u theo \u0111\u00fang y\u00eau c\u1ea7u r\u1ed3i! <\/p>\n\n\n\n

          \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng kh\u00e1c, h\u00e3y k\u00e9o \u00f4 k\u1ebft qu\u1ea3 xu\u1ed1ng \u2014 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng \u00f4, gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u1ed3ng b\u1ed9.<\/p>\n\n\n\n

          <\/span>C\u00e1ch d\u00f9ng h\u00e0m LEFT v\u00e0 LEN \u0111\u1ec3 t\u00e1ch h\u1ecd t\u00ean ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1ed9ng<\/span><\/h3>\n\n\n\n

          Khi c\u1ea7n l\u1ea5y ph\u1ea7n n\u1ed9i dung \u0111\u1ee9ng tr\u01b0\u1edbc m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t \u0111o\u1ea1n k\u00fd t\u1ef1 c\u1ed1 \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEFT v\u1edbi h\u00e0m LEN. H\u00e0m LEN d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u1ed9 d\u00e0i c\u1ee7a to\u00e0n b\u1ed9 chu\u1ed7i, sau \u0111\u00f3 h\u00e0m LEFT s\u1ebd d\u1ef1a v\u00e0o k\u1ebft qu\u1ea3 n\u00e0y \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i v\u00e0 lo\u1ea1i b\u1ecf ph\u1ea7n kh\u00f4ng c\u1ea7n thi\u1ebft b\u1eb1ng ph\u00e9p tr\u1eeb \u201c-\u201d.<\/p>\n\n\n\nC\u00fa ph\u00e1p k\u1ebft h\u1ee3p:

          =LEFT(text, LEN(text) – num_chars)<\/div>\n\n\n\n

          C\u1ee5 th\u1ec3, v\u1edbi v\u00ed d\u1ee5 b\u1ea3ng th\u00f4ng tin h\u1ecdc sinh, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m LEFT k\u1ebft h\u1ee3p LEN \u0111\u1ec3 l\u1ea5y ph\u1ea7n k\u00fd t\u1ef1 \u0111\u1ee9ng tr\u01b0\u1edbc \u201c-19\u201d trong M\u00e3 h\u1ecdc.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          \u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u1ea5t k\u1ef3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n\n\n\n

          =LEFT(H5, LEN(H5)-3)<\/strong> r\u1ed3i nh\u1ea5n Enter<\/strong>.<\/p>\n\n\n\n

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

            \n
          • H5<\/strong>: L\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/li>\n\n\n\n
          • -3<\/strong>: Bi\u1ec3u th\u1ecb s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n lo\u1ea1i b\u1ecf \u1edf cu\u1ed1i chu\u1ed7i, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u201c-19\u201d g\u1ed3m 3 k\u00fd t\u1ef1.
            <\/li>\n<\/ul>\n\n\n\n

            Khi nh\u1ea5n Enter, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 ph\u1ea7n chu\u1ed7i v\u0103n b\u1ea3n n\u1eb1m tr\u01b0\u1edbc \u201c-19\u201d<\/strong>, gi\u00fap b\u1ea1n l\u1ea5y \u0111\u00fang th\u00f4ng tin c\u1ea7n thi\u1ebft m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t vi\u1ec7c tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u theo \u0111\u00fang y\u00eau c\u1ea7u r\u1ed3i!\u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i, h\u00e3y k\u00e9o \u00f4 k\u1ebft qu\u1ea3 xu\u1ed1ng d\u01b0\u1edbi \u2014 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng d\u00f2ng, gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u1ed3ng b\u1ed9.<\/p>\n\n\n\n

            <\/span>K\u1ebft h\u1ee3p h\u00e0m LEFT v\u00e0 SEARCH \u0111\u1ec3 t\u00e1ch chu\u1ed7i theo d\u1ea5u c\u00e1ch ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/span><\/h3>\n\n\n\n

            B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEFT v\u1edbi h\u00e0m SEARCH \u0111\u1ec3 l\u1ea5y ph\u1ea7n n\u1ed9i dung \u0111\u1ee9ng tr\u01b0\u1edbc m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong chu\u1ed7i v\u0103n b\u1ea3n. <\/p>\n\n\n\n

            C\u1ee5 th\u1ec3, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =LEFT(text, SEARCH(” “, text)-1)<\/strong> \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 n\u1eb1m tr\u01b0\u1edbc d\u1ea5u c\u00e1ch th\u1ee9 nh\u1ea5t. <\/p>\n\n\n\n

            V\u1edbi v\u00ed d\u1ee5 b\u1ea3ng th\u00f4ng tin h\u1ecdc sinh, h\u00e3y \u00e1p d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p SEARCH \u0111\u1ec3 l\u1ea5y ph\u1ea7n H\u1ecd trong H\u1ecd v\u00e0 T\u00ean c\u1ee7a h\u1ecdc sinh.<\/p>\n","protected":false},"excerpt":{"rendered":"

            H\u00e0m LEFT trong Excel th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u. Nh\u1edd kh\u1ea3 n\u0103ng tr\u00edch xu\u1ea5t nhanh c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n, h\u00e0m n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 thao t\u00e1c hi\u1ec7u qu\u1ea3 h\u01a1n khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. […]\n","protected":false},"author":1,"featured_media":188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_description":"","rank_math_title":"","footnotes":""},"categories":[13,1],"tags":[],"class_list":["post-64","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-tin-hoc-van-phong"],"acf":[],"_links":{"self":[{"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":12,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/posts\/64\/revisions\/216"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/media\/188"}],"wp:attachment":[{"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/muatheme247.com\/en\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}