{"id":5515,"date":"2025-11-27T18:34:57","date_gmt":"2025-11-27T11:34:57","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-upper-trong-excel-cong-thuc-va-cach-su-dung\/"},"modified":"2025-11-27T18:34:57","modified_gmt":"2025-11-27T11:34:57","slug":"ham-upper-trong-excel-cong-thuc-va-cach-su-dung","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-upper-trong-excel-cong-thuc-va-cach-su-dung\/","title":{"rendered":"H\u00e0m UPPER trong Excel: C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m UPPER trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef hoa m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong c\u00e1c t\u00e1c v\u1ee5 x\u1eed l\u00fd d\u1eef li\u1ec7u, h\u00e0m n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng chu\u1ea9n h\u00f3a th\u00f4ng tin, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c danh s\u00e1ch ho\u1eb7c b\u00e1o c\u00e1o c\u1ea7n \u0111\u1ed3ng nh\u1ea5t ki\u1ec3u ch\u1eef. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UPPER hi\u1ec7u qu\u1ea3 trong b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n

\"S\u1eedH\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m UPPER trong Excel<\/em><\/p>\n

\n

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

C\u00fa ph\u00e1p c\u1ee7a h\u00e0m: =UPPER(text)<\/strong><\/p>\n

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

text:<\/strong> L\u00e0 v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n chuy\u1ec3n th\u00e0nh ch\u1eef hoa.<\/p>\n

M\u1ed9t s\u1ed1 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m UPPER trong Excel:<\/p>\n

    \n
  • H\u00e0m ch\u1ec9 thay \u0111\u1ed5i c\u00e1c k\u00fd t\u1ef1 ch\u1eef c\u00e1i th\u00e0nh ch\u1eef hoa, m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c s\u1ed1.<\/li>\n
  • H\u00e0m n\u00e0y kh\u00f4ng thay \u0111\u1ed5i n\u1ed9i dung ban \u0111\u1ea7u c\u1ee7a \u00f4, m\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 chuy\u1ec3n \u0111\u1ed5i t\u1ea1i v\u1ecb tr\u00ed \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c.<\/li>\n
  • B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m UPPER v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 LEFT, RIGHT ho\u1eb7c MID \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n linh ho\u1ea1t h\u01a1n.<\/li>\n<\/ul>\n

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

    \n

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

    B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel, t\u1ea1i \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c =UPPER(A2)<\/strong> (gi\u1ea3 s\u1eed \u00f4 A2 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n \u0111\u1ed5i).<\/p>\n

    \"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m UPPER v\u00e0o \u00f4 k\u1ebft qu\u1ea3<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>, sau \u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 danh s\u00e1ch.<\/p>\n

    \"K\u1ebftNh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3<\/em><\/p>\n

    Xem th\u00eam: <\/strong>H\u00e0m INT trong Excel: C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c d\u1ec5 hi\u1ec3u<\/div>\n
    \n

    3. K\u1ebft h\u1ee3p h\u00e0m UPPER v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c trong Excel<\/h2>\n<\/div>\n
    \n

    3.1 H\u00e0m SEARCH<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a c\u1ee5m t\u1eeb “h\u1ecdc Excel<\/strong>” trong chu\u1ed7i v\u0103n b\u1ea3n. Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 tham chi\u1ebfu: =SEARCH(“h\u1ecdc Excel”,B4)<\/strong>.Sau \u0111\u00f3, nh\u1ea5n Enter<\/strong> \u0111\u1ec3 l\u1ea5y v\u1ecb tr\u00ed c\u1ee7a c\u1ee5m t\u1eeb trong \u00f4 B4.<\/p>\n

    \"D\u00f9ngS\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a c\u1ee5m t\u1eeb “h\u1ecdc Excel” trong chu\u1ed7i v\u0103n b\u1ea3n<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Ti\u1ebfp \u0111\u00ean x\u00e1c \u0111\u1ecbnh \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i “h\u1ecdc Excel”. Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 tham chi\u1ebfu \u0111\u1ec3 t\u00ednh \u0111\u1ed9 d\u00e0i c\u1ee5m t\u1eeb n\u00e0y: =LEN(“h\u1ecdc Excel”)<\/strong>. Nh\u1ea5n Enter<\/strong>, k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0 9 k\u00fd t\u1ef1.<\/p>\n

    \"D\u00f9ng\u00c1p d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 t\u00ednh \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i “h\u1ecdc Excel”<\/em><\/p>\n

    B\u01b0\u1edbc 3:<\/strong> T\u00e1ch ph\u1ea7n b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 B4. Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 c\u1ea7n tham chi\u1ebfu: =LEFT(B4, C7-1)<\/strong>. Sau \u0111\u00f3, \u1ea5n Enter<\/strong> \u0111\u1ec3 x\u00e1c nh\u1eadn v\u00e0 l\u1ea5y k\u1ebft qu\u1ea3.<\/p>\n

    \"D\u00f9ngD\u00f9ng h\u00e0m LEFT \u0111\u1ec3 t\u00e1ch ph\u1ea7n v\u0103n b\u1ea3n b\u00ean tr\u00e1i c\u1ee5m t\u1eeb “h\u1ecdc Excel”<\/em><\/p>\n

    B\u01b0\u1edbc 4:<\/strong> Chuy\u1ec3n \u0111\u1ed5i c\u1ee5m t\u1eeb “h\u1ecdc Excel” th\u00e0nh ch\u1eef hoa b\u1eb1ng c\u00f4ng th\u1ee9c: =UPPER(“h\u1ecdc Excel”)<\/strong>. \u1ea4n ph\u00edm Enter<\/strong> \u0111\u1ec3 chuy\u1ec3n v\u0103n b\u1ea3n th\u00e0nh ch\u1eef in hoa.<\/p>\n

    \"D\u00f9ngChuy\u1ec3n \u0111\u1ed5i c\u1ee5m t\u1eeb “h\u1ecdc Excel” th\u00e0nh ch\u1eef hoa b\u1eb1ng h\u00e0m UPPER<\/em><\/p>\n

    B\u01b0\u1edbc 5:<\/strong> T\u00e1ch ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 B4. D\u00f9ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 l\u1ea5y c\u00e1c k\u00fd t\u1ef1 b\u00ean ph\u1ea3i: =RIGHT(B4, LEN(B4) – C7 – C8<\/strong>.<\/p>\n

    \u1ea4n ph\u00edm Enter<\/strong> \u0111\u1ec3 tr\u00edch xu\u1ea5t ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a chu\u1ed7i.<\/p>\n

    \"D\u00f9ngT\u00e1ch ph\u1ea7n v\u0103n b\u1ea3n b\u00ean ph\u1ea3i c\u1ee5m t\u1eeb “h\u1ecdc Excel” b\u1eb1ng h\u00e0m RIGHT<\/em><\/p>\n

    B\u01b0\u1edbc 6:<\/strong> K\u1ebft h\u1ee3p c\u00e1c ph\u1ea7n \u0111\u00e3 t\u00e1ch l\u1ea1i th\u00e0nh m\u1ed9t chu\u1ed7i ho\u00e0n ch\u1ec9nh. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: =C9 & C10 & C11<\/strong><\/p>\n

    \u1ea4n Enter<\/strong> \u0111\u1ec3 gh\u00e9p c\u00e1c ph\u1ea7n \u0111\u00e3 t\u00e1ch v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng.<\/p>\n

    K\u1ebft h\u1ee3p c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nh\u1eefng h\u00e0m v\u1eeba t\u00ecm \u0111\u01b0\u1ee3c \u0111\u1ec3 vi\u1ebft in hoa ch\u1eef \"h\u1ecdc Excel\" trong chu\u1ed7i v\u0103n b\u1ea3nGh\u00e9p c\u00e1c ph\u1ea7n \u0111\u00e3 t\u00e1ch l\u1ea1i v\u1edbi nhau s\u1eed d\u1ee5ng to\u00e1n t\u1eed<\/em><\/p>\n

    \n

    3.2 H\u00e0m SUBSTITUTE<\/h3>\n<\/div>\n

    H\u00e0m SUBSTITUTE gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng thay th\u1ebf m\u1ed9t ph\u1ea7n v\u0103n b\u1ea3n trong chu\u1ed7i b\u1eb1ng m\u1ed9t ph\u1ea7n v\u0103n b\u1ea3n kh\u00e1c.<\/p>\n

    C\u00fa ph\u00e1p c\u1ee7a h\u00e0m nh\u01b0 sau: =SUBSTITUTE(text, “old text”, UPPER(“new text”))<\/strong><\/p>\n

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

      \n
    • text:<\/strong> L\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ban \u0111\u1ea7u.<\/li>\n
    • old text:<\/strong> Ph\u1ea7n v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n thay th\u1ebf.<\/li>\n
    • new text:<\/strong> Ph\u1ea7n v\u0103n b\u1ea3n m\u1edbi thay th\u1ebf.<\/li>\n<\/ul>\n

      \"S\u1eedV\u00ed d\u1ee5 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m UPPER v\u00e0 h\u00e0m SUBSTITUTE<\/em><\/p>\n

      \n

      4. C\u00e1ch kh\u1eafc ph\u1ee5c khi s\u1eed d\u1ee5ng h\u00e0m UPPER b\u1ecb l\u1ed7i ph\u00f4ng ch\u1eef<\/h2>\n<\/div>\n

      Khi s\u1eed d\u1ee5ng h\u00e0m UPPER trong Excel, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i v\u1ea5n \u0111\u1ec1 hi\u1ec3n th\u1ecb sai font ch\u1eef, \u0111\u1eb7c bi\u1ec7t v\u1edbi c\u00e1c ng\u00f4n ng\u1eef c\u00f3 d\u1ea5u nh\u01b0 ti\u1ebfng Vi\u1ec7t. \u0110\u1ec3 kh\u1eafc ph\u1ee5c v\u1ea5n \u0111\u1ec1 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p sau:<\/p>\n

        \n
      • Ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng font ch\u1eef:<\/strong> \u0110\u1ea3m b\u1ea3o font ch\u1eef b\u1ea1n s\u1eed d\u1ee5ng h\u1ed7 tr\u1ee3 k\u00fd t\u1ef1 vi\u1ebft hoa \u0111\u1ec3 tr\u00e1nh l\u1ed7i hi\u1ec3n th\u1ecb.<\/li>\n
      • Th\u1eed \u0111\u1ed5i font ch\u1eef:<\/strong> H\u00e3y th\u1eed s\u1eed d\u1ee5ng c\u00e1c font nh\u01b0 Arial, Calibri ho\u1eb7c Times New Roman \u0111\u1ec3 xem k\u1ebft qu\u1ea3 c\u00f3 ch\u00ednh x\u00e1c kh\u00f4ng.<\/li>\n
      • C\u00e0i l\u1ea1i font ch\u1eef:<\/strong> T\u1ea3i v\u00e0 c\u00e0i \u0111\u1eb7t l\u1ea1i font ch\u1eef b\u1ecb l\u1ed7i \u0111\u1ec3 s\u1eeda l\u1ed7i hi\u1ec3n th\u1ecb.<\/li>\n
      • Ki\u1ec3m tra m\u00e3 k\u00fd t\u1ef1 Unicode:<\/strong> M\u1ed9t s\u1ed1 font kh\u00f4ng h\u1ed7 tr\u1ee3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c k\u00fd t\u1ef1 Unicode, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y l\u1ed7i khi chuy\u1ec3n v\u0103n b\u1ea3n sang ch\u1eef hoa.<\/li>\n<\/ul>\n

        V\u1edbi h\u00e0m UPPER, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef hoa trong Excel, gi\u00fap t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u. H\u00e3y th\u1eed \u00e1p d\u1ee5ng ngay h\u00f4m nay \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. \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 h\u1eefu \u00edch!<\/p>\n

        N\u1ebfu b\u1ea1n c\u1ea7n thi\u1ebft b\u1ecb h\u1ed7 tr\u1ee3 c\u00f4ng vi\u1ec7c, \u0111\u1eebng qu\u00ean li\u00ean h\u1ec7 mua m\u00e1y t\u00ednh b\u1ea3ng, \u0111i\u1ec7n tho\u1ea1i 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 H\u00e0m UPPER trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef hoa m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong c\u00e1c t\u00e1c v\u1ee5 x\u1eed l\u00fd d\u1eef li\u1ec7u, h\u00e0m n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng chu\u1ea9n h\u00f3a th\u00f4ng tin, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c danh s\u00e1ch […]<\/p>\n","protected":false},"author":1,"featured_media":5516,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5515","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\/19484.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5515","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=5515"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5515\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5516"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}