{"id":4857,"date":"2025-11-19T13:17:07","date_gmt":"2025-11-19T06:17:07","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-code-trong-excel-cach-su-dung-de-lay-ma-code\/"},"modified":"2025-11-19T13:17:07","modified_gmt":"2025-11-19T06:17:07","slug":"ham-code-trong-excel-cach-su-dung-de-lay-ma-code","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-code-trong-excel-cach-su-dung-de-lay-ma-code\/","title":{"rendered":"H\u00e0m CODE trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y m\u00e3 CODE"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m CODE trong Excel gi\u00fap b\u1ea1n chuy\u1ec3n k\u00fd t\u1ef1 th\u00e0nh m\u00e3 s\u1ed1 \u0111\u1ec3 thu\u1eadn ti\u1ec7n h\u01a1n khi x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1ea3i th\u00edch h\u00e0m CODE l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LOWER \u0111\u1ec3 b\u1ea1n n\u1eafm r\u00f5 v\u00e0 \u00e1p d\u1ee5ng ngay v\u00e0o c\u00f4ng vi\u1ec7c.<\/p>\n

\"minhC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CODE trong Excel<\/em><\/p>\n

\n

1. H\u00e0m CODE l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

H\u00e0m CODE trong Excel d\u00f9ng \u0111\u1ec3 l\u1ea5y m\u00e3 s\u1ed1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd d\u1ef1a tr\u00ean b\u1ea3ng m\u00e3 m\u00e0 h\u1ec7 \u0111i\u1ec1u h\u00e0nh s\u1eed d\u1ee5ng: Windows d\u00f9ng m\u00e3 ANSI, c\u00f2n macOS d\u00f9ng b\u1ea3ng m\u00e3 Macintosh.<\/p>\n

\n

2. C\u00f4ng th\u1ee9c h\u00e0m CODE trong Excel<\/h2>\n<\/div>\n

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

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

    \n
  • text (b\u1eaft bu\u1ed9c): <\/strong>Chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 h\u00e0m s\u1ebd l\u1ea5y k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u00e3 s\u1ed1 t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n
    Xem th\u00eam: <\/strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CHAR trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/div>\n
    \n

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

    3.1. Chuy\u1ec3n k\u00fd t\u1ef1 trong b\u1ea3ng sang m\u00e3 CODE<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 B2, nh\u1eadp c\u00f4ng th\u1ee9c =CODE(A2)<\/strong> \u0111\u1ec3 l\u1ea5y m\u00e3 s\u1ed1 c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong \u00f4 A2.<\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. V\u00ed d\u1ee5, k\u00fd t\u1ef1 \u201c?<\/strong>\u201d trong \u00f4 A2 s\u1ebd tr\u1ea3 v\u1ec1 m\u00e3 63<\/strong>.<\/p>\n

    B\u01b0\u1edbc 3:<\/strong> \u0110\u1ed1i v\u1edbi c\u00e1c \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1. C\u00e1ch nhanh h\u01a1n l\u00e0 \u0111\u01b0a con tr\u1ecf chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 B2 cho \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u \u201c+<\/strong>\u201d, sau \u0111\u00f3 k\u00e9o xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u00e1c d\u00f2ng ph\u00eda d\u01b0\u1edbi.<\/p>\n

    \"v\u00edS\u1eed d\u1ee5ng h\u00e0m CODE \u0111\u1ec3 chuy\u1ec3n k\u00fd t\u1ef1 th\u00e0nh m\u00e3 s\u1ed1 trong Excel<\/em><\/p>\n

    \n

    3.2. K\u1ebft h\u1ee3p d\u00f9ng LOWER trong h\u00e0m CODE<\/h3>\n<\/div>\n

    H\u00e0m LOWER c\u00f3 ch\u1ee9c n\u0103ng chuy\u1ec3n to\u00e0n b\u1ed9 k\u00fd t\u1ef1 trong chu\u1ed7i v\u1ec1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng.<\/p>\n

    B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c =CODE(LOWER(A2))<\/strong> v\u00e0o \u00f4 B2 \u0111\u1ec3 chuy\u1ec3n k\u00fd t\u1ef1 \u1edf \u00f4 A2 v\u1ec1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng r\u1ed3i l\u1ea5y m\u00e3 s\u1ed1 c\u1ee7a k\u00fd t\u1ef1 \u0111\u00f3.<\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3. V\u1edbi c\u1ea3 \u201cA<\/strong>\u201d v\u00e0 \u201ca<\/strong>\u201d, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t m\u00e3 l\u00e0 97<\/strong>.<\/p>\n

    B\u01b0\u1edbc 3: <\/strong>K\u00e9o c\u00f4ng th\u1ee9c t\u1eeb \u00f4 B2 xu\u1ed1ng c\u00e1c d\u00f2ng d\u01b0\u1edbi \u0111\u1ec3 t\u1ea1o m\u00e3 cho c\u00e1c k\u00fd t\u1ef1 c\u00f2n l\u1ea1i trong c\u1ed9t A.<\/p>\n

    \"d\u00f9ngH\u00e0m CODE k\u1ebft h\u1ee3p LOWER \u0111\u1ec3 l\u1ea5y m\u00e3 k\u00fd t\u1ef1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng<\/em><\/p>\n

    Do ch\u1eef c\u00e1i \u0111\u01b0\u1ee3c \u0111\u01b0a v\u1ec1 d\u1ea1ng vi\u1ebft th\u01b0\u1eddng tr\u01b0\u1edbc khi t\u00ednh m\u00e3, n\u00ean k\u00fd t\u1ef1 \u201cA\u201d v\u00e0 \u201ca\u201d s\u1ebd cho ra c\u00f9ng m\u1ed9t gi\u00e1 tr\u1ecb.<\/p>\n

    \n

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

    D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng c\u1ea7n xem l\u1ea1i khi h\u00e0m CODE kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang:<\/p>\n

      \n
    • L\u1ed7i #VALUE!<\/strong>: N\u1ebfu c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!, h\u00e3y ki\u1ec3m tra l\u1ea1i \u00f4 tham chi\u1ebfu xem c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 h\u1ee3p l\u1ec7 hay \u00f4 \u0111ang \u0111\u1ec3 tr\u1ed1ng. L\u1ed7i n\u00e0y th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi h\u00e0m CODE kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n \u0111\u1ec3 x\u1eed l\u00fd.<\/li>\n<\/ul>\n

      \"l\u1ed7iL\u1ed7i #VALUE! khi \u00f4 tham chi\u1ebfu kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u trong h\u00e0m CODE<\/em><\/p>\n

        \n
      • Chu\u1ed7i nhi\u1ec1u k\u00fd t\u1ef1:<\/strong> H\u00e0m CODE ch\u1ec9 \u0111\u1ecdc k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n. N\u1ebfu \u00f4 ch\u1ee9a nhi\u1ec1u h\u01a1n m\u1ed9t k\u00fd t\u1ef1, h\u00e0m s\u1ebd b\u1ecf qua ph\u1ea7n c\u00f2n l\u1ea1i v\u00e0 ch\u1ec9 tr\u1ea3 m\u00e3 c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ee9ng \u0111\u1ea7u. V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c =CODE(“Orange”)<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 79<\/strong>, v\u00ec h\u00e0m ch\u1ec9 x\u1eed l\u00fd k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean l\u00e0 ch\u1eef \u201cO<\/strong>\u201d, t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi =CODE(“O”)<\/strong>.<\/li>\n<\/ul>\n

        \"v\u00edH\u00e0m CODE ch\u1ec9 l\u1ea5y m\u00e3 c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i<\/em><\/p>\n

        Qua c\u00e1c v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng h\u00e0m CODE \u0111\u1ec3 x\u1eed l\u00fd k\u00fd t\u1ef1 trong Excel hi\u1ec7u qu\u1ea3 h\u01a1n. \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 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o hay ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y.<\/p>\n

        N\u1ebfu b\u1ea1n \u0111ang c\u00e2n nh\u1eafc n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb l\u00e0m vi\u1ec7c, \u0111\u1eebng b\u1ecf qua c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7u n\u0103ng cao t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. Tham kh\u1ea3o ngay \u0111\u1ec3 ch\u1ecdn \u0111\u01b0\u1ee3c s\u1ea3n ph\u1ea9m ph\u00f9 h\u1ee3p nhu c\u1ea7u h\u1ecdc t\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u Excel.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        \u00a0 H\u00e0m CODE trong Excel gi\u00fap b\u1ea1n chuy\u1ec3n k\u00fd t\u1ef1 th\u00e0nh m\u00e3 s\u1ed1 \u0111\u1ec3 thu\u1eadn ti\u1ec7n h\u01a1n khi x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1ea3i th\u00edch h\u00e0m CODE l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LOWER \u0111\u1ec3 b\u1ea1n n\u1eafm r\u00f5 v\u00e0 \u00e1p d\u1ee5ng ngay v\u00e0o c\u00f4ng […]<\/p>\n","protected":false},"author":1,"featured_media":4858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4857","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\/19365.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4857","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=4857"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4857\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4858"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}