{"id":6291,"date":"2024-12-21T15:00:14","date_gmt":"2024-12-21T15:00:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-them-chen-tien-to-hoac-hau-to-vao-mot-day-cac-o-trong-excel\/"},"modified":"2024-12-21T15:00:14","modified_gmt":"2024-12-21T15:00:14","slug":"cach-them-chen-tien-to-hoac-hau-to-vao-mot-day-cac-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-them-chen-tien-to-hoac-hau-to-vao-mot-day-cac-o-trong-excel\/","title":{"rendered":"C\u00e1ch th\u00eam\/ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o m\u1ed9t d\u00e3y c\u00e1c \u00f4 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\">\u0110\u00f4i khi b\u1ea1n c\u1ea7n ph\u1ea3i th\u00eam ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1. T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 cho m\u1ed7i \u00f4 t\u1eebng c\u00e1i m\u1ed9t. Tuy nhi\u00ean, c\u00f4ng vi\u1ec7c n\u00e0y m\u1ea5t nhi\u1ec1u th\u1eddi gian n\u1ebfu c\u00f3 nhi\u1ec1u \u00f4. <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n m\u1ed9t s\u1ed1 m\u1eb9o v\u1ec1 vi\u1ec7c th\u00eam ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o d\u00e3y c\u00e1c \u00f4 trong Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/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-6766d7fdb3439\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-themchen-tien-hoac-hau-vao-mot-day-cac-o-trong-excel.html#ThemChen_tien_to_hoac_hau_to_vao_nhieu_o_voi_ham\" title=\"Th\u00eam\/Ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi h\u00e0m\">Th\u00eam\/Ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi h\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-themchen-tien-hoac-hau-vao-mot-day-cac-o-trong-excel.html#Them_Chen_tien_to_hoac_hau_to_vao_nhieu_o_voi_ma_VBA\" title=\"Th\u00eam \/ Ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi m\u00e3 VBA\">Th\u00eam \/ Ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi m\u00e3 VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"ThemChen_tien_to_hoac_hau_to_vao_nhieu_o_voi_ham\"><\/span>Th\u00eam\/Ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\" target=\"_blank\">H\u00e0m CONCATENATE<\/a> C\u1ee7a Excel c\u00f3 th\u1ec3 ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 cho m\u1ed9t \u00f4 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n<p style=\"text-align: justify\">Nh\u1eadp h\u00e0m = CONCATENATE (\u201cFood -\u201c, A1) trong \u00f4 tr\u1ed1ng, gi\u1ea3 s\u1eed l\u00e0 C1, v\u00e0 sau \u0111\u00f3 k\u00e9o \u00f4 \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c. T\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ti\u1ec1n t\u1ed1 c\u1ee5 th\u1ec3. Xem h\u00ecnh sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6215\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-160.png\" width=\"600\" height=\"288\" title=\"excel-dialog-box-launcher-1-160\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m n\u00e0y \u0111\u1ec3 th\u00eam ti\u1ec1n t\u1ed1, h\u1eadu t\u1ed1, ho\u1eb7c c\u1ea3 hai nh\u01b0 sau:<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p style=\"text-align: center\"><strong>Enter formulas<\/strong><\/p>\n<\/td>\n<td><strong>Results in cells<\/strong><\/td>\n<\/tr>\n<tr>\n<td><em>= Concatenate (\u201cFood \u2013 \u201c, A1)<\/em><\/td>\n<td>Food \u2013 Apple<\/td>\n<\/tr>\n<tr>\n<td><em>=Concatenate (A1, \u201d \u2013 Fruit\u201d)<\/em><\/td>\n<td>Apple \u2013 Fruit<\/td>\n<\/tr>\n<tr>\n<td><em>=Concatenate (\u201cFood \u2013 \u201c, A1, \u201d \u2013 Fruit\u201d)<\/em><\/td>\n<td>Food \u2013 Apple \u2013 Fruit<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Them_Chen_tien_to_hoac_hau_to_vao_nhieu_o_voi_ma_VBA\"><\/span>Th\u00eam \/ Ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi m\u00e3 VBA<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-chay-ma-vba-trong-excel-2010-2016-huong-dan-cho-nguoi-moi-bat-dau.html\" target=\"_blank\">m\u00e3 VBA<\/a> sau:<\/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-241.gif\" title=\"vba101_92019-nho-241\"><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-567.gif\" title=\"ex101_92019-nho-567\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u1ea3i m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1.<\/li>\n<\/ol>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Nh\u1ea5p <strong>Developer&gt; Visual Basic<\/strong>, v\u00e0 m\u1ed9t c\u1eeda s\u1ed5 m\u1edbi c\u1ee7a <strong>Microsoft Visual Basic for applications<\/strong> s\u1ebd hi\u1ec3n th\u1ecb, nh\u1ea5p v\u00e0o <strong>Insert&gt; Module<\/strong>, v\u00e0 sau \u0111\u00f3 nh\u1eadp v\u00e0o m\u00e3 sau \u0111\u00e2y trong m\u00f4-\u0111un:<\/li>\n<\/ol>\n<p style=\"text-align: justify\">VBA: Th\u00eam ti\u1ec1n t\u1ed1 v\u00e0o v\u0103n b\u1ea3n:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/a9b4468331c10725028a5ef536873d84\">Gist<\/a>.<\/div>\n<div class=\"line number1 index0 alt2\" style=\"text-align: justify\"><\/div>\n<p style=\"text-align: justify\">VBA: Th\u00eam h\u1eadu t\u1ed1 v\u00e0o v\u0103n b\u1ea3n:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/05faad9ebdb3738a88c31d2fd5cb85ad\">Gist<\/a>.<\/div>\n<div class=\"line number1 index0 alt2\" style=\"text-align: justify\"><\/div>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat <strong>Run<\/strong> ho\u1eb7c nh\u1ea5n ph\u00edm F5 \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\">ch\u1ea1y VBA<\/a>.<\/li>\n<li>V\u00e0 b\u00e2y gi\u1edd xin vui l\u00f2ng ch\u1ec9 \u0111\u1ecbnh ph\u1ea1m vi b\u1ea1n s\u1ebd th\u00eam ti\u1ec1n t\u1ed1 ho\u1eb7c h\u1eadu t\u1ed1 cho v\u00e0o h\u1ed9p tho\u1ea1i v\u00e0 nh\u1ea5p v\u00e0o n\u00fat OK, v\u00e0 sau \u0111\u00f3 g\u00f5 h\u1eadu t\u1ed1 ho\u1eb7c ti\u1ec1n t\u1ed1 b\u1ea1n s\u1ebd th\u00eam v\u00e0o h\u1ed9p tho\u1ea1i th\u1ee9 hai v\u00e0 nh\u1ea5p v\u00e0o n\u00fat OK. Xem h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6216 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-161.png\" width=\"547\" height=\"125\" title=\"excel-dialog-box-launcher-1-161\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd nh\u1eefng h\u1eadu t\u1ed1 v\u00e0 ti\u1ec1n t\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o c\u00e1c \u00f4 b\u1ea1n ch\u1ecdn nh\u01b0 h\u00ecnh sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6217\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-162.png\" width=\"487\" height=\"300\" title=\"excel-dialog-box-launcher-1-162\"><\/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-241.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6292,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6291","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\/6291","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=6291"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6291\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6292"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}