{"id":12028,"date":"2025-01-15T06:33:41","date_gmt":"2025-01-15T06:33:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/chuyen-doi-tu-text-sang-date-voi-text-to-columns-fixed-width\/"},"modified":"2025-01-15T06:33:41","modified_gmt":"2025-01-15T06:33:41","slug":"chuyen-doi-tu-text-sang-date-voi-text-to-columns-fixed-width","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/chuyen-doi-tu-text-sang-date-voi-text-to-columns-fixed-width\/","title":{"rendered":"Chuy\u1ec3n \u0111\u1ed5i t\u1eeb text sang date v\u1edbi Text to columns\/ fixed width"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u00f4i khi c\u00e1c b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c files Excel t\u1eeb m\u1ed9t ng\u01b0\u1eddi kh\u00e1c ho\u1eb7c t\u1eeb m\u1ed9t h\u1ec7 th\u1ed1ng, c\u1ed9t ng\u00e0y th\u00e1ng l\u1ea1i \u1edf d\u1ea1ng Text. \u0110i\u1ec1u n\u00e0y g\u00e2y kh\u00f3 kh\u0103n cho vi\u1ec7c t\u00ednh to\u00e1n, ph\u00e2n t\u00edch v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u. Ch\u00fang ta c\u1ea7n ph\u1ea3i chuy\u1ec3n ng\u00e0y th\u00e1ng \u0111ang \u0111\u01b0\u1ee3c l\u01b0u \u1edf d\u1ea1ng text n\u00e0y sang ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u \u1edf d\u1ea1ng th\u1eddi gian \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c x\u1eed l\u00fd kh\u00e1c. Video sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng l\u00e0 text sang ki\u1ec3u date v\u1edbi ch\u1ee9c n\u0103ng Text to columns \/ fixed width<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/0FRb-fBHRB8\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/TextToCols.zip\">Download file k\u00e8m theo videos<\/a><\/strong><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel v\u0103n ph\u00f2ng<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\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":"<p>\u0110\u00f4i khi c\u00e1c b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c files Excel t\u1eeb m\u1ed9t ng\u01b0\u1eddi kh\u00e1c ho\u1eb7c t\u1eeb..<\/p>\n","protected":false},"author":1,"featured_media":12029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12028","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\/12028","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=12028"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12029"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}