{"id":4372,"date":"2024-12-05T01:00:28","date_gmt":"2024-12-05T01:00:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/huong-dan-ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong-trong-excel-don-gian\/"},"modified":"2024-12-05T01:00:28","modified_gmt":"2024-12-05T01:00:28","slug":"huong-dan-ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong-trong-excel-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/huong-dan-ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong-trong-excel-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn k\u0129 thu\u1eadt t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng trong Excel \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi b\u1ea1n nh\u1eadp ho\u1eb7c s\u1eeda d\u1eef li\u1ec7u trong Excel, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Alt + Enter<\/strong> s\u1ebd gi\u00fap xu\u1ed1ng d\u00f2ng trong m\u1ed9t \u00f4. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 ti\u1ec7n l\u1ee3i khi hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u tr\u00ean m\u00e0n h\u00ecnh, nh\u01b0ng kh\u00f4ng h\u1ec1 tuy\u1ec7t v\u1edbi t\u00fd n\u00e0o khi ta c\u1ea7n ph\u00e2n t\u00edch nh\u1eefng d\u1eef li\u1ec7u \u0111\u00f3. B\u1edfi v\u1eady, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u1ea7n s\u1eed d\u1ee5ng t\u1edbi\u00a0<strong>k\u0129 thu\u1eadt t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng<\/strong>.<\/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-6750fb2bd3c5a\" 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\/ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong.html#Xuong_dong_trong_o_Excel\" title=\"Xu\u1ed1ng d\u00f2ng trong \u00f4 Excel\">Xu\u1ed1ng d\u00f2ng trong \u00f4 Excel<\/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\/ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong.html#Ki_thuat_tach_mot_o_thanh_nhieu_o_dua_vao_ngat_dong_trong_Excel\" title=\"K\u0129 thu\u1eadt t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng trong Excel\">K\u0129 thu\u1eadt t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Xuong_dong_trong_o_Excel\"><\/span>Xu\u1ed1ng d\u00f2ng trong \u00f4 Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Xu\u1ed1ng d\u00f2ng trong \u00f4 (hay c\u00f2n g\u1ecdi ng\u1eaft d\u00f2ng) l\u00e0 m\u1ed9t k\u0129 thu\u1eadt x\u1eed l\u00fd d\u1eef li\u1ec7u s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Alt + Enter<\/strong> t\u1ea1o ra k\u00ed t\u1ef1 c\u00f3 m\u00e3 l\u00e0\u00a0<strong>10<\/strong> (<strong>CHAR(10)<\/strong> trong Excel) ng\u0103n c\u00e1ch c\u00e1c k\u00ed t\u1ef1 tr\u01b0\u1edbc v\u00e0 sau n\u00f3 th\u00e0nh 2 d\u00f2ng. V\u00ed d\u1ee5:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23402\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-1.png\" width=\"472\" height=\"152\" title=\"tach-o-1\">Nh\u00ecn d\u00f2ng \u0111\u1ea7u ti\u00ean c\u00f3 v\u1ebb ti\u1ec7n h\u01a1n, ph\u1ea3i kh\u00f4ng? Nh\u01b0ng l\u00fac l\u1ea5y d\u1eef li\u1ec7u th\u00ec kh\u00f4ng h\u1ec1.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00e1ch d\u1eef li\u1ec7u trong \u00f4 d\u1ef1a tr\u00ean ng\u1eaft d\u00f2ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ki_thuat_tach_mot_o_thanh_nhieu_o_dua_vao_ngat_dong_trong_Excel\"><\/span>K\u0129 thu\u1eadt t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-23403\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-2-1024x295-1.png\" width=\"1024\" height=\"295\" title=\"tach-o-2-1024x295-1\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u1ea7n ph\u1ea3i t\u00e1ch ri\u00eang ra: H\u1ecd t\u00ean, \u0110\u1ecba ch\u1ec9 v\u00e0 T\u1ec9nh\/th\u00e0nh ph\u1ed1. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta s\u1ebd d\u00f9ng t\u1edbi ch\u1ee9c n\u0103ng\u00a0<strong>Text to column<\/strong>.<\/p>\n<p>\u0110\u1ea7u ti\u00ean, k\u00e9o ch\u1ecdn v\u00f9ng c\u1ea7n t\u00e1ch.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23404\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-3.png\" width=\"501\" height=\"272\" title=\"tach-o-3\"><\/p>\n<p>Sau \u0111\u00f3, trong th\u1ebb\u00a0<strong>Data<\/strong>, nh\u00f3m\u00a0<strong>Data Tools<\/strong>, ch\u1ecdn\u00a0<strong>Text to column.<\/strong><\/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-352.gif\" title=\"ex101_92019-nho-352\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23405\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-4.png\" width=\"877\" height=\"506\" title=\"tach-o-4\"><\/p>\n<figure id=\"attachment_23406\" aria-describedby=\"caption-attachment-23406\" style=\"width: 523px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23406 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-5.png\" width=\"523\" height=\"421\" title=\"tach-o-5\"><figcaption id=\"caption-attachment-23406\" class=\"wp-caption-text\">Click v\u00e0o delimited r\u1ed3i \u1ea5n Next<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_23407\" aria-describedby=\"caption-attachment-23407\" style=\"width: 520px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23407\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-6.png\" width=\"520\" height=\"421\" title=\"tach-o-6\"><figcaption id=\"caption-attachment-23407\" class=\"wp-caption-text\">Ch\u1ecdn Other, nh\u1eadp Ctrl + J v\u00e0 \u1ea5n Next<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_23408\" aria-describedby=\"caption-attachment-23408\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23408 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-7-1024x363-1.png\" width=\"1024\" height=\"363\" title=\"tach-o-7-1024x363-1\"><figcaption id=\"caption-attachment-23408\" class=\"wp-caption-text\">\u1ea4n v\u00e0o v\u00f9ng khoanh \u0111\u1ecf t\u00ecm n\u01a1i \u0111\u1eb7t d\u1eef li\u1ec7u, \u1ea5n Finish<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_23409\" aria-describedby=\"caption-attachment-23409\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-23409\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-o-8-1024x298-1.png\" width=\"1024\" height=\"298\" title=\"tach-o-8-1024x298-1\"><figcaption id=\"caption-attachment-23409\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3<\/figcaption><\/figure>\n<p>Gi\u1edd \u0111\u00e2y m\u1ed7i d\u00f2ng c\u1ee7a d\u1eef li\u1ec7u g\u1ed1c \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n tr\u00ean m\u1ed9t c\u1ed9t ri\u00eang. \u0110i\u1ec1u n\u00e0y r\u1ea5t ti\u1ec7n cho vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch r\u1ed3i, ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Xem th\u00eam:<strong> H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/tach-o-trong-excel.html\">t\u00e1ch \u00f4 trong Excel<\/a>\u00a0<\/strong><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/p>\n<p>\u00a0<\/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<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-352.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4372","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\/4372","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=4372"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4373"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}