{"id":11262,"date":"2025-01-15T02:22:50","date_gmt":"2025-01-15T02:22:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-bo-dau-cach-xuong-dong-alt-enter-trong-chuoi-ky-tu\/"},"modified":"2025-01-15T02:22:50","modified_gmt":"2025-01-15T02:22:50","slug":"cach-bo-dau-cach-xuong-dong-alt-enter-trong-chuoi-ky-tu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-bo-dau-cach-xuong-dong-alt-enter-trong-chuoi-ky-tu\/","title":{"rendered":"C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch xu\u1ed1ng d\u00f2ng Alt enter trong chu\u1ed7i k\u00fd t\u1ef1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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-67871bf93d674\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-bo-dau-cach-xuong-dong-alt-enter-trong-chuoi-ky-tu.html#1_Muc_dich\" title=\"1. M\u1ee5c\u00a0\u0111\u00edch\">1. M\u1ee5c\u00a0\u0111\u00edch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-bo-dau-cach-xuong-dong-alt-enter-trong-chuoi-ky-tu.html#2_Cach_thuc_hien\" title=\"2. C\u00e1ch th\u1ef1c hi\u1ec7n\">2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-bo-dau-cach-xuong-dong-alt-enter-trong-chuoi-ky-tu.html#3_Giai_thich_cong_thuc\" title=\"3. Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c\">3. Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Muc_dich\"><\/span>1. M\u1ee5c\u00a0\u0111\u00edch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>R\u1ea5t r\u00f5 r\u00e0ng v\u1edbi ti\u00eau\u00a0\u0111\u1ec1:\u00a0C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch xu\u1ed1ng d\u00f2ng (Alt+enter) trong chu\u1ed7i k\u00fd t\u1ef1.<\/p>\n<p>V\u00ed d\u1ee5 v\u1edbi chu\u1ed7i k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u00f4 A2, c\u00f3 s\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch xu\u1ed1ng d\u00f2ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9257 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-ky-tu-alt-enter-01.png\" width=\"573\" height=\"369\" title=\"xoa-ky-tu-alt-enter-01\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Cach_thuc_hien\"><\/span>2. C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u1ea7n 2 h\u00e0m:<\/p>\n<ul>\n<li>H\u00e0m Substitue: h\u00e0m thay th\u1ebf 1 n\u1ed9i dung c\u1ee5 th\u1ec3 n\u00e0y b\u1eb1ng 1 n\u1ed9i dung c\u1ee5 th\u1ec3 kh\u00e1c (\u1edf\u00a0\u0111\u00e2y l\u00e0 k\u00fd t\u1ef1 Alt+enter)<\/li>\n<li>H\u00e0m Trim: lo\u1ea1i b\u1ecf kho\u1ea3ng c\u00e1ch th\u1eeba trong chu\u1ed7i k\u00fd t\u1ef1 (n\u1ebfu c\u00f3)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9258 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-ky-tu-alt-enter-02.png\" width=\"794\" height=\"269\" title=\"xoa-ky-tu-alt-enter-02\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Giai_thich_cong_thuc\"><\/span>3. Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Char(10) l\u00e0 k\u00fd t\u1ef1 Alt+enter,\u00a0\u0111\u01b0\u1ee3c\u00a0excel quy\u00a0\u01b0\u1edbc nh\u01b0 v\u1eady.<\/li>\n<li>Substitue(A2,Char(10),\u201d \u201c) l\u00e0 thay th\u1ebf k\u00fd t\u1ef1 Alt+enter trong chu\u1ed7i k\u00fd t\u1ef1 t\u1ea1i\u00a0\u00f4 A2 b\u1eb1ng k\u00fd t\u1ef1 c\u00e1ch (kho\u1ea3ng tr\u1eafng t\u1ea1o b\u1edfi d\u1ea5u c\u00e1ch)<\/li>\n<li>Trim(Substitue(A2,Char(10),\u201d \u201c)) l\u00e0\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba trong chu\u1ed7i k\u00fd t\u1ef1 A2,\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c x\u1eed l\u00fd b\u1ecf k\u00fd t\u1ef1 Alt+enter<\/li>\n<li>\u1ede h\u00ecnh tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u00f5 t\u00e1c d\u1ee5ng c\u1ee7a vi\u1ec7c c\u00f3 th\u00eam h\u00e0m Trim\u00a0\u0111\u1ec3 x\u1eed l\u00fd c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba.<\/li>\n<\/ul>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t thao t\u00e1c r\u1ea5t c\u01a1 b\u1ea3n trong Excel. Nh\u01b0 c\u00e1c b\u1ea1n bi\u1ebft, Excel c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch l\u00e0m kh\u00e1c nhau khi x\u1eed l\u00fd m\u1ed9t d\u1eef li\u1ec7u. \u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta\u00a0c\u1ea7n\u00a0n\u1eafm v\u1eefng v\u00e0 s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/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\/2025\/01\/ex101_92019-nho-277.gif\" title=\"ex101_92019-nho-277\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2025\/01\/ex101_92019-nho-277.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11263,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11262","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\/11262","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=11262"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11262\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11263"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}