{"id":8749,"date":"2021-08-25T12:34:54","date_gmt":"2021-08-25T05:34:54","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8749"},"modified":"2021-08-25T12:57:17","modified_gmt":"2021-08-25T05:57:17","slug":"su-dung-ham-upper-va-ham-proper-de-doi-chu-thuong-thanh-chu-hoa-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/su-dung-ham-upper-va-ham-proper-de-doi-chu-thuong-thanh-chu-hoa-trong-excel\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m Upper v\u00e0 h\u00e0m Proper \u0111\u1ec3 \u0111\u1ed5i ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa trong Excel"},"content":{"rendered":"

1. C\u00f4ng th\u1ee9c h\u00e0m UPPER<\/strong><\/h3>\n

H\u00e0m UPPER \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong m\u1ed9t ch\u1eef vi\u1ebft in th\u01b0\u1eddng sang t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 in hoa.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m UPPER \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau:UPPER:= UPPER(text)<\/strong><\/p>\n

2. C\u00e1ch chuy\u1ec3n ch\u1eef th\u01b0\u1eddng hoa th\u00e0nh in hoa<\/strong><\/h3>\n

B\u01b0\u1edbc 1: N\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i ch\u1eef, h\u00e3y m\u1edf b\u1ea3ng n\u1ed9i dung Excel n\u00f3 ch\u1ee9a n\u1ed9i dung \u0111\u00f3. Sau \u0111\u00f3, ti\u1ebfp t\u1ee5c so\u1ea1n c\u00f4ng th\u1ee9c =UPPER(\u00f4 tr\u1ed1ng ch\u1ee9a k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n chuy\u1ec3n) ngay t\u1ea1i b\u1ea5t k\u1ef3 \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n

\"c\u00e1ch<\/p>\n

B\u01b0\u1edbc 2: \u1ea4n n\u00fat \u201cEnter\u201d, k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea3ng excel s\u1ebd cho ra ch\u1eef hoa sang ch\u1eef th\u01b0\u1eddng.<\/p>\n

\"c\u00e1ch<\/p>\n

Ti\u1ebfp t\u1ee5c nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u201cch\u1eef th\u1eadp\u201d b\u00ean ph\u1ea3i c\u1ee7a \u00f4, sau \u0111\u00f3 k\u00e9o li\u00ean t\u1ee5c \u1ea5n chu\u1ed9t tr\u00e1i v\u00e0 k\u00e9o xu\u1ed1ng c\u00e1c d\u00f2ng d\u01b0\u1edbi. K\u1ebft qu\u1ea3 cho ra ch\u1eef th\u01b0\u1eddng chuy\u1ec3n sang ch\u1eef hoa nh\u01b0 mong mu\u1ed1n.<\/p>\n

\"c\u00e1ch<\/p>\n

C\u00e1ch chuy\u1ec3n \u0111\u1ed5i ch\u1eef th\u01b0\u1eddng th\u00e0nh sang ch\u1eef hoa trong Excel\u00a0 b\u1eb1ng h\u00e0m Proper<\/strong><\/h2>\n

V\u1edbi c\u00e1ch n\u00e0y, b\u1ea1n ch\u1ec9 chuy\u1ec3n k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa ch\u1ee9 kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong c\u00f9ng m\u1ed9t ch\u1eef.<\/p>\n

1. C\u00f4ng th\u1ee9c h\u00e0m Proper<\/strong><\/h3>\n

V\u00ed d\u1ee5: nguy\u1ec5n v\u0103n anh = Nguy\u1ec5n V\u0103n Anh<\/p>\n

H\u00e0m Proper \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong m\u1ed9t ch\u1eef th\u01b0\u1eddng sang k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean in hoa.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Proper \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0\u00a0sau:\u00a0PROPER:=PROPER(Text)<\/strong><\/p>\n

Vd: =PROPER(A1) (trong A1 ch\u1ee9a d\u00f2ng nguy\u1ec5n v\u0103n anh).<\/p>\n

2. C\u00e1ch chuy\u1ec3n ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef in hoa<\/strong><\/h3>\n

B\u01b0\u1edbc 1:\u00a0 N\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i ch\u1eef, h\u00e3y m\u1edf b\u1ea3ng n\u1ed9i dung Excel n\u00f3 ch\u1ee9a n\u1ed9i dung \u0111\u00f3. Sau \u0111\u00f3, ti\u1ebfp t\u1ee5c so\u1ea1n c\u00f4ng th\u1ee9c =PROPER(\u00f4 tr\u1ed1ng ch\u1ee9a k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n chuy\u1ec3n) ngay t\u1ea1i b\u1ea5t k\u1ef3 \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n

\"c\u00e1ch<\/p>\n

B\u01b0\u1edbc 2: \u1ea4n n\u00fat \u201cEnter\u201d, k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea3ng excel s\u1ebd cho ra ch\u1eef hoa sang ch\u1eef th\u01b0\u1eddng.<\/p>\n

\"c\u00e1ch<\/p>\n

Ti\u1ebfp t\u1ee5c nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u201cch\u1eef th\u1eadp\u201d b\u00ean ph\u1ea3i c\u1ee7a \u00f4, sau \u0111\u00f3 k\u00e9o li\u00ean t\u1ee5c \u1ea5n chu\u1ed9t tr\u00e1i v\u00e0 k\u00e9o xu\u1ed1ng c\u00e1c d\u00f2ng d\u01b0\u1edbi. K\u1ebft qu\u1ea3 cho ra ch\u1eef th\u01b0\u1eddng chuy\u1ec3n sang ch\u1eef hoa nh\u01b0 mong mu\u1ed1n.<\/p>\n

\"c\u00e1ch<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

1. C\u00f4ng th\u1ee9c h\u00e0m UPPER H\u00e0m UPPER \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong m\u1ed9t ch\u1eef vi\u1ebft in th\u01b0\u1eddng sang t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 in hoa. C\u00f4ng th\u1ee9c h\u00e0m UPPER \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau:UPPER:= UPPER(text) 2. C\u00e1ch chuy\u1ec3n ch\u1eef th\u01b0\u1eddng hoa th\u00e0nh in hoa B\u01b0\u1edbc 1: N\u1ebfu […]<\/p>\n","protected":false},"author":3,"featured_media":8751,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-8749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8749"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8749\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8751"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}