{"id":1963,"date":"2024-12-02T06:37:59","date_gmt":"2024-12-02T06:37:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-ham-chuyen-doi-kieu-chu-trong-excel\/"},"modified":"2024-12-02T06:37:59","modified_gmt":"2024-12-02T06:37:59","slug":"cac-ham-chuyen-doi-kieu-chu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-ham-chuyen-doi-kieu-chu-trong-excel\/","title":{"rendered":"C\u00e1c h\u00e0m chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u ch\u1eef trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong khi l\u00e0m vi\u1ec7c v\u1edbi Excel, vi\u1ec7c chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u ch\u1eef trong v\u0103n b\u1ea3n l\u00e0 kh\u00e1 c\u1ea7n thi\u1ebft v\u00e0 n\u00f3 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi thao t\u00e1c v\u00e0 x\u1eed l\u00fd nh\u1eefng chu\u1ed7i k\u00ed t\u1ef1.<\/em><\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n ba h\u00e0m chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u ch\u1eef: <strong>LOWER(), UPPER() v\u00e0 PROPER().<\/strong><\/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-674d55c656f63\" 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-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html#1_LOWER\" title=\"1. LOWER\">1. LOWER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html#Cu_phap_LOWERtext\" title=\"C\u00fa ph\u00e1p: \u00a0=LOWER(text)\">C\u00fa ph\u00e1p: \u00a0=LOWER(text)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html#2_UPPER\" title=\"2. UPPER\">2. UPPER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html#Cu_phap_UPPERtext\" title=\"C\u00fa ph\u00e1p:\u00a0=UPPER(text)\">C\u00fa ph\u00e1p:\u00a0=UPPER(text)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html#3_PROPER\" title=\"3. PROPER\">3. PROPER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html#Cu_phap_PROPERtext\" title=\"C\u00fa ph\u00e1p:\u00a0=PROPER(text)\">C\u00fa ph\u00e1p:\u00a0=PROPER(text)<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_LOWER\"><\/span>1. LOWER<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">H\u00e0m LOWER() chuy\u1ec3n t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i v\u0103n b\u1ea3n (text) th\u00e0nh ch\u1eef th\u01b0\u1eddng, gi\u00fap c\u00e1c b\u1ea1n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<p>Xem th\u00eam:<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-doi-font-chu-mac-dinh-trong-excel-2007-2010-2013-2016.html\">C\u00e1ch \u0111\u1ed5i font ch\u1eef<\/a> m\u1eb7c \u0111\u1ecbnh trong Word\u00a0<\/strong><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_LOWERtext\"><\/span>C\u00fa ph\u00e1p: \u00a0<strong>=LOWER(text)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3:<\/em><\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>text:<\/em><\/strong> l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 c\u00e1c b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh ch\u1eef th\u01b0\u1eddng. Text c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3841 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-7-1.png\" width=\"600\" height=\"412\" title=\"1-7-1\"><\/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-144.gif\" title=\"ex101_92019-nho-144\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_UPPER\"><\/span>2. UPPER<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">H\u00e0m UPPER() gi\u00fap c\u00e1c b\u1ea1n chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n (text) th\u00e0nh ch\u1eef hoa.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_UPPERtext\"><\/span>C\u00fa ph\u00e1p:\u00a0<strong>=UPPER(text)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3:<\/em><\/p>\n<ul style=\"text-align: justify\">\n<li><em><strong>text<\/strong>\u00a0:\u00a0<\/em>l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n c\u00e1c b\u1ea1n mu\u1ed1n chuy\u1ec3n t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 sang ch\u1eef hoa. Text c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn chu\u1ed7i ho\u1eb7c m\u1ed9t chu\u1ed7i.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3842 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-8.png\" width=\"600\" height=\"413\" title=\"1-8\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_PROPER\"><\/span>3. PROPER<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">H\u00e0m PROPER() gi\u00fap vi\u1ebft hoa ch\u1eef th\u1ee9 nh\u1ea5t trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n n\u1ebfu tr\u01b0\u1edbc n\u00f3 l\u00e0 m\u1ed9t k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef (v\u00ed d\u1ee5 kho\u1ea3ng tr\u1eafng) v\u00e0 chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef kh\u00e1c th\u00e0nh ch\u1eef th\u01b0\u1eddng.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_PROPERtext\"><\/span>C\u00fa ph\u00e1p:\u00a0<strong>=PROPER(text)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3:<\/em><\/p>\n<ul style=\"text-align: justify\">\n<li><em><strong>text<\/strong>\u00a0:\u00a0<\/em>l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n vi\u1ebft hoa ch\u1eef th\u1ee9 nh\u1ea5t v\u00e0 l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c. text c\u00f3 th\u1ec3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n, m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 v\u0103n b\u1ea3n ho\u1eb7c tham chi\u1ebfu \u00f4 t\u1edbi chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3843 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-9-1.png\" width=\"600\" height=\"394\" title=\"1-9-1\"><\/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-144.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1963","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\/1963","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=1963"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1963\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1964"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}