{"id":12408,"date":"2025-01-15T08:38:35","date_gmt":"2025-01-15T08:38:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/meo-noi-noi-dung-giua-cac-o-tinh-voi-nhau-bang-ham-concatenate-trong-excel\/"},"modified":"2025-01-15T08:38:35","modified_gmt":"2025-01-15T08:38:35","slug":"meo-noi-noi-dung-giua-cac-o-tinh-voi-nhau-bang-ham-concatenate-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/meo-noi-noi-dung-giua-cac-o-tinh-voi-nhau-bang-ham-concatenate-trong-excel\/","title":{"rendered":"M\u1eb9o n\u1ed1i n\u1ed9i dung gi\u1eefa c\u00e1c \u00f4 t\u00ednh v\u1edbi nhau b\u1eb1ng h\u00e0m Concatenate trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>\u0110\u1ec3 k\u1ebft h\u1ee3p v\u00e0 g\u1ed9p t\u1ea5t c\u1ea3 n\u1ed9i dung gi\u1eefa c\u00e1c \u00f4 t\u00ednh v\u1edbi nhau v\u00e0o m\u1ed9t \u00f4 duy nh\u1ea5t, m\u00ecnh th\u01b0\u1eddng hay s\u1eed d\u1ee5ng h\u00e0m CONCATENATE. N\u00f3 c\u00f3 vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c gh\u00e9p n\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n c\u00f3 s\u1eb5n th\u00e0nh m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ea7y \u0111\u1ee7, duy nh\u1ea5t. <\/strong><\/em><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ebft c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <strong>CONCATENATE <\/strong>trong Excel, \u00a0c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!<\/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-678774098f2fc\" 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\/meo-noi-noi-dung-giua-cac-o-tinh-voi-nhau.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/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\/meo-noi-noi-dung-giua-cac-o-tinh-voi-nhau.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span><strong>C\u00fa ph\u00e1p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong>=CONCATENATE(Text1;Text2;\u2026)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\">\u2013 <strong>Text1: <\/strong>chu\u1ed7i c\u1ea7n n\u1ed1i th\u1ee9 nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">\u2013 <strong>Text2: <\/strong>chu\u1ed7i c\u1ea7n n\u1ed1i ti\u1ebfp theo, t\u1ed1i \u0111a 255 chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n k\u1ebft n\u1ed1i.<\/p>\n<p style=\"text-align: justify\">Chu\u1ed7i k\u1ebft n\u1ed1i Text1, Text2\u2026 c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c \u00f4 tham chi\u1ebfu t\u1edbi s\u1ed1 hay v\u0103n b\u1ea3n.<\/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-395.gif\" title=\"ex101_92019-nho-395\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><b>*\u00a0<\/b>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1ea5u v\u00e0 (&amp;) trong to\u00e1n t\u1eed thay v\u00ec d\u00f9ng h\u00e0m <strong>CONCATENATE<\/strong> \u0111\u1ec3 n\u1ed1i chu\u1ed7i.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 n\u1ed1i chu\u1ed7i text1, text2, text3 v\u00e0 text 4 v\u1edbi nhau, b\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 c\u00fa ph\u00e1p:\u00a0<strong>=CONCATENATE<\/strong>(text1,text2,text3,text4) v\u00e0 nh\u1ea5n Enter.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3147 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-16.png\" width=\"600\" height=\"359\" title=\"1-16\"><\/p>\n<p style=\"text-align: justify\">Cho k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3148 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-17.png\" width=\"600\" height=\"374\" title=\"1-17\"><\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n n\u00ean m\u00ecnh tin r\u1eb1ng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c r\u1ea5t d\u1ec5 d\u00e0ng.<\/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\/2025\/01\/ex101_92019-nho-395.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12409,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12408","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\/12408","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=12408"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12408\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12409"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}