{"id":4327,"date":"2024-12-04T18:32:25","date_gmt":"2024-12-04T18:32:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-cach-su-dung-ham-upper-trong-excel\/"},"modified":"2024-12-04T18:32:25","modified_gmt":"2024-12-04T18:32:25","slug":"huong-dan-cach-su-dung-ham-upper-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-cach-su-dung-ham-upper-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UPPER trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m UPPER l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u\u00a0\u0111\u1eb7c tr\u01b0ng trong\u00a0Excel. T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m UPPER l\u00e0 chuy\u1ec3n ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef in hoa. Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m UPPER trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6750a03912807\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-upper-trong-excel.html#Cau_truc_ham_UPPER\" title=\"C\u1ea5u tr\u00fac h\u00e0m UPPER\">C\u1ea5u tr\u00fac h\u00e0m UPPER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-upper-trong-excel.html#Ung_dung_ham_UPPER\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m UPPER\">\u1ee8ng d\u1ee5ng h\u00e0m UPPER<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-upper-trong-excel.html#Viet_hoa_doan_text_nam_giua_trong_chuoi_van_ban\" title=\"Vi\u1ebft hoa\u00a0\u0111o\u1ea1n text n\u1eb1m gi\u1eefa trong chu\u1ed7i v\u0103n b\u1ea3n\">Vi\u1ebft hoa\u00a0\u0111o\u1ea1n text n\u1eb1m gi\u1eefa trong chu\u1ed7i v\u0103n b\u1ea3n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_ham_UPPER\"><\/span>C\u1ea5u tr\u00fac h\u00e0m UPPER<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi mu\u1ed1n d\u00f9ng h\u00e0m UPPER\u00a0\u0111\u1ec3 chuy\u1ec3n\u00a0\u0111o\u1ea1n text trong\u00a0\u00f4 A1 t\u1eeb\u00a0 ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef in hoa, ta vi\u1ebft\u00a0h\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25502\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/upper.png\" width=\"414\" height=\"244\" title=\"upper\"><\/p>\n<p>Khi s\u1eed d\u1ee5ng trong\u00a0Excel nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25503\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-upper-chuyen-chu-thuong-thanh-chu-in-hoa.png\" width=\"472\" height=\"107\" title=\"vi-du-ham-upper-chuyen-chu-thuong-thanh-chu-in-hoa\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 l\u00e0\u00a0\u0111o\u1ea1n text trong\u00a0\u00f4 A1\u00a0\u0111\u00e3 chuy\u1ec3n th\u00e0nh\u00a0\u0111o\u1ea1n text\u00a0\u0111\u01b0\u1ee3c vi\u1ebft hoa to\u00e0n b\u1ed9 t\u1ea1i\u00a0\u00f4 B2 v\u1edbi h\u00e0m UPPER<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_ham_UPPER\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m UPPER<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Viet_hoa_doan_text_nam_giua_trong_chuoi_van_ban\"><\/span>Vi\u1ebft hoa\u00a0\u0111o\u1ea1n text n\u1eb1m gi\u1eefa trong chu\u1ed7i v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3\u00a0\u0111o\u1ea1n text t\u1ea1i\u00a0\u00f4 A2 l\u00e0 \u201ch\u1ecdc\u00a0excel online\u201d<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-346.gif\" title=\"ex101_92019-nho-346\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Y\u00eau c\u1ea7u l\u00e0 ph\u1ea3i d\u00f9ng h\u00e0m, c\u00f4ng th\u1ee9c trong Excel\u00a0\u0111\u1ec3 chuy\u1ec3n\u00a0\u0111o\u1ea1n text t\u1ea1i\u00a0\u00f4 A2 th\u00e0nh h\u1ecdc\u00a0EXCEL online (c\u00f3 vi\u1ebft hoa ch\u1eef\u00a0EXCEL)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25504\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-viet-hoa-ky-tu-nam-giua-doan-text.png\" width=\"516\" height=\"88\" title=\"yeu-cau-viet-hoa-ky-tu-nam-giua-doan-text\"><\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25505\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-viet-hoa-ky-tu-nam-giua-doan-text-cach-thuc-hien.png\" width=\"773\" height=\"347\" title=\"yeu-cau-viet-hoa-ky-tu-nam-giua-doan-text-cach-thuc-hien\"><\/p>\n<p style=\"padding-left: 30px\">B\u01b0\u1edbc 1: S\u1eed d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-search-trong-excel-cach-dung-va-vi-du.html\">SEARCH<\/a> v\u00e0 h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\">LEN<\/a>\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed v\u00e0\u00a0\u0111\u1ed9 d\u00e0i\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 c\u1ea7n vi\u1ebft hoa l\u00e0 \u201cexcel\u201d<\/p>\n<p style=\"padding-left: 30px\">B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\">LEFT<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\">RIGHT<\/a>\u00a0\u0111\u1ec3 t\u00e1ch ph\u1ea7n k\u00fd t\u1ef1 b\u00ean tr\u00e1i v\u00e0 b\u00ean ph\u1ea3i ch\u1eef\u00a0Excel<\/p>\n<p style=\"padding-left: 30px\">B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n vi\u1ebft hoa ch\u1eef\u00a0excel v\u1edbi <strong>h\u00e0m UPPER<\/strong><\/p>\n<p style=\"padding-left: 30px\">B\u01b0\u1edbc 4: N\u1ed1i c\u00e1c k\u00fd t\u1ef1 l\u1ea1i v\u1edbi nhau b\u1edfi d\u1ea5u &amp;, c\u00f3 k\u00e8m th\u00eam d\u1ea5u c\u00e1ch\u00a0\u1edf m\u1ed7i\u00a0\u0111o\u1ea1n n\u1ed1i<\/p>\n<p style=\"padding-left: 30px\">B\u01b0\u1edbc 5: S\u1eed d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\">TRIM<\/a>\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch th\u1eeba sau khi n\u1ed1i (n\u1ebfu c\u00f3)<\/p>\n<p>Trong nguy\u00ean t\u1eafc x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng text, th\u00f4ng th\u01b0\u1eddng ch\u00fang ta ph\u1ea3i k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m l\u1ea1i v\u1edbi nhau ch\u1ee9 kh\u00f4ng ch\u1ec9 d\u00f9ng 1 h\u00e0m ri\u00eang l\u1ebb. C\u00e1c h\u00e0m th\u01b0\u1eddng xuy\u00ean\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0 LEFT, MID, RIGHT, LEN, TRIM, PROPER, UPPER, LOWER, SEARCH\u2026 do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1ed1t d\u1eef li\u1ec7u d\u1ea1ng text, c\u00e1c b\u1ea1n c\u1ea7n n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m n\u00e0y\u00a0\u0111\u1ec3\u00a0\u1ee9ng d\u1ee5ng t\u1ed1t trong c\u00e1c t\u00ecnh hu\u1ed1ng c\u1ee5 th\u1ec3.<\/p>\n<p>T\u00ecm hi\u1ec3u th\u00eam m\u1ed9t s\u1ed1 h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng text:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html\">H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch thay \u0111\u1ed5i ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel 2016, 2013, 2010<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT n\u00e2ng cao k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html\">C\u00e1c H\u00e0m Text Trong Excel: 19 C\u00e1ch Gi\u00fap X\u1eed L\u00fd V\u0103n B\u1ea3n Hi\u1ec7u Qu\u1ea3<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-346.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4328,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4327"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4327\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4328"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}