{"id":5495,"date":"2025-11-27T18:29:45","date_gmt":"2025-11-27T11:29:45","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-lower-trong-excel-don-gian-cho-nguoi-moi\/"},"modified":"2025-11-27T18:29:45","modified_gmt":"2025-11-27T11:29:45","slug":"cach-su-dung-ham-lower-trong-excel-don-gian-cho-nguoi-moi","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-lower-trong-excel-don-gian-cho-nguoi-moi\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LOWER trong Excel \u0111\u01a1n gi\u1ea3n cho ng\u01b0\u1eddi m\u1edbi"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LOWER trong Excel gi\u00fap b\u1ea1n chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u nhanh v\u00e0 nh\u1ea5t qu\u00e1n, \u0111\u1eb7c bi\u1ec7t khi x\u1eed l\u00fd c\u00e1c b\u1ea3ng th\u00f4ng tin c\u00f3 nhi\u1ec1u ki\u1ec3u ch\u1eef kh\u00e1c nhau. H\u00e0m LOWER h\u1ed7 tr\u1ee3 chuy\u1ec3n v\u0103n b\u1ea3n v\u1ec1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng, gi\u00fap d\u1eef li\u1ec7u d\u1ec5 \u0111\u1ecdc v\u00e0 \u0111\u1ed3ng b\u1ed9 h\u01a1n. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n \u00e1p d\u1ee5ng h\u00e0m n\u00e0y chi ti\u1ebft v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

\"H\u00e0mH\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m LOWER trong Excel<\/em><\/p>\n

\n

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

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

Trong \u0111\u00f3: text<\/strong> l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c \u00f4 ch\u1ee9a v\u0103n b\u1ea3n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

Khi d\u00f9ng h\u00e0m, m\u1ecdi k\u00fd t\u1ef1 vi\u1ebft hoa s\u1ebd \u0111\u01b0\u1ee3c bi\u1ebfn th\u00e0nh ch\u1eef th\u01b0\u1eddng, gi\u00fap d\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t v\u00e0 d\u1ec5 ki\u1ec3m so\u00e1t h\u01a1n.<\/p>\n

\"C\u00f4ngC\u00fa ph\u00e1p h\u00e0m LOWER trong Excel<\/em><\/p>\n

\n

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

2.1 Chuy\u1ec3n to\u00e0n b\u1ed9 ch\u1eef hoa sang ch\u1eef th\u01b0\u1eddng<\/h3>\n<\/div>\n

V\u00ed d\u1ee5:<\/strong> S\u1eed d\u1ee5ng h\u00e0m LOWER \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 B3, nh\u1eadp c\u00f4ng th\u1ee9c =LOWER(A3)<\/strong> \u0111\u1ec3 chuy\u1ec3n n\u1ed9i dung \u1edf \u00f4 A3 v\u1ec1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng.<\/p>\n

\"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c LOWER v\u00e0o \u00f4 B3<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 sau khi chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

\"K\u1ebftK\u1ebft qu\u1ea3 chuy\u1ec3n ch\u1eef hoa th\u00e0nh ch\u1eef th\u01b0\u1eddng<\/em><\/p>\n

B\u01b0\u1edbc 3:<\/strong> D\u00f9ng tay k\u00e9o fill handle (\u0111u\u00f4i \u00f4) xu\u1ed1ng c\u00e1c d\u00f2ng d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 danh s\u00e1ch c\u00f2n l\u1ea1i.<\/p>\n

\"\u00c1pK\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng danh s\u00e1ch<\/em><\/p>\n

\n

2.2 Chuy\u1ec3n ch\u1eef hoa sang ch\u1eef th\u01b0\u1eddng khi th\u1ee9 t\u1ef1 b\u1ecb x\u00e1o tr\u1ed9n<\/h3>\n<\/div>\n

V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n \u0111\u1ed5i to\u00e0n b\u1ed9 ch\u1eef trong \u0111o\u1ea1n v\u0103n “si\u00eaU Th\u1ecb \u0110I\u1ec7n M\u00e1Y” th\u00e0nh ch\u1eef th\u01b0\u1eddng.<\/p>\n

B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =LOWER(“si\u00eaU Th\u1ecb \u0110I\u1ec7n M\u00e1Y”)<\/strong><\/p>\n

\"S\u1eedNh\u1eadp h\u00e0m LOWER cho v\u0103n b\u1ea3n m\u1eabu<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>, Excel s\u1ebd tr\u1ea3 v\u1ec1 \u0111o\u1ea1n v\u0103n b\u1ea3n \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n h\u1ebft sang ch\u1eef th\u01b0\u1eddng.<\/p>\n

\"K\u1ebftK\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng h\u00e0m LOWER<\/em><\/p>\n

\n

2.3 Chuy\u1ec3n to\u00e0n b\u1ed9 ch\u1eef hoa th\u00e0nh in hoa ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a c\u00e2u<\/h3>\n<\/div>\n

V\u00ed d\u1ee5:<\/strong> Chuy\u1ec3n c\u00e2u \u201cN\u1ed8I TH\u1ea4T CH\u1ee2 L\u1edaN\u201d th\u00e0nh d\u1ea1ng ch\u1ec9 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u<\/p>\n

B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =LEFT(A6) & LOWER(RIGHT(A6, LEN(A6)-1))<\/strong><\/p>\n

Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n

    \n
  • LEFT(A6):<\/strong> L\u1ea5y k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i.<\/li>\n
  • &:<\/strong> D\u00f9ng \u0111\u1ec3 n\u1ed1i c\u00e1c ph\u1ea7n v\u0103n b\u1ea3n.<\/li>\n
  • LOWER(…):<\/strong> Chuy\u1ec3n ph\u1ea7n k\u00fd t\u1ef1 c\u00f2n l\u1ea1i v\u1ec1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng.<\/li>\n
  • RIGHT(A6, LEN(A6)-1):<\/strong> Tr\u00edch to\u00e0n b\u1ed9 chu\u1ed7i tr\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean.<\/li>\n
  • LEN(A6)-1:<\/strong> X\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y sau khi b\u1ecf k\u00fd t\u1ef1 \u0111\u1ea7u.<\/li>\n<\/ul>\n

    \"C\u00f4ngC\u00f4ng th\u1ee9c vi\u1ebft hoa ch\u1eef \u0111\u1ea7u<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3 \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

    \"K\u1ebftK\u1ebft qu\u1ea3 sau chuy\u1ec3n \u0111\u1ed5i ch\u1eef \u0111\u1ea7u<\/em><\/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

    2.4 D\u00f9ng h\u00e0m LOWER, TRIM, LEFT, MID, RIGHT v\u00e0 LEN<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n chuy\u1ec3n c\u00e2u “T\u00d4I MU\u1ed0N H\u1eccC GI\u1eceI EXCEL” v\u1ec1 ch\u1eef th\u01b0\u1eddng, nh\u01b0ng gi\u1eef nguy\u00ean ph\u1ea7n “H\u1eccC GI\u1eceI” \u1edf d\u1ea1ng in hoa.<\/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: =TRIM(LOWER(LEFT(B14,8)) & ” ” & MID(B14,9,9) & ” ” & LOWER(RIGHT(B14, LEN(B14)-18)))<\/strong><\/p>\n

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

      \n
    • TRIM:<\/strong> X\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba trong chu\u1ed7i.<\/li>\n
    • LOWER(LEFT(B14,8)):<\/strong> L\u1ea5y 8 k\u00fd t\u1ef1 \u0111\u1ea7u v\u00e0 chuy\u1ec3n v\u1ec1 ch\u1eef th\u01b0\u1eddng.<\/li>\n
    • &:<\/strong> D\u00f9ng \u0111\u1ec3 n\u1ed1i c\u00e1c \u0111o\u1ea1n v\u0103n b\u1ea3n.<\/li>\n
    • MID(B14,9,9):<\/strong> Tr\u00edch 9 k\u00fd t\u1ef1 \u1edf gi\u1eefa chu\u1ed7i (ph\u1ea7n c\u1ea7n gi\u1eef nguy\u00ean ch\u1eef in hoa).<\/li>\n
    • LOWER(RIGHT(B14, LEN(B14)-18)):<\/strong> Chuy\u1ec3n ph\u1ea7n c\u00f2n l\u1ea1i sau 18 k\u00fd t\u1ef1 \u0111\u1ea7u v\u1ec1 ch\u1eef th\u01b0\u1eddng.<\/li>\n
    • LEN(B14)-18:<\/strong> X\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y \u1edf ph\u1ea7n cu\u1ed1i.<\/li>\n<\/ul>\n

      \"V\u00edC\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p LOWER v\u00e0 c\u00e1c h\u00e0m chu\u1ed7i<\/em><\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3 chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

      \"K\u1ebftK\u1ebft qu\u1ea3 gi\u1eef nguy\u00ean ph\u1ea7n ch\u1eef in hoa<\/em><\/p>\n

      H\u00e0m LOWER gi\u00fap b\u1ea1n thao t\u00e1c v\u0103n b\u1ea3n d\u1ec5 d\u00e0ng h\u01a1n, \u0111\u1eb7c bi\u1ec7t trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n \u0111\u1ed3ng b\u1ed9 \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u cho b\u00e1o c\u00e1o. Khi k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m x\u1eed l\u00fd chu\u1ed7i kh\u00e1c, LOWER c\u00f2n t\u1ea1o ra nhi\u1ec1u c\u00e1ch bi\u1ebfn \u0111\u1ed5i linh ho\u1ea1t h\u01a1n, ph\u00f9 h\u1ee3p cho m\u1ecdi nhu c\u1ea7u l\u00e0m vi\u1ec7c tr\u00ean Excel.<\/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 th\u00f4ng tin h\u1eefu \u00edch.<\/p>\n

      N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel v\u00e0 c\u1ea7n thi\u1ebft b\u1ecb hi\u1ec7u su\u1ea5t cao, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng v\u00e0 \u0111i\u1ec7n tho\u1ea1i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      \u00a0 Hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LOWER trong Excel gi\u00fap b\u1ea1n chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u nhanh v\u00e0 nh\u1ea5t qu\u00e1n, \u0111\u1eb7c bi\u1ec7t khi x\u1eed l\u00fd c\u00e1c b\u1ea3ng th\u00f4ng tin c\u00f3 nhi\u1ec1u ki\u1ec3u ch\u1eef kh\u00e1c nhau. H\u00e0m LOWER h\u1ed7 tr\u1ee3 chuy\u1ec3n v\u0103n b\u1ea3n v\u1ec1 d\u1ea1ng ch\u1eef th\u01b0\u1eddng, gi\u00fap d\u1eef li\u1ec7u d\u1ec5 \u0111\u1ecdc v\u00e0 \u0111\u1ed3ng b\u1ed9 h\u01a1n. […]<\/p>\n","protected":false},"author":1,"featured_media":5496,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5495","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\/19485.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5495","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=5495"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5495\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5496"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}