{"id":2620,"date":"2024-12-02T08:12:42","date_gmt":"2024-12-02T08:12:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin\/"},"modified":"2024-12-02T08:12:42","modified_gmt":"2024-12-02T08:12:42","slug":"cach-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin\/","title":{"rendered":"C\u00e1ch k\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><span style=\"font-weight: 400\"><em>CONCATENATE l\u00e0 h\u00e0m \u0111\u1ea7u ti\u00ean ch\u00fang ta ngh\u0129 \u0111\u1ebfn khi c\u1ea7n k\u1ebft h\u1ee3p v\u0103n b\u1ea3n trong Excel. Nh\u01b0ng nh\u1eefng c\u1eadp nh\u1eadt m\u1edbi d\u1ea1o g\u1ea7n \u0111\u00e2y cho ph\u00e9p ch\u00fang ta th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nhanh, d\u1ec5 d\u00e0ng h\u01a1n. V\u00e2ng, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>\u0111ang n\u00f3i v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin.html\"><strong>TEXTJOIN v\u00e0 CONCAT\u00a0 \u0111\u1ec3 k\u1ebft h\u1ee3p v\u0103n b\u1ea3n<\/strong><\/a><\/em><\/span><\/p>\n<p><span style=\"font-weight: 400\">Hi\u1ec7n t\u1ea1i, concat v\u00e0 textjoin \u0111\u00e3 c\u00f3 s\u1eb5n trong Excel 2016, Excel Online v\u00e0 Di \u0111\u1ed9ng, Excel cho m\u00e1y t\u00ednh b\u1ea3ng v\u00e0 \u0111i\u1ec7n tho\u1ea1i Android. S\u1eed d\u1ee5ng c\u00e1c ch\u1ee9c n\u0103ng \u0111\u01a1n gi\u1ea3n n\u00e0y b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n c\u1ea7n h\u1ee3p nh\u1ea5t c\u00e1c ph\u1ea7n c\u1ee7a t\u00ean, \u0111\u1ecba ch\u1ec9 ho\u1eb7c c\u1ee5m t\u1eeb, k\u1ebft h\u1ee3p s\u1ed1 v\u00e0 t\u1eeb.<br \/>\n<\/span><\/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-674d6bf949acf\" 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-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin.html#Ham_CONCAT_%E2%80%93_mo_ta_va_cu_phap\" title=\"H\u00e0m CONCAT \u2013 m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m CONCAT \u2013 m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p<\/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-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin.html#Ham_TEXTJOIN_%E2%80%93_mo_ta_va_cu_phap\" title=\"H\u00e0m TEXTJOIN \u2013 m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m TEXTJOIN \u2013 m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p<\/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-ket-noi-van-ban-trong-excel-bang-ham-concat-va-textjoin.html#Noi_cac_chuoi_van_ban_bang_ham_TEXTJOIN_va_CONCAT\" title=\"N\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng h\u00e0m TEXTJOIN v\u00e0 CONCAT\">N\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng h\u00e0m TEXTJOIN v\u00e0 CONCAT<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_CONCAT_%E2%80%93_mo_ta_va_cu_phap\"><\/span><b>H\u00e0m CONCAT \u2013 m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/ghep-noi-ky-tu-voi-ham-concat-va-textjoin-trong-excel.html\"><strong>H\u00e0m CONCAT<\/strong><\/a>\u00a0 \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u v\u00e0o b\u1ea3n c\u1eadp nh\u1eadt th\u00e1ng 2 n\u0103m 2016, thay th\u1ebf <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html#:~:text=H%C3%A0m%20CONCATENATE%20trong%20Excel%20%C4%91%C6%B0%E1%BB%A3c,gi%C3%A1%20tr%E1%BB%8B%20trong%20c%C3%B4ng%20th%E1%BB%A9c.\"><strong>h\u00e0m CONCATENATE<\/strong><\/a> trong Excel. 2 h\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng theo c\u00f9ng m\u1ed9t c\u00e1ch. D\u01b0\u1eddng nh\u01b0 h\u00e0m CONCAT \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o \u0111\u1ec3 gi\u1ea3m \u0111\u1ed9 d\u00e0i c\u1ee7a t\u00ean h\u00e0m tr\u01b0\u1edbc \u0111\u00f3 (CONCATENATE). CONCAT l\u00e0 ch\u1ee9c n\u0103ng ti\u00eau chu\u1ea9n \u0111\u01b0\u1ee3c Google Trang t\u00ednh s\u1eed d\u1ee5ng. Ngo\u00e0i ra, CONCATENATE ti\u1ebfp t\u1ee5c \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 \u0111\u1ec3 cung c\u1ea5p kh\u1ea3 n\u0103ng t\u01b0\u01a1ng th\u00edch v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p><b>CONCAT(text1, [text2],\u2026)<\/b><\/p>\n<p><span style=\"font-weight: 400\">CONCAT ch\u1ec9 c\u00f3 hai \u0111\u1ed1i s\u1ed1, m\u1ed9t trong s\u1ed1 \u0111\u00f3 l\u00e0 t\u00f9y ch\u1ecdn:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">text1 l\u00e0 m\u1ee5c nh\u1eadp v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c n\u1ed1i. N\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t chu\u1ed7i ho\u1eb7c m\u1ed9t d\u1ea3i chu\u1ed7i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">[text2,\u2026] l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a c\u00e1c m\u1ee5c v\u0103n b\u1ea3n b\u1ed5 sung \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 c\u00f3 t\u1ed1i \u0111a 253 \u0111\u1ed1i s\u1ed1 cho c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n.<\/span><\/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-202.gif\" title=\"ex101_92019-nho-202\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_TEXTJOIN_%E2%80%93_mo_ta_va_cu_phap\"><\/span><b>H\u00e0m TEXTJOIN \u2013 m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-textjoin-ghep-chuoi-thoa-man-dieu-kien.html\">H\u00e0m TEXTJOIN<\/a><\/strong> trong Excel n\u1ed1i v\u0103n b\u1ea3n t\u1eeb nhi\u1ec1u ph\u1ea1m vi ho\u1eb7c chu\u1ed7i. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh d\u1ea5u ph\u00e2n c\u00e1ch \u0111\u1ec3 bao g\u1ed3m gi\u1eefa m\u1ed7i gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u00e0 b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng. Ngay c\u1ea3 khi d\u1ea5u ph\u00e2n c\u00e1ch l\u00e0 m\u1ed9t chu\u1ed7i tr\u1ed1ng, TEXTJOIN c\u0169ng s\u1ebd n\u1ed1i v\u0103n b\u1ea3n th\u00e0nh c\u00f4ng trong Excel.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y v\u00ed d\u1ee5 v\u1ec1 h\u00e0m TEXTJOIN:\u00a0<\/span><\/p>\n<p><b>TEXTJOIN(delimiter, ignore_empty, text1, [text2], \u2026)<\/b><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 3 y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c v\u00e0 1 t\u00f9y ch\u1ecdn:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u1ea5u ph\u00e2n c\u00e1ch cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o \u0111\u1ec3 t\u00e1ch v\u0103n b\u1ea3n c\u1ee7a b\u1ea1n. \u0110\u00f3 c\u00f3 th\u1ec3 l\u00e0 d\u1ea5u ph\u1ea9y, d\u1ea5u c\u00e1ch, d\u1ea5u v\u00e0 ho\u1eb7c b\u1ea5t c\u1ee9 th\u1ee9 g\u00ec b\u1ea1n th\u00edch. C\u00e1c k\u00fd t\u1ef1 ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n h\u1ee3p l\u1ec7. B\u1ea5t k\u1ef3 con s\u1ed1 n\u00e0o c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c coi nh\u01b0 l\u00e0 v\u0103n b\u1ea3n.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ignore_empty<\/span><span style=\"font-weight: 400\"> l\u00e0 m\u1ed9t \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c. N\u1ebfu l\u00e0 TRUE, c\u00e1c \u00f4 tr\u1ed1ng s\u1ebd b\u1ecb b\u1ecf qua. N\u1ebfu b\u1ea1n \u0111\u1eb7t gi\u00e1 tr\u1ecb n\u00e0y th\u00e0nh FALSE th\u00ec \u00f4 tr\u1ed1ng l\u00fac n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh v\u00e0o th\u00e0nh m\u1ed9t gi\u00e1 tr\u1ecb<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">text1 cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh m\u1ed9t ph\u1ea1m vi gi\u00e1 tr\u1ecb \u00f4 \u0111\u1ec3 n\u1ed1i thay v\u00ec ph\u1ea3i nh\u1eadp t\u1eebng gi\u00e1 tr\u1ecb m\u1ed9t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">[text2,\u2026] l\u00e0 m\u1ed9t \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn cho ph\u00e9p ch\u1ec9 \u0111\u1ecbnh c\u00e1c ph\u1ea1m vi kh\u00e1c \u0111\u1ec3 \u0111\u01b0a v\u00e0o n\u1ebfu ph\u1ea1m vi c\u1ee7a b\u1ea1n kh\u00f4ng li\u00ean t\u1ee5c.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 c\u00f3 t\u1ed1i \u0111a 252 \u0111\u1ed1i s\u1ed1 cho c\u00e1c m\u1ee5c v\u0103n b\u1ea3n. N\u1ebfu chu\u1ed7i k\u1ebft qu\u1ea3 v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n \u00f4 l\u00e0 32767 k\u00fd t\u1ef1, h\u00e0m TEXTJOIN tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #VALUE! l\u1ed7i.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Noi_cac_chuoi_van_ban_bang_ham_TEXTJOIN_va_CONCAT\"><\/span><b>N\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng h\u00e0m TEXTJOIN v\u00e0 CONCAT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ed1i v\u0103n b\u1ea3n l\u00e0 m\u1ed9t trong nh\u1eefng thao t\u00e1c ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. Trong c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc, n\u1ebfu b\u1ea1n c\u1ea7n n\u1ed1i v\u0103n b\u1ea3n t\u1eeb nhi\u1ec1u \u00f4, b\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh t\u1eebng \u00f4 ri\u00eang l\u1ebb. V\u1edbi c\u00e1c h\u00e0m TEXTJOIN v\u00e0 CONCAT m\u1edbi, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 c\u1ea7n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t d\u1ea3i \u00f4 v\u00e0 k\u1ebft h\u1ee3p c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n t\u1eeb c\u00e1c d\u1ea3i \u00f4 c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 d\u1ea5u ph\u00e2n c\u00e1ch.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u1ea1n ch\u1ebf ch\u00ednh c\u1ee7a h\u00e0m CONCATENATE m\u00e0 h\u00e0m CONCAT \u0111\u00e3 gi\u1ea3i quy\u1ebft l\u00e0 b\u00e2y gi\u1edd ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t d\u1ea3i \u00f4 trong khi tr\u01b0\u1edbc \u0111\u00e2y b\u1ecb gi\u1edbi h\u1ea1n trong vi\u1ec7c li\u1ec7t k\u00ea c\u00e1c \u00f4 ri\u00eang bi\u1ec7t. Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p c\u00e1c ph\u1ea7n c\u1ee7a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i. V\u1edbi h\u00e0m Concatenate, b\u1ea1n s\u1ebd c\u1ea7n nh\u1eadp t\u1eebng \u0111\u1ecba ch\u1ec9 \u00f4 m\u1ed9t.<\/span><\/p>\n<p><b>=CONCATENATE(A1,B1,C1,D1,E1,)<\/b><\/p>\n<figure id=\"attachment_34779\" aria-describedby=\"caption-attachment-34779\" style=\"width: 475px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34779 size-full\" title=\"1- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-15.png\" alt=\"1- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" width=\"475\" height=\"327\"><figcaption id=\"caption-attachment-34779\" class=\"wp-caption-text\">1- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, CONCAT s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. T\u1ea5t c\u1ea3 nh\u1eefng g\u00ec b\u1ea1n c\u1ea7n l\u00e0m ch\u1ec9 l\u00e0 ch\u1ecdn ph\u1ea1m vi c\u00f3 c\u00e1c chu\u1ed7i Excel \u0111\u1ec3 n\u1ed1i v\u00e0 nh\u1eadp c\u00fa ph\u00e1p c\u1ee7a concat.\u00a0<\/span><\/p>\n<p><b>=CONCAT(A1:E1)<\/b><\/p>\n<figure id=\"attachment_34780\" aria-describedby=\"caption-attachment-34780\" style=\"width: 492px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34780 size-full\" title=\"2- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-14.png\" alt=\"2- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" width=\"492\" height=\"320\"><figcaption id=\"caption-attachment-34780\" class=\"wp-caption-text\">2- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ed3ng th\u1eddi, c\u1ea3 h\u00e0m CONCAT v\u00e0 CONCATENATE \u0111\u1ec1u tr\u00f4ng gi\u1ed1ng nhau khi b\u1ea1n c\u1ea7n n\u1ed1i v\u0103n b\u1ea3n b\u1eb1ng d\u1ea5u ph\u00e2n c\u00e1ch.<\/span><\/p>\n<p><b>=CONCATENATE(A2,\u201d \u201c,B2,\u201d \u201c,C2,\u201d \u201c,D2,\u201d \u201c,E2)<\/b><\/p>\n<figure id=\"attachment_34781\" aria-describedby=\"caption-attachment-34781\" style=\"width: 624px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34781 size-full\" title=\"3- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-14.png\" alt=\"3- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" width=\"624\" height=\"407\"><figcaption id=\"caption-attachment-34781\" class=\"wp-caption-text\">3- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN<\/figcaption><\/figure>\n<p><b>=CONCAT (A2,\u201d \u201c,B2,\u201d \u201c,C2,\u201d \u201c,D2,\u201d \u201c,E2)<\/b><\/p>\n<figure id=\"attachment_34782\" aria-describedby=\"caption-attachment-34782\" style=\"width: 609px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34782 size-full\" title=\"4- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-14.png\" alt=\"4- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" width=\"609\" height=\"420\"><figcaption id=\"caption-attachment-34782\" class=\"wp-caption-text\">4- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ea5y, c\u00e1c h\u00e0m kh\u00f4ng x\u1eed l\u00fd c\u00e1c \u00f4 tr\u1ed1ng d\u1eabn \u0111\u1ebfn c\u00e1c kho\u1ea3ng tr\u1ed1ng b\u1ecb th\u1eeba.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, TEXTJOIN \u0111\u01b0\u1ee3c m\u1ec7nh danh l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn th\u1ef1c s\u1ef1 ph\u1ed5 bi\u1ebfn cho ng\u01b0\u1eddi d\u00f9ng l\u00e0m vi\u1ec7c v\u1edbi l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u v\u0103n b\u1ea3n. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ec9 \u0111\u1ecbnh d\u1ea5u ph\u00e2n c\u00e1ch, ch\u1ecdn b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi. \u0110\u00e2y l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p th\u00f4ng minh h\u01a1n.<\/span><\/p>\n<p><b>=TEXTJOIN(\u201d \u201c,TRUE,A2:E2)<\/b><\/p>\n<figure id=\"attachment_34783\" aria-describedby=\"caption-attachment-34783\" style=\"width: 626px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34783 size-full\" title=\"5- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-14.png\" alt=\"5- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN\" width=\"626\" height=\"420\"><figcaption id=\"caption-attachment-34783\" class=\"wp-caption-text\">5- K\u1ebft n\u1ed1i v\u0103n b\u1ea3n trong Excel b\u1eb1ng h\u00e0m CONCAT v\u00e0 TEXTJOIN<\/figcaption><\/figure>\n<p><em><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang d\u00f9ng Excel 2016, h\u00e3y kh\u00e1m ph\u00e1 c\u00e1c h\u00e0m TEXTJOIN v\u00e0 CONCAT \u0111\u1ec3 xem ch\u00fang h\u1eefu \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9! <strong>H\u1ecdc Excel Online<\/strong> xin ch\u00e0o t\u1ea1m bi\u1ec7t c\u00e1c b\u1ea1n.\u00a0<\/span><\/em><\/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-202.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2621,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2620","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\/2620","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=2620"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2621"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}