{"id":8466,"date":"2024-12-22T14:40:28","date_gmt":"2024-12-22T14:40:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/noi-chuoi-trong-excel-voi-arraytotext\/"},"modified":"2024-12-22T14:40:28","modified_gmt":"2024-12-22T14:40:28","slug":"noi-chuoi-trong-excel-voi-arraytotext","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/noi-chuoi-trong-excel-voi-arraytotext\/","title":{"rendered":"N\u1ed1i chu\u1ed7i trong Excel v\u1edbi ArrayToText"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Vi\u1ec7c n\u1ed1i chu\u1ed7i trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng to\u00e1n t\u1eed \u201c&amp;\u201d ho\u1eb7c b\u1eb1ng h\u00e0m CONCATENATE. Tuy v\u1eady vi\u1ec7c n\u1ed1i nhi\u1ec1u chu\u1ed7i, ho\u1eb7c n\u1ed1i theo \u0111i\u1ec1u ki\u1ec7n l\u00e0 r\u1ea5t kh\u00f3. V\u1edbi h\u00e0m ArrayToText m\u1ecdi vi\u1ec7c s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n nhi\u1ec1u.<\/p>\n<p>\u0110\u1ea7u ti\u00ean t\u1ea3i file mArrayToText.bas theo link sau:\u00a0<a href=\"https:\/\/drive.google.com\/open?id=0B87wpzexmU0UMDJYUmNKNnRfZUk\">T\u1ea1i \u0111\u00e2y<\/a><\/p>\n<p><strong>Import file mArrayToText.bas v\u00e0o vba:<\/strong><\/p>\n<ul>\n<li>ALT+F11.<\/li>\n<li>Chu\u1ed9t ph\u1ea3i v\u00e0o workbook ch\u1ecdn Import File\u2026<\/li>\n<li>Ch\u1ecdn file mArrayToText.bas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-805 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/arraytotext-time-0_00_3727__-1024x576-1.png\" alt=\"N\u1ed1i chu\u1ed7i, Import file\" width=\"1024\" height=\"576\" title=\"arraytotext-time-0_00_3727__-1024x576-1\"><\/p>\n<p><strong>Sau khi Import file th\u00e0nh c\u00f4ng, b\u1ea1n c\u00f3 trong thay h\u00e0m ArrayToText v\u1edbi nguy\u00ean m\u1eabu:<\/strong><\/p>\n<ul>\n<li>ArrayToText(vArray, PhanTach)<\/li>\n<li>Array: M\u1ea3ng, v\u00f9ng,..<\/li>\n<li>PhanTach: ki\u1ec3u text, l\u00e0 d\u1ea5u ph\u00e2n t\u00e1ch, b\u1ecf qua s\u1ebd l\u00e0 \u201c;\u201d<\/li>\n<li>Tr\u1ea3 l\u1ea1i chu\u1ed7i, gh\u00e9p t\u1eeb c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng, c\u00f3 d\u1ea5u ph\u00e2n t\u00e1ch.<\/li>\n<li>Gh\u00e9p c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng th\u00e0nh chu\u1ed7i, n\u1ebfu \u00f4 b\u1ecb l\u1ed7i th\u00ec b\u1ecf qua. Gh\u00e9p t\u1eeb tr\u00e1i sang ph\u1ea3i, t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi.<\/li>\n<\/ul>\n<blockquote>\n<p>B\u1ed9\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">t\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a> hay nh\u1ea5t m\u1ecdi th\u1eddi \u0111\u1ea1i<\/p>\n<\/blockquote>\n<p>N\u1ed1i chu\u1ed7i\u00a0 t\u1eeb m\u1ed9t c\u1ed9t khi b\u1ecf qua PhanTach, khi \u0111\u00f3 d\u1ea5u ph\u00e2n c\u00e1ch l\u00e0 \u201c;\u201d:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-806 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/arraytotext-time-0_01_2023__-1024x576-1.png\" alt=\"N\u1ed1i chu\u1ed7i, m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u.\" width=\"1024\" height=\"576\" title=\"arraytotext-time-0_01_2023__-1024x576-1\"><\/p>\n<p>N\u1ed1i chu\u1ed7i t\u1eeb m\u1ed9t d\u00f2ng, v\u1edbi d\u1ea5u PhanTach l\u00e0 kho\u1ea3ng tr\u1eafng:<\/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-346.gif\" title=\"vba101_92019-nho-346\"><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-778.gif\" title=\"ex101_92019-nho-778\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-808 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/arraytotext-time-0_01_5322__-1024x576-1.png\" alt=\"N\u1ed1i chu\u1ed7i, n\u1ed1i chu\u1ed7i v\u1edbi kho\u1ea3ng tr\u1eafng.\" width=\"1024\" height=\"576\" title=\"arraytotext-time-0_01_5322__-1024x576-1\"><\/p>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u ngay: H\u1ecdc Excel n\u00e2ng cao \u1edf \u0111\u00e2u<\/p>\n<\/blockquote>\n<p><strong>N\u1ed1i chu\u1ed7i t\u1eeb m\u1ed9t v\u00f9ng nhi\u1ec1u h\u00e0ng, nhi\u1ec1u c\u1ed9t:<\/strong><\/p>\n<ul>\n<li>Th\u1ee9 t\u1ef1 gh\u00e9p l\u00e0 t\u1eeb tr\u00e1i sang ph\u1ea3i, t\u1eed tr\u00ean xu\u1ed1ng d\u01b0\u1edbi.<\/li>\n<li>N\u1ebfu c\u1ea7n ng\u01b0\u1ee3c l\u1ea1i h\u00e3y ngh\u0129 t\u1edbi h\u00e0m TRANSPOSE.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-807 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/arraytotext-time-0_02_0306__-1024x576-1.png\" alt=\"N\u1ed1i chu\u1ed7i, n\u1ed1i chu\u1ed7i nhi\u1ec1u h\u00e0ng, nhi\u1ec1u c\u1ed9t.\" width=\"1024\" height=\"576\" title=\"arraytotext-time-0_02_0306__-1024x576-1\"><\/p>\n<p><strong>N\u1ed1i chu\u1ed7i theo \u0111i\u1ec1u ki\u1ec7n:<\/strong><\/p>\n<ul>\n<li>B\u1ea3n ch\u1ea5t ArrayToText kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng n\u1ed1i chu\u1ed7i theo \u0111i\u1ec1u ki\u1ec7n, nh\u01b0ng n\u00f3 l\u1ea1i b\u1ecf qua nh\u1eefng ph\u1ea7n t\u1eed l\u1ed7i. Nh\u1eefng ph\u1ea7n t\u1eed kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 vi\u1ec7c thay b\u1eb1ng na() l\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 m\u1ed9t h\u00e0m n\u1ed1i chu\u1ed7i trong Excel theo \u0111i\u1ec1u ki\u1ec7n. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p ta n\u1ed1i chu\u1ed7i theo nh\u1eefng \u0111i\u1ec1u ki\u1ec7n v\u00f4 c\u00f9ng ph\u1ee9c t\u1ea1p c\u0169ng kh\u00f4ng v\u1ea5n \u0111\u1ec1 g\u00ec.<\/li>\n<li>N\u1ed1i c\u00e1c chu\u1ed7i trong \u201cS\u1ed1 Th\u00f9ng\u201d n\u1ebfu c\u1ed9t \u201cM\u00e3 v\u1eadt t\u01b0\u201d l\u00e0 \u201cA\u201d.<\/li>\n<li>N\u1ebfu ph\u1ea7n t\u1eed \u201cM\u00e3 v\u1eadt t\u01b0\u201d l\u00e0 \u201cA\u201d th\u00ec tr\u1ea3 l\u1ea1i ph\u1ea7n t\u1eed t\u01b0\u01a1ng \u1ee9ng trong \u201cS\u1ed1 Th\u00f9ng\u201d, ng\u01b0\u1ee3c l\u1ea1i s\u1ebd tr\u1ea3 l\u1ea1i na(). K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng s\u1ebd do ArrayToText gh\u00e9p n\u1ed1i.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-809 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/arraytotext-time-0_02_4414__-1024x576-1.png\" alt=\"n\u1ed1i chu\u1ed7i theo \u0111i\u1ec1u ki\u1ec7n.\" width=\"1024\" height=\"576\" title=\"arraytotext-time-0_02_4414__-1024x576-1\"><\/p>\n<p><strong>N\u1ed1i chu\u1ed7i t\u1eeb nhi\u1ec1u c\u1ed9t ri\u00eang bi\u1ec7t c\u00f3 x\u00e9t th\u00eam \u0111i\u1ec1u ki\u1ec7n:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu \u201cM\u00e3 V\u1eadt T\u01b0\u201d l\u00e0 \u201ca\u201d th\u00ec s\u1ebd gh\u00e9p \u201cS\u1ed1 th\u00f9ng\u201d &amp; \u201c(\u201d &amp; SL &amp; \u201c\u201d)\u201d<\/li>\n<li>Ph\u1ed1i h\u1ee3p v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, b\u1ea1n s\u1ebd b\u1ea5t kh\u1ea3 chi\u1ebfn b\u1ea1i v\u1edbi vi\u1ec7c n\u1ed1i chu\u1ed7i:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-811 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/arraytotext-time-0_03_3227__-1024x576-1.png\" alt=\"n\u1ed1i chu\u1ed7i d\u1ea1ng gh\u00e9p nhi\u1ec1u c\u1ed9t c\u00f3 \u0111i\u1ec1u ki\u1ec7n.\" width=\"1024\" height=\"576\" title=\"arraytotext-time-0_03_3227__-1024x576-1\"><\/p>\n<p>Video c\u1ee7a ch\u1ee7 \u0111\u1ec1:<\/p>\n<iframe loading=\"lazy\" title=\"SP: ArrayToText, gh\u00e9p c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a c\u1ed9t, h\u00e0ng, v\u00f9ng, m\u1ea3ng th\u00e0nh chu\u1ed7i.\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/crzyrMbZzBI?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>S\u1eed d\u1ee5ng VBA gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook \u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p \u2026<\/p>\n<p style=\"text-align: right\">T\u00e1c gi\u1ea3: Nguy\u1ec5n Ng\u1ecdc Thu Hi\u1ec1n<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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-346.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8467,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8466","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\/8466","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=8466"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8466\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8467"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}