{"id":5364,"date":"2024-12-16T02:05:56","date_gmt":"2024-12-16T02:05:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-thay-doi-dau-ngan-cach-thanh-phan-trong-ham-tu-sang-dau\/"},"modified":"2024-12-16T02:05:56","modified_gmt":"2024-12-16T02:05:56","slug":"huong-dan-cach-thay-doi-dau-ngan-cach-thanh-phan-trong-ham-tu-sang-dau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-thay-doi-dau-ngan-cach-thanh-phan-trong-ham-tu-sang-dau\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch thay \u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch th\u00e0nh ph\u1ea7n trong h\u00e0m t\u1eeb ; sang d\u1ea5u ,"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u1ea1n c\u00f3\u00a0\u0111ang g\u1eb7p v\u1ea5n\u00a0\u0111\u1ec1 v\u1ec1 vi\u1ec7c d\u00f9ng d\u1ea5u ph\u1ea9y ( , ) hay d\u1ea5u ch\u1ea5m ph\u1ea9y ( ; )\u00a0\u0111\u1ec3 ng\u0103n c\u00e1ch c\u00e1ch th\u00e0nh ph\u1ea7n trong h\u00e0m khi vi\u1ebft h\u00e0m trong\u00a0Excel? B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c, th\u00ec l\u1ea1i g\u1eb7p th\u00f4ng b\u00e1o l\u1ed7i nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. Sau\u00a0\u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft v\u1ea5n\u00a0\u0111\u1ec1\u00a0\u0111\u00f3.<\/em><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/05\/formula-error.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25801 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-error.jpg\" width=\"525\" height=\"227\" title=\"formula-error\"><\/a><\/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-675f8b0356c7a\" 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\/cach-thay-doi-dau-ngan-cach-thanh-phan-trong-ham-tu-cham-phay-sang-dau-phay.html#1_Neu_van_de\" title=\"1. N\u00eau v\u1ea5n\u00a0\u0111\u1ec1\">1. N\u00eau v\u1ea5n\u00a0\u0111\u1ec1<\/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\/cach-thay-doi-dau-ngan-cach-thanh-phan-trong-ham-tu-cham-phay-sang-dau-phay.html#2_Giai_thich_nguyen_nhan\" title=\"2. Gi\u1ea3i th\u00edch nguy\u00ean nh\u00e2n\">2. Gi\u1ea3i th\u00edch nguy\u00ean nh\u00e2n<\/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\/cach-thay-doi-dau-ngan-cach-thanh-phan-trong-ham-tu-cham-phay-sang-dau-phay.html#3_Cach_thay_doi_dau_ngan_cach\" title=\"3. C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch\">3. C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Neu_van_de\"><\/span>1. N\u00eau v\u1ea5n\u00a0\u0111\u1ec1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c, c\u00f9ng phi\u00ean b\u1ea3n Microsoft Office, l\u00fac th\u00ec \u1edf m\u00e1y n\u00e0y b\u1ea1n ph\u1ea3i d\u00f9ng d\u1ea5u ph\u1ea9y, m\u00e1y kh\u00e1c th\u00ec l\u1ea1i d\u00f9ng d\u1ea5u ch\u1ea5m ph\u1ea9y. C\u00f4ng th\u1ee9c t\u00ecm th\u1ea5y tr\u00ean m\u1ea1ng v\u00ec sao h\u1ecd l\u1ea1i \u0111\u1ec3 d\u1ea5u kh\u00e1c m\u00ecnh? Th\u1ef1c t\u1ebf, c\u00f3 2 tr\u01b0\u1eddng h\u1ee3p nh\u01b0 sau:<\/p>\n<p>D\u00f9ng d\u1ea5u ph\u1ea9y ng\u0103n c\u00e1ch th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c (h\u00e0m), l\u00fac n\u00e0y n\u1ebfu b\u1ea1n d\u00f9ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m CHOOSE th\u00ec c\u00e1c tham s\u1ed1 h\u00e0m s\u1ebd l\u00e0: CHOOSE({1,2},\u2026):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17198\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-dau-ngan-cach-ham-dau-phay.png\" width=\"535\" height=\"85\" title=\"heo-dau-ngan-cach-ham-dau-phay\"><\/p>\n<p>D\u00f9ng d\u1ea5u ch\u1ea5m ph\u1ea9y ng\u0103n c\u00e1ch th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c (h\u00e0m), l\u00fac n\u00e0y n\u1ebfu b\u1ea1n d\u00f9ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m CHOOSE th\u00ec c\u00e1c tham s\u1ed1 h\u00e0m s\u1ebd l\u00e0: CHOOSE({12};\u2026)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17200\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-dau-ngan-cach-ham-dau-cham-phay.png\" width=\"540\" height=\"91\" title=\"heo-dau-ngan-cach-ham-dau-cham-phay\"><\/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-462.gif\" title=\"ex101_92019-nho-462\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1ea1i sao l\u1ea1i c\u00f3 2 lo\u1ea1i d\u1ea5u n\u00e0y? T\u1ea1i sao c\u00f3 m\u00e1y t\u00ednh d\u00f9ng d\u1ea5u ph\u1ea9y, c\u00f3 m\u00e1y t\u00ednh l\u1ea1i d\u00f9ng d\u1ea5u ch\u1ea5m ph\u1ea9y? Vi\u1ec7c n\u00e0y s\u1eeda l\u1ea1i nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Giai_thich_nguyen_nhan\"><\/span>2. Gi\u1ea3i th\u00edch nguy\u00ean nh\u00e2n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c n\u00e0y x\u1ea3y ra do vi\u1ec7c s\u1eed d\u1ee5ng quy\u00a0\u01b0\u1edbc bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u\u00a0m\u1eb7c\u00a0\u0111\u1ecbnh trong m\u1ed7i\u00a0m\u00e1y t\u00ednh.<\/p>\n<p>\u0110\u1ec3 ki\u1ec3m tra vi\u1ec7c n\u00e0y ch\u00fang ta v\u00e0o ph\u1ea7n <strong>Control Panel<\/strong> &gt; Ch\u1ecdn <strong>Region (Region and Language)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16987\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/region-01-1.png\" width=\"554\" height=\"710\" title=\"region-01-1\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 <strong>Region<\/strong> ch\u00fang ta b\u1ea5m <strong>Additional Settings\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16988\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/region-02-1.png\" width=\"528\" height=\"755\" title=\"region-02-1\"><\/p>\n<p>Trong m\u1ee5c n\u00e0y ch\u00fa\u00a0\u00fd\u00a0\u1edf ph\u1ea7n <strong>List separator<\/strong>.\u00a0\u0110\u00e2y ch\u00ednh l\u00e0 k\u00fd t\u1ef1 s\u1ebd bi\u1ec3u th\u1ecb ph\u1ea7n ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c\u00a0\u1edf\u00a0Excel<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_thay_doi_dau_ngan_cach\"><\/span>3. C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00e1c thi\u1ebft l\u1eadp trong Region kh\u00f4ng\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi\u00a0Excel, ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp trong m\u1ee5c Option c\u1ee7a\u00a0Excel nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-23769 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-option-dau-ngan-cach.png\" width=\"1034\" height=\"848\" title=\"excel-option-dau-ngan-cach\"><\/p>\n<p>\u00a0<\/p>\n<p>Ch\u1ec9 vi\u1ec7c b\u1ecf d\u1ea5u t\u00edch \u1edf m\u1ee5c Use System separators, sau \u0111\u00f3 thi\u1ebft l\u1eadp d\u1ea5u theo \u00fd mu\u1ed1n. Nh\u01b0 v\u1eady m\u1ecdi thay \u0111\u1ed5i trong h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u1ee7a m\u00e1y t\u00ednh s\u1ebd kh\u00f4ng \u1ea3nh h\u01b0\u1edfng g\u00ec t\u1edbi Excel. C\u00e1ch n\u00e0y c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh ch\u1ea5m trong excel v\u00e0 ng\u01b0\u1ee3c l\u1ea1i \u0111\u1ed5i d\u1ea5u ch\u1ea5m th\u00e0nh d\u1ea5u ph\u1ea9y \u0111\u1ea5y.<\/p>\n<p>R\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p><strong>Xem th\u00eam: \u0110\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-doi-dau-phay-thanh-dau-cham-trong-excel-2003-2007-2010.html\">chuy\u1ec3n d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong excel 2010<\/a><\/strong><\/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-462.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5365,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5364","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\/5364","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=5364"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5364\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5365"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}