{"id":4864,"date":"2025-11-19T13:21:42","date_gmt":"2025-11-19T06:21:42","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-char-trong-excel-don-gian-nhanh-chong\/"},"modified":"2025-11-19T13:21:42","modified_gmt":"2025-11-19T06:21:42","slug":"cach-su-dung-ham-char-trong-excel-don-gian-nhanh-chong","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-char-trong-excel-don-gian-nhanh-chong\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CHAR trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng"},"content":{"rendered":"
\n
\u00a0<\/div>\n
\u00a0<\/div>\n

H\u00e0m CHAR cho ph\u00e9p b\u1ea1n chuy\u1ec3n m\u00e3 s\u1ed1 th\u00e0nh k\u00fd t\u1ef1 \u0111\u1ec3 ch\u00e8n k\u00fd hi\u1ec7u ho\u1eb7c b\u1ed5 sung k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong v\u0103n b\u1ea3n Excel. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd hi\u1ec3u c\u00e1ch h\u00e0m ho\u1ea1t \u0111\u1ed9ng, c\u00fa ph\u00e1p v\u00e0 c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nh\u1eb1m tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

\"minhC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CHAR trong Excel \u0111\u01a1n gi\u1ea3n<\/em><\/p>\n

\n

1. H\u00e0m CHAR trong Excel l\u00e0 g\u00ec? \u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m CHAR<\/h2>\n<\/div>\n

H\u00e0m CHAR trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 chuy\u1ec3n m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 th\u00e0nh k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng theo b\u1ea3ng m\u00e3 ASCII \u2013 h\u1ec7 th\u1ed1ng m\u00e3 h\u00f3a k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u \u1ee9ng d\u1ee5ng v\u00e0 thi\u1ebft b\u1ecb s\u1ed1. Khi nh\u1eadp m\u1ed9t s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 255, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho m\u00e3 \u0111\u00f3. Ngo\u00e0i Excel, h\u00e0m CHAR c\u0169ng \u0111\u01b0\u1ee3c khai th\u00e1c trong nhi\u1ec1u ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh nh\u01b0 C++ \u0111\u1ec3 x\u1eed l\u00fd k\u00fd t\u1ef1.<\/p>\n

\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m CHAR trong Excel<\/strong><\/p>\n

    \n
  • T\u1ea1o k\u00fd t\u1ef1 t\u1eeb m\u00e3 s\u1ed1 \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng ho\u1eb7c k\u00fd hi\u1ec7u \u0111\u1eb7c bi\u1ec7t.<\/li>\n
  • H\u1ed7 tr\u1ee3 \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n nh\u01b0 ch\u00e8n k\u00fd t\u1ef1, xu\u1ed1ng d\u00f2ng ho\u1eb7c t\u1ea1o chu\u1ed7i tr\u00ecnh b\u00e0y \u0111\u1eb9p h\u01a1n.<\/li>\n
  • C\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd v\u0103n b\u1ea3n linh ho\u1ea1t v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u01a1n.<\/li>\n<\/ul>\n
    \n

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

    2.1. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m CHAR<\/h3>\n<\/div>\n

    H\u00e0m CHAR s\u1ebd \u0111\u1ed5i m\u00e3 s\u1ed1 th\u00e0nh k\u00fd t\u1ef1, v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ph\u1ee5 thu\u1ed9c v\u00e0o b\u1ea3ng m\u00e3 c\u1ee7a h\u1ec7 \u0111i\u1ec1u h\u00e0nh. Excel tr\u00ean Windows s\u1eed d\u1ee5ng b\u1ea3ng m\u00e3 ANSI, trong khi phi\u00ean b\u1ea3n d\u00e0nh cho macOS d\u1ef1a tr\u00ean b\u1ea3ng m\u00e3 Macintosh.<\/p>\n

    C\u00fa ph\u00e1p: <\/strong>=CHAR(number)<\/p>\n

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

      \n
    • number: <\/strong>gi\u00e1 tr\u1ecb nguy\u00ean trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 255.<\/li>\n<\/ul>\n

      K\u1ebft qu\u1ea3:<\/strong> H\u00e0m tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 m\u00e3 \u0111\u00e3 nh\u1eadp d\u1ef1a tr\u00ean b\u1ea3ng m\u00e3 m\u00e0 h\u1ec7 th\u1ed1ng \u0111ang d\u00f9ng.<\/p>\n

      \"giaoC\u00fa ph\u00e1p v\u00e0 c\u00e1ch nh\u1eadp h\u00e0m CHAR trong Excel<\/em><\/p>\n

      \n

      2.2. Kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m kh\u00e1c<\/h3>\n<\/div>\n

      H\u00e0m CHAR c\u00f3 th\u1ec3 ph\u1ed1i h\u1ee3p c\u00f9ng nhi\u1ec1u h\u00e0m Excel \u0111\u1ec3 x\u1eed l\u00fd v\u0103n b\u1ea3n linh ho\u1ea1t h\u01a1n, ch\u1eb3ng h\u1ea1n CONCATENATE, SUBSTITUTE ho\u1eb7c REPT.<\/p>\n

        \n
      • V\u1edbi CONCATENATE:<\/strong> CHAR gi\u00fap ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0o chu\u1ed7i, nh\u01b0 CHAR(10) \u0111\u1ec3 t\u1ea1o ng\u1eaft d\u00f2ng.<\/li>\n
      • V\u1edbi SUBSTITUTE:<\/strong> CHAR \u0111\u00f3ng vai tr\u00f2 thay th\u1ebf m\u1ed9t k\u00fd t\u1ef1 n\u00e0o \u0111\u00f3 trong v\u0103n b\u1ea3n b\u1eb1ng k\u00fd hi\u1ec7u kh\u00e1c. Nh\u1edd v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i d\u1ea5u c\u00e1ch, k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t b\u1eb1ng m\u1ed9t m\u00e3 CHAR mong mu\u1ed1n.<\/li>\n
      • V\u1edbi REPT:<\/strong> CHAR cho ph\u00e9p l\u1eb7p l\u1ea1i m\u1ed9t k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 nhi\u1ec1u l\u1ea7n, ch\u1eb3ng h\u1ea1n t\u1ea1o chu\u1ed7i d\u1ea5u g\u1ea1ch, k\u00fd t\u1ef1 trang tr\u00ed ho\u1eb7c c\u00e1c k\u00fd hi\u1ec7u \u0111\u1ecbnh d\u1ea1ng d\u00f9ng trong b\u00e1o c\u00e1o.<\/li>\n<\/ul>\n
        Xem th\u00eam: <\/strong>Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i Circular Reference trong Excel<\/div>\n
        \n

        3. V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m CHAR<\/h2>\n<\/div>\n
        \n

        3.1. X\u00e1c \u0111\u1ecbnh k\u00fd t\u1ef1 b\u1edfi m\u00e3 ngu\u1ed3n c\u00f3 s\u1eb5n<\/h3>\n<\/div>\n

        H\u00e0m CHAR gi\u00fap b\u1ea1n chuy\u1ec3n m\u1ed9t m\u00e3 ASCII th\u00e0nh k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi c\u1ea7n hi\u1ec3n th\u1ecb c\u00e1c k\u00fd t\u1ef1 kh\u00f3 nh\u1eadp tr\u1ef1c ti\u1ebfp, ch\u1eb3ng h\u1ea1n k\u00fd hi\u1ec7u \u00a9, d\u1ea5u nh\u00e1y k\u00e9p (“) ho\u1eb7c kho\u1ea3ng tr\u1eafng.<\/p>\n

        \u0110\u1ec3 s\u1eed d\u1ee5ng, ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c: =CHAR(number) v\u00e0o \u00f4 mong mu\u1ed1n.<\/p>\n

        V\u00ed d\u1ee5: <\/strong>Khi nh\u1eadp =CHAR(65), Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 A, v\u00ec m\u00e3 ASCII 65 t\u01b0\u01a1ng \u1ee9ng v\u1edbi ch\u1eef c\u00e1i n\u00e0y.<\/p>\n

        \"v\u00edV\u00ed d\u1ee5 chuy\u1ec3n m\u00e3 ASCII th\u00e0nh k\u00fd t\u1ef1 b\u1eb1ng h\u00e0m CHAR<\/em><\/p>\n

        \n

        3.2. Th\u00eam k\u00fd hi\u1ec7u v\u00e0o gi\u1eefa chu\u1ed7i<\/h3>\n<\/div>\n

        B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m CHAR \u0111\u1ec3 \u0111\u01b0a c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0o chu\u1ed7i v\u0103n b\u1ea3n, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi k\u00fd hi\u1ec7u \u0111\u00f3 kh\u00f4ng th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp t\u1eeb b\u00e0n ph\u00edm.<\/p>\n

        V\u00ed d\u1ee5:<\/strong><\/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:<\/p>\n

        =”Sandwich ” & CHAR(38) & ” Tr\u1ee9ng” & CHAR(58) & ” 10″ & CHAR(36)<\/p>\n

        Gi\u1ea3i th\u00edch c\u00e1c m\u00e3 k\u00fd t\u1ef1:<\/strong><\/p>\n

          \n
        • CHAR(38):<\/strong> d\u1ea5u &<\/li>\n
        • CHAR(58):<\/strong> d\u1ea5u :<\/li>\n
        • CHAR(36):<\/strong> k\u00fd hi\u1ec7u $<\/li>\n<\/ul>\n

          B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3. Chu\u1ed7i tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0: Sandwich & Tr\u1ee9ng: 10$<\/p>\n

          \"d\u00f9ng\u1ee8ng d\u1ee5ng h\u00e0m CHAR \u0111\u1ec3 ch\u00e8n k\u00fd hi\u1ec7u v\u00e0o chu\u1ed7i v\u0103n b\u1ea3n<\/em><\/p>\n

          \n

          3.3. D\u00f9ng h\u00e0m CHAR \u0111\u1ec3 ng\u1eaft d\u00f2ng<\/h3>\n<\/div>\n

          N\u1ebfu b\u1ea1n c\u1ea7n t\u00e1ch n\u1ed9i dung th\u00e0nh nhi\u1ec1u d\u00f2ng ngay trong c\u00f9ng m\u1ed9t \u00f4, c\u00f3 th\u1ec3 d\u00f9ng CHAR(10) – k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho xu\u1ed1ng d\u00f2ng trong Excel.<\/p>\n

          C\u00e1ch s\u1eed d\u1ee5ng:<\/strong> =”V\u0103n b\u1ea3n d\u00f2ng 1″ & CHAR(10) & “V\u0103n b\u1ea3n d\u00f2ng 2”<\/p>\n

          V\u00ed d\u1ee5: <\/strong>\u0110\u1ec3 hi\u1ec3n th\u1ecb hai c\u00e2u trong c\u00f9ng m\u1ed9t \u00f4 nh\u01b0ng n\u1eb1m \u1edf hai d\u00f2ng kh\u00e1c nhau:<\/p>\n

          =”Xin ch\u00e0o” & CHAR(10) & “Excel!”<\/p>\n

          L\u01b0u \u00fd: <\/strong>\u0110\u1ec3 n\u1ed9i dung th\u1ef1c s\u1ef1 hi\u1ec3n th\u1ecb xu\u1ed1ng d\u00f2ng, h\u00e3y b\u1eadt Wrap Text trong tab Home.<\/p>\n

          \"d\u00f9ngNg\u1eaft d\u00f2ng trong m\u1ed9t \u00f4 b\u1eb1ng CHAR(10)<\/em><\/p>\n

          \n

          4. C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong h\u00e0m CHAR<\/h2>\n<\/div>\n
          \n

          4.1. L\u1ed7i #VALUE!<\/h3>\n<\/div>\n
            \n
          • Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi gi\u00e1 tr\u1ecb number n\u1eb1m ngo\u00e0i ph\u1ea1m vi h\u1ed7 tr\u1ee3 c\u1ee7a b\u1ea3ng m\u00e3, t\u1ee9c l\u00e0 nh\u1ecf h\u01a1n 1 ho\u1eb7c l\u1edbn h\u01a1n 255.<\/li>\n
          • V\u00ed d\u1ee5 g\u00e2y l\u1ed7i:<\/strong> =CHAR(256)<\/li>\n
          • C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> \u0110\u1ea3m b\u1ea3o number l\u00e0 s\u1ed1 nguy\u00ean trong kho\u1ea3ng 1\u2013255 \u0111\u1ec3 h\u00e0m CHAR ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang.<\/li>\n<\/ul>\n

            \"l\u1ed7iL\u1ed7i #VALUE! khi d\u00f9ng h\u00e0m CHAR sai ph\u1ea1m vi m\u00e3 s\u1ed1<\/em><\/p>\n

            \n

            4.2. L\u1ed7i #NAME?<\/h3>\n<\/div>\n
              \n
            • Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i #NAME? xu\u1ea5t hi\u1ec7n khi t\u00ean h\u00e0m \u0111\u01b0\u1ee3c g\u00f5 kh\u00f4ng \u0111\u00fang, ch\u1eb3ng h\u1ea1n vi\u1ebft sai c\u00fa ph\u00e1p ho\u1eb7c thi\u1ebfu k\u00fd t\u1ef1 trong c\u00f4ng th\u1ee9c.<\/li>\n
            • V\u00ed d\u1ee5:<\/strong> =CHART(65) s\u1ebd g\u00e2y l\u1ed7i v\u00ec Excel kh\u00f4ng nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c t\u00ean h\u00e0m, \u1edf \u0111\u00e2y \u201cCHAR\u201d \u0111\u00e3 b\u1ecb g\u00f5 nh\u1ea7m th\u00e0nh \u201cCHART\u201d.<\/li>\n
            • C\u00e1ch kh\u1eafc ph\u1ee5c: <\/strong>Xem l\u1ea1i t\u00ean h\u00e0m, b\u1ea3o \u0111\u1ea3m vi\u1ebft \u0111\u00fang \u201cCHAR\u201d, \u0111\u1ed3ng th\u1eddi ki\u1ec3m tra l\u1ea1i d\u1ea5u ngo\u1eb7c v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c \u0111\u1ec3 ch\u1eafc ch\u1eafn r\u1eb1ng kh\u00f4ng b\u1ecb thi\u1ebfu ho\u1eb7c sai k\u00fd t\u1ef1.<\/li>\n<\/ul>\n

              \"l\u1ed7iL\u1ed7i #NAME? do g\u00f5 sai t\u00ean h\u00e0m CHAR<\/em><\/p>\n

              H\u00e0m CHAR mang l\u1ea1i nhi\u1ec1u c\u00e1ch x\u1eed l\u00fd k\u00fd t\u1ef1 hi\u1ec7u qu\u1ea3, gi\u00fap b\u1ea1n tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u r\u00f5 r\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n trong Excel. N\u1ebfu mu\u1ed1n c\u1eadp nh\u1eadt th\u00eam c\u00e1c th\u1ee7 thu\u1eadt h\u1eefu \u00edch cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y, h\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n

              N\u1ebfu b\u1ea1n mu\u1ed1n thao t\u00e1c Excel linh ho\u1ea1t h\u01a1n, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng 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 nhu c\u1ea7u s\u1eed d\u1ee5ng.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              \u00a0 \u00a0 H\u00e0m CHAR cho ph\u00e9p b\u1ea1n chuy\u1ec3n m\u00e3 s\u1ed1 th\u00e0nh k\u00fd t\u1ef1 \u0111\u1ec3 ch\u00e8n k\u00fd hi\u1ec7u ho\u1eb7c b\u1ed5 sung k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong v\u0103n b\u1ea3n Excel. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd hi\u1ec3u c\u00e1ch h\u00e0m ho\u1ea1t \u0111\u1ed9ng, c\u00fa ph\u00e1p v\u00e0 c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nh\u1eb1m tr\u00ecnh b\u00e0y d\u1eef […]<\/p>\n","protected":false},"author":1,"featured_media":4865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4864","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\/19364.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4864","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=4864"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4865"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}