{"id":4322,"date":"2024-12-04T17:31:42","date_gmt":"2024-12-04T17:31:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline\/"},"modified":"2024-12-04T17:31:42","modified_gmt":"2024-12-04T17:31:42","slug":"huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n c\u00e1c Front ch\u1eef kh\u00e1c nhau trong Excel s\u1eed d\u1ee5ng Add ins HocExcelOnline"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<hr>\n<p><em>Khi b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t file Excel t\u1eeb m\u1ed9t ng\u01b0\u1eddi kh\u00e1c ho\u1eb7c t\u1ea3i tr\u00ean m\u1ea1ng v\u1ec1 b\u1ea1n kh\u00f4ng th\u1ec3 \u0111\u1ecdc \u0111\u01b0\u1ee3c n\u00f3, b\u1ea1n g\u1eb7p v\u1ea5n \u0111\u1ec1 v\u1ec1 Font ch\u1eef b\u1ea1n \u0111ang lo l\u1eafng v\u00ec \u0111\u00e3 c\u00f3 h\u00e0m \u201cHeochuyenFont\u201d\u00a0 trong Add ins HocExcel Online gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft vi\u1ec7c \u0111\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/em><\/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-675091fdcf79a\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Cau_truc_cua_ham\" title=\"C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Su_dung_ham\" title=\"S\u1eed d\u1ee5ng h\u00e0m\">S\u1eed d\u1ee5ng h\u00e0m<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Doi_so_bat_buoc_cua_ham\" title=\"\u0110\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c c\u1ee7a h\u00e0m.\">\u0110\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c c\u1ee7a h\u00e0m.<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Su_dung_cac_tuy_chon\" title=\"S\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn\">S\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Vi_du_thuc_tien\" title=\"V\u00ed d\u1ee5 th\u1ef1c ti\u1ec5n.\">V\u00ed d\u1ee5 th\u1ef1c ti\u1ec5n.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>D\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c ti\u1ec7n \u00edch t\u1eeb Add ins HocExcel Online b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t Add ins HocExcel Online b\u1ea1n n\u00e0o ch\u01b0a c\u00f3 th\u00ec t\u1ea3i Add ins <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Cau_truc_cua_ham\"><\/span>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<blockquote>\n<p><strong>=HeochuyenFont(Nh\u1eadp v\u00e0o m\u1ed9t v\u00f9ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i,Font c\u1ea7n chuy\u1ec3n \u0111\u1ed5i,Font k\u1ebft qu\u1ea3,T\u00f9y ch\u1ecdn)<\/strong><\/p>\n<\/blockquote>\n<p>V\u00f9ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i l\u00e0 v\u00f9ng b\u1ea1n mu\u1ed1n chuy\u1ec3n font ch\u1eef .<\/p>\n<p>Font c\u1ea7n chuy\u1ec3n \u0111\u1ed5i g\u1ed3m:<\/p>\n<blockquote>\n<p><strong>0.\u00a0UNI\u00a0,\u00a01.VNI,\u00a02.TCVN3,\u00a03.UNI\u00a0T\u1ed5\u00a0H\u1ee3p,\u00a04.UTF-8\u00a0,\u00a05.VN\u00a0CP1258\u00a0,\u00a06.NRC-Decimal,\u00a07.iNotKnown\u00a0,\u00a08.B\u1ecf\u00a0d\u1ea5u <\/strong><\/p>\n<\/blockquote>\n<p>Font k\u1ebft qu\u1ea3\u00a0 sau khi chuy\u1ec3n \u0111\u1ed5i g\u1ed3m nh\u1eefng ki\u1ec3u nh\u01b0 Font c\u1ea7n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<p>T\u00f9y ch\u1ecdn c\u1ee7a h\u00e0m.<\/p>\n<blockquote>\n<p><strong>chen\u00a0=\u00a0y.\u00a0ten\u00a0=\u00a0?\u00a0.\u00a0xoaname\u00a0=\u00a0?.\u00a04:tudong\u00a0=\u00a0y<\/strong><\/p>\n<\/blockquote>\n<h1><span class=\"ez-toc-section\" id=\"Su_dung_ham\"><\/span>S\u1eed d\u1ee5ng h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"Doi_so_bat_buoc_cua_ham\"><\/span>\u0110\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c c\u1ee7a h\u00e0m.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><strong>Nh\u1eadp v\u00e0o m\u1ed9t v\u00f9ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i<\/strong><\/p>\n<\/blockquote>\n<p>V\u00f9ng c\u00f3 Font b\u1ecb l\u1ed7i\u00a0 (kh\u00f4ng \u0111\u1ecdc \u0111\u01b0\u1ee3c.)<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-345.gif\" title=\"ex101_92019-nho-345\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-149.gif\" title=\"vba101_92019-nho-149\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-345.gif\" title=\"ex101_92019-nho-345\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p><strong>Font c\u1ea7n chuy\u1ec3n \u0111\u1ed5i<\/strong><\/p>\n<\/blockquote>\n<p>L\u00e0 font ch\u1eef c\u1ee7a v\u00f9ng c\u1ea7n chuy\u1ec3n(Fon ban d\u1ea7u) g\u1ed3m c\u00e1c ki\u1ec3u ch\u1eef sau (<em>0.\u00a0UNI\u00a0,\u00a01.VNI,\u00a02.TCVN3,\u00a03.UNI\u00a0T\u1ed5\u00a0H\u1ee3p,\u00a04.UTF-8\u00a0,\u00a05.VN\u00a0CP1258\u00a0,\u00a06.NRC-Decimal,\u00a07.iNotKnown\u00a0,\u00a08.B\u1ecf\u00a0d\u1ea5u)<\/em><\/p>\n<blockquote>\n<p><strong>Font k\u1ebft qu\u1ea3<\/strong><\/p>\n<\/blockquote>\n<p>L\u00e0 Font ch\u1eef sau khi ti\u1ebfn h\u00e0nh chuy\u1ec3n \u0111\u1ed5i c\u0169ng bao g\u1ed3m c\u00e1c h\u00e0m<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Su_dung_cac_tuy_chon\"><\/span>S\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<blockquote>\n<p><strong>Chen = y<\/strong><\/p>\n<\/blockquote>\n<p>B\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n v\u00e0o v\u00f9ng gi\u00e1 tr\u1ecb l\u00e0m cho Excel t\u1ef1 \u0111\u1ed9ng co gi\u00e3n m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<blockquote>\n<p><strong>ten\u00a0=\u00a0?<\/strong><\/p>\n<\/blockquote>\n<p>\u0110\u1eb7t t\u00ean(Name Manege) cho v\u00f9ng d\u1eef li\u1ec7u b\u1eb1ng m\u1ed9t t\u00ean b\u1ea5t k\u1ef3 sau khi ch\u1ea1y h\u00e0m.<\/p>\n<blockquote>\n<p><strong>xoaname\u00a0=\u00a0?<\/strong><\/p>\n<\/blockquote>\n<p>X\u00f3a t\u00ean(Name Manege) cho v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u1eb7t t\u00ean sau khi ch\u1ea1y h\u00e0m<\/p>\n<blockquote>\n<p><strong>Tudong = y<\/strong><\/p>\n<\/blockquote>\n<p>T\u1ef1 \u0111\u1ed9ng c\u0103n ch\u1ec9nh cho k\u1ebft qu\u1ea3 v\u1eeba kh\u00edt \u00f4 d\u1eef li\u1ec7u.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Vi_du_thuc_tien\"><\/span>V\u00ed d\u1ee5 th\u1ef1c ti\u1ec5n.<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29823 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2019-09-05_142126.png\" alt=\"cach-chuyen-cac-font-chu-khac-nhau-su-dung-add-ins\" width=\"1566\" height=\"632\" title=\"2019-09-05_142126\"><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng vba \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c Font ch\u1eef v\u1edbi nhau c\u00e1c b\u1ea1n vui l\u00f2ng xem <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-chuyen-font-tcvn3-hay-vni-sang-unicode-trong-excel.html\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><strong>H\u1ecdc Excel Online\u00a0<\/strong>hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm v\u00e0 v\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m \u201cHeochuyenfont\u201d \u0111\u1ec3 chuy\u1ec3n font ch\u1eef m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/p>\n<p>H\u00e3y theo d\u00f5i ch\u00fang t\u00f4i\u00a0\u0111\u1ec3 c\u00f3 nh\u1eefng b\u00e0i vi\u1ebft h\u1eefu \u00edch nh\u00e9.<\/p>\n<hr>\n<p class=\"title single-title entry-title\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac.html\">H\u01af\u1edaNG D\u1eaaN L\u00c0M B\u00c1O C\u00c1O T\u00cdNH H\u00ccNH S\u1eec D\u1ee4NG H\u00d3A \u0110\u01a0N BC26\/AC<\/a><\/p>\n<p class=\"title single-title entry-title\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac.html\">H\u01af\u1edaNG D\u1eaaN L\u1eacP B\u00c1O C\u00c1O T\u00ccNH H\u00ccNH S\u1eec D\u1ee4NG H\u00d3A \u0110\u01a0N BC26\/AC S\u1eec D\u1ee4NG ADD INS HOCEXCEL ONLINE<\/a><\/p>\n<p class=\"title single-title entry-title\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html\">H\u01af\u1edaNG D\u1eaaN L\u1eacP S\u1ed4 NH\u1eacT K\u00dd CHUNG B\u1eb0NG H\u00c0M \u201cHEOSQL\u201d<\/a><\/p>\n<p>\u00a0<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-345.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4323,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4322","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4322","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=4322"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4322\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4323"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}