{"id":1815,"date":"2024-12-02T06:04:26","date_gmt":"2024-12-02T06:04:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-tach-o-trong-excel\/"},"modified":"2024-12-02T06:04:26","modified_gmt":"2024-12-02T06:04:26","slug":"huong-dan-tach-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-tach-o-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00e1ch \u00f4 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00fang ta \u0111\u1ec1u \u0111\u00e3 bi\u1ebft \u0111\u1ebfn\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html\">Merge \u2013 c\u00f4ng c\u1ee5 g\u1ed9p \u00f4<\/a><\/strong> gi\u00fap ta c\u00f3 th\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 th\u00e0nh m\u1ed9t trong Excel. Ho\u1eb7c c\u00e1c h\u00e0m x\u1eed l\u00fd k\u00ed t\u1ef1, c\u00f4ng c\u1ee5\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tinh-nang-fill-justify-trong-excel.html\"><strong>Fill Justify<\/strong><\/a> gi\u00fap l\u1ea5y d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u \u00f4 v\u1ec1 m\u1ed9t \u00f4 duy nh\u1ea5t. V\u1eady trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1ee3c l\u1ea1i, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00e1ch \u00f4 trong Excel? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n thao t\u00e1c n\u00e0y.<\/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-674d4dea02be6\" 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\/tach-o-trong-excel.html#Tach_o_trong_Excel_su_dung_Text_to_column\" title=\"T\u00e1ch \u00f4 trong Excel s\u1eed d\u1ee5ng Text to column\">T\u00e1ch \u00f4 trong Excel s\u1eed d\u1ee5ng Text to column<\/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\/tach-o-trong-excel.html#Su_dung_ham_tach_o_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m t\u00e1ch \u00f4 trong Excel\">S\u1eed d\u1ee5ng h\u00e0m t\u00e1ch \u00f4 trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tach_o_trong_Excel_su_dung_Text_to_column\"><\/span>T\u00e1ch \u00f4 trong Excel s\u1eed d\u1ee5ng Text to column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Text to column l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00e1ch \u00f4 trong Excel: B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Text To Column \u0111\u1ec3 ph\u00e2n t\u00e1ch h\u1ecd t\u00ean, \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, \u0111\u1ecba ch\u1ec9 nh\u00e0\u2026 C\u1ee5 th\u1ec3 ta s\u1ebd t\u00e1ch v\u00ed d\u1ee5 sau:<\/p>\n<figure id=\"attachment_27250\" aria-describedby=\"caption-attachment-27250\" style=\"width: 264px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-27250\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-1.png\" width=\"264\" height=\"163\" title=\"tach-o-trong-excel-1\"><figcaption id=\"caption-attachment-27250\" class=\"wp-caption-text\">T\u00e1ch 1 \u00f4 th\u00e0nh 4 \u00f4<\/figcaption><\/figure>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, t\u1ea1i th\u1ebb Data ch\u1ecdn Text To Column:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27251\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-2.png\" width=\"759\" height=\"130\" title=\"tach-o-trong-excel-2\"><\/p>\n<p>Ch\u1ecdn <strong>Delimited\u00a0<\/strong>r\u1ed3i \u1ea5n Next<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27252\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-3.png\" width=\"517\" height=\"419\" title=\"tach-o-trong-excel-3\"><\/p>\n<p>Ch\u1ecdn\u00a0<strong>Space<\/strong> \u0111\u1ec3 t\u00e1ch theo d\u1ea5u c\u00e1ch, \u1ea5n Next:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27253\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-4.png\" width=\"519\" height=\"416\" title=\"tach-o-trong-excel-4\"><\/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-130.gif\" title=\"ex101_92019-nho-130\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1eb7t \u00f4, \u1ea5n Finish:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27254\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-5.png\" width=\"827\" height=\"430\" title=\"tach-o-trong-excel-5\"><\/p>\n<p>\u0110\u1ec3 chuy\u1ec3n t\u1eeb c\u1ed9t v\u1ec1 h\u00e0ng, ta copy sau \u0111\u00f3 s\u1eed d\u1ee5ng\u00a0<strong>Paste Special -&gt; Transpose:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27256\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-6.png\" width=\"261\" height=\"146\" title=\"tach-o-trong-excel-6\"><\/p>\n<p>Tuy v\u1eady, thay v\u00ec s\u1eed d\u1ee5ng Text To Column, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m sau \u0111\u00e2y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_tach_o_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m t\u00e1ch \u00f4 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00e1ch \u00f4 trong Excel m\u00e0 kh\u00f4ng s\u1eed d\u1ee5ng Text To Column, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn \u0111\u1ec3 c\u00e2n nh\u1eafc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27257\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-1-1.png\" width=\"264\" height=\"163\" title=\"tach-o-trong-excel-1-1\"><\/p>\n<p>V\u1eabn l\u00e0 v\u00ed d\u1ee5 tr\u00ean, t\u1ea1i \u00f4 A3 ta \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong><em>=TRIM(MID(SUBSTITUTE(\u201d \u201c&amp;A$1,\u201d \u201c,REPT(\u201d \u201c,50)),ROW(A1)*50,50))<\/em><\/strong><\/p>\n<\/blockquote>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng AutoFill k\u00e9o t\u1edbi khi h\u1ebft chu\u1ed7i t\u1ea1i \u00f4 A1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27258\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-trong-excel-7.png\" width=\"700\" height=\"190\" title=\"tach-o-trong-excel-7\"><\/p>\n<p>L\u01b0u \u00fd: T\u00f9y tr\u01b0\u1eddng h\u1ee3p m\u00e0 ta s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c. Ch\u1eb3ng h\u1ea1n n\u1ebfu kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c t\u1eeb l\u00e0 d\u1ea5u ph\u1ea9y hay d\u1ea5u ch\u1ea5m, ta c\u1ea7n t\u00f9y bi\u1ebfn c\u00f4ng th\u1ee9c theo sao cho ph\u00f9 h\u1ee3p.<\/p>\n<hr>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-doi-tu-text-sang-date-voi-text-columns-fixed-width.html\">S\u1eed d\u1ee5ng Text To Column chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng n\u0103m<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel.html\"><strong>H\u00e0m REPT l\u1eb7p l\u1ea1i chu\u1ed7i k\u00ed t\u1ef1<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-ngay-sai-trong-excel.html\"><strong>C\u00e1ch s\u1eeda ng\u00e0y sai trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\">S\u1eed d\u1ee5ng SUBSTITUTE th\u00e0nh th\u1ea1o<\/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-130.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1816,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1815","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\/1815","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=1815"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1815\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1816"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}