{"id":5428,"date":"2024-12-16T02:36:28","date_gmt":"2024-12-16T02:36:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-chuyen-phan-so-bi-luu-dang-text-ve-so-thap-phan\/"},"modified":"2024-12-16T02:36:28","modified_gmt":"2024-12-16T02:36:28","slug":"cach-chuyen-phan-so-bi-luu-dang-text-ve-so-thap-phan","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-chuyen-phan-so-bi-luu-dang-text-ve-so-thap-phan\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n ph\u00e2n s\u1ed1 b\u1ecb l\u01b0u d\u1ea1ng text v\u1ec1 s\u1ed1 th\u1eadp ph\u00e2n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong qu\u00e1 tr\u00ecnh sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb 1 file kh\u00e1c v\u00e0o 1 file\u00a0excel,\u00a0\u0111\u00f4i khi d\u1eef li\u1ec7u kh\u00f4ng tr\u1ea3 v\u1ec1\u00a0\u0111\u00fang lo\u1ea1i d\u1eef li\u1ec7u mong mu\u1ed1n,\u00a0\u0111\u1eb7c bi\u1ec7t l\u00e0 v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, s\u1ed1 th\u1eadp ph\u00e2n.\u00a0\u0110i\u1ec1u n\u00e0y\u00a0\u1ea3nh h\u01b0\u1edfng nhi\u1ec1u t\u1edbi qu\u00e1 tr\u00ecnh x\u1eed l\u00fd v\u00e0 t\u00ednh to\u00e1n trong\u00a0excel. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online\u00a0t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch chuy\u1ec3n ph\u00e2n s\u1ed1 b\u1ecb l\u01b0u d\u1ea1ng text v\u1ec1 d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n th\u00f4ng qua v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14441 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chuye1bb83n-de1baa1ng-text-ve1bb81-de1baa1ng-the1baadp-phc3a2n.png\" width=\"282\" height=\"144\" title=\"chuye1bb83n-de1baa1ng-text-ve1bb81-de1baa1ng-the1baadp-phc3a2n\"><\/p>\n<p>C\u1ed9t A ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb ph\u00e2n s\u1ed1 m\u00e0 theo m\u1eaft th\u01b0\u1eddng ch\u00fang ta nh\u00ecn th\u1ea5y<\/p>\n<p>C\u1ed9t B ch\u1ee9a c\u00e1c c\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c t\u00ednh to\u00e1n t\u1eeb c\u1ed9t A<\/p>\n<p>C\u1ed9t C di\u1ec5n gi\u1ea3i c\u00f4ng th\u1ee9c n\u1eb1m trong c\u1ed9t B<\/p>\n<p>V\u1eady b\u1ea1n c\u00f3 bi\u1ebft t\u1ea1i sao l\u1ea1i xu\u1ea5t hi\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0\u00a0\u1edf c\u1ed9t B kh\u00f4ng? L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 chuy\u1ec3n c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n\u00a0\u1edf c\u1ed9t A v\u1ec1\u00a0\u0111\u00fang d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n\u00a0\u0111\u1ec3 cho ra c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u00fang\u00a0\u1edf c\u1ed9t B? Sau\u00a0\u0111\u00e2y\u00a0l\u00e0 1 c\u00e1ch kh\u1eafc ph\u1ee5c b\u1eb1ng h\u00e0m t\u1ef1 t\u1ea1o trong VBA c\u1ee7a H\u1ecdc\u00a0Excel Online:<\/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-675f922c0c478\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-phan-bi-luu-dang-text-ve-thap-phan.html#Buoc_1_Mo_cua_so_Visual_Basic_Application_VBA\" title=\"B\u01b0\u1edbc 1: M\u1edf c\u1eeda s\u1ed5 Visual Basic Application (VBA)\">B\u01b0\u1edbc 1: M\u1edf c\u1eeda s\u1ed5 Visual Basic Application (VBA)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-phan-bi-luu-dang-text-ve-thap-phan.html#Buoc_2_Tao_moi_1_Module\" title=\"B\u01b0\u1edbc 2: T\u1ea1o m\u1edbi 1 Module\">B\u01b0\u1edbc 2: T\u1ea1o m\u1edbi 1 Module<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-phan-bi-luu-dang-text-ve-thap-phan.html#Buoc_3_Tao_ham_trong_VBA_de_dinh_dang_lai_du_lieu\" title=\"B\u01b0\u1edbc 3: T\u1ea1o\u00a0h\u00e0m trong VBA\u00a0\u0111\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u\">B\u01b0\u1edbc 3: T\u1ea1o\u00a0h\u00e0m trong VBA\u00a0\u0111\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-phan-bi-luu-dang-text-ve-thap-phan.html#Buoc_4_Cach_su_dung_ham_EVAL\" title=\"B\u01b0\u1edbc 4: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m EVAL\">B\u01b0\u1edbc 4: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m EVAL<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Mo_cua_so_Visual_Basic_Application_VBA\"><\/span>B\u01b0\u1edbc 1: M\u1edf c\u1eeda s\u1ed5 Visual Basic Application (VBA)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 2 c\u00e1ch\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 VBA:<\/p>\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-190.gif\" title=\"vba101_92019-nho-190\"><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-469.gif\" title=\"ex101_92019-nho-469\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>C\u00e1ch 1: B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Alt + F11<\/li>\n<li>C\u00e1ch 2: Trong tab Developer, b\u1ea5m ch\u1ecdn Visual Basic<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Tao_moi_1_Module\"><\/span>B\u01b0\u1edbc 2: T\u1ea1o m\u1edbi 1 Module<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ee5c Project \u2013 VBAProject r\u1ed3i ch\u1ecdn\u00a0Insert \/ Module<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14446\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-vba-eval-01-2.png\" width=\"480\" height=\"598\" title=\"heo-vba-eval-01-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Tao_ham_trong_VBA_de_dinh_dang_lai_du_lieu\"><\/span>B\u01b0\u1edbc 3: T\u1ea1o\u00a0h\u00e0m trong VBA\u00a0\u0111\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Module 1 v\u1eeba t\u1ea1o, ch\u00fang ta d\u00f9ng l\u1ec7nh Function\u00a0\u0111\u1ec3 t\u1ea1o ra 1 h\u00e0m.<\/p>\n<p>H\u00e0m c\u00f3 t\u00ean l\u00e0 EVAL, s\u1eed d\u1ee5ng\u00a0\u0111\u1ed1i s\u1ed1 l\u00e0 Range (l\u1ea5y t\u1eeb 1\u00a0\u00f4 n\u00e0o\u00a0\u0111\u00f3 trong\u00a0excel)<\/p>\n<blockquote>\n<p>EVAL = Evaluate(Range.Value)<\/p>\n<\/blockquote>\n<p>Evaluate l\u00e0 vi\u1ec7c\u00a0\u0111\u00e1nh gi\u00e1,\u00a0\u0111\u1ecbnh h\u00ecnh l\u1ea1i d\u1eef li\u1ec7u v\u1ec1\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng m\u00e0 n\u00f3\u00a0\u0111ang hi\u1ec3n th\u1ecb.<\/p>\n<p>Tham s\u1ed1 trong Evaluate l\u00e0 Range.Value th\u1ec3 hi\u1ec7n l\u00e0 ch\u1ec9\u00a0\u0111\u1ecbnh d\u1ea1ng v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a n\u1ed9i dung b\u00ean trong Range<\/p>\n<p>V\u00ed d\u1ee5: D\u1eef li\u1ec7u hi\u1ec3n th\u1ecb l\u00e0 3\/7 s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh gi\u00e1 l\u00e0 s\u1ed1 th\u1eadp ph\u00e2n (3 ph\u1ea7n 7)\u00a0ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 ng\u00e0y 03 th\u00e1ng 07.<\/p>\n<p>C\u1ea5u tr\u00fac\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 c\u1ee7a Function nh\u01b0 sau:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/51c593fc101505b5f8bf94897b5f1e47\">Gist<\/a>.<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_4_Cach_su_dung_ham_EVAL\"><\/span>B\u01b0\u1edbc 4: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m EVAL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch s\u1eed d\u1ee5ng r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n: trong\u00a0\u00f4 B1 ch\u00fang ta vi\u1ebft =Eval(A1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14447\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-vba-eval-02.png\" width=\"319\" height=\"167\" title=\"heo-vba-eval-02\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y h\u00e0m Eval v\u1eeba t\u1ea1o ra\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 gi\u00fap ch\u00fang ta\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0\u0111\u00fang d\u1eef li\u1ec7u nh\u01b0 ch\u00fang ta mong mu\u1ed1n.<\/p>\n<p>Video h\u01b0\u1edbng d\u1eabn:<\/p>\n<iframe loading=\"lazy\" title=\"Ha\u0300m chuye\u0302\u0309n pha\u0302n so\u0302\u0301 bi\u0323 lu\u031bu da\u0323ng text ve\u0302\u0300 so\u0302\u0301 tha\u0323\u0302p pha\u0302n\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/K69XtqkjgPc?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online<\/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\/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-190.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5429,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5428","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\/5428","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=5428"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5428\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5429"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}