{"id":8749,"date":"2021-08-25T12:34:54","date_gmt":"2021-08-25T05:34:54","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8749"},"modified":"2026-05-28T14:36:35","modified_gmt":"2026-05-28T07:36:35","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":"<p>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... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"excerpt":{"rendered":"<p>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&#8230;... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"author":3,"featured_media":0,"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","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":1,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8749\/revisions"}],"predecessor-version":[{"id":10591,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8749\/revisions\/10591"}],"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}]}}