{"id":2881,"date":"2024-12-02T09:25:05","date_gmt":"2024-12-02T09:25:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet\/"},"modified":"2024-12-02T09:25:05","modified_gmt":"2024-12-02T09:25:05","slug":"ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet\/","title":{"rendered":"H\u00c0M CONCATENATE: C\u00d4NG TH\u1ee8C H\u1ee2P NH\u1ea4T C\u00c1C \u00d4 TRONG GOOGLE SHEET"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nO_m37Xw#1\">\n<p><em><span style=\"font-weight: 400\">Concatenate \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng kh\u00e1 nhi\u1ec1u trong Excel cho c\u00e1c thao t\u00e1c n\u1ed1i v\u00e0 g\u1ed9p chu\u1ed7i. C\u00f2n trong b\u00e0i vi\u1ebft n\u00e0y th\u00ec <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd \u0111\u1ec1 c\u1eadp \u0111\u1ebfn <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html\"><strong>H\u00e0m concatenate trong Google Sheet<\/strong><\/a> \u0111\u1ec3 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng gi\u1ea3i quy\u1ebft c\u00e2u \u0111\u1ed1 v\u1ec1 n\u1ed1i.\u00a0\u00a0<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean, t\u1eadp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u1edbn \u0111\u1ebfn m\u1ee9c n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i c\u00f4ng vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c b\u1ea3n ghi t\u1eeb nhi\u1ec1u \u00f4 v\u1edbi nhau. V\u00e0 t\u00f4i ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd mu\u1ed1n kh\u00f4ng ch\u1ec9 gi\u1eef cho t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng b\u1ecb m\u1ea5t m\u00e0 c\u00f2n th\u00eam m\u1ed9t s\u1ed1 d\u1ea5u ph\u1ea9y, d\u1ea5u c\u00e1ch ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 kh\u00e1c, ho\u1eb7c th\u1eadm ch\u00ed t\u00e1ch c\u00e1c b\u1ea3n ghi \u0111\u00f3 v\u1edbi v\u0103n b\u1ea3n kh\u00e1c.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Google Sheet cung c\u1ea5p m\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 cho t\u00e1c v\u1ee5 n\u00e0y.<\/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-674d7cf0aaad4\" 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\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Ham_CONCAT_cua_Google_Sheet\" title=\"H\u00e0m CONCAT c\u1ee7a Google Sheet\">H\u00e0m CONCAT c\u1ee7a Google Sheet<\/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\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#CONCAT_thay_the_toan_tu_ky_hieu_va\" title=\"CONCAT thay th\u1ebf: to\u00e1n t\u1eed k\u00fd hi\u1ec7u v\u00e0 (&amp;)\">CONCAT thay th\u1ebf: to\u00e1n t\u1eed k\u00fd hi\u1ec7u v\u00e0 (&amp;)<\/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\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Cach_su_dung_CONCATENATE_trong_Google_Sheet\" title=\"C\u00e1ch s\u1eed d\u1ee5ng CONCATENATE trong Google Sheet\">C\u00e1ch s\u1eed d\u1ee5ng CONCATENATE trong Google Sheet<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Bang_tinh_Google_noi_voi_dau_phan_cach\" title=\"B\u1ea3ng t\u00ednh Google: n\u1ed1i v\u1edbi d\u1ea5u ph\u00e2n c\u00e1ch\u00a0\">B\u1ea3ng t\u00ednh Google: n\u1ed1i v\u1edbi d\u1ea5u ph\u00e2n c\u00e1ch\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Google_Sheet_ket_hop_ngay_va_gio\" title=\"Google Sheet: k\u1ebft h\u1ee3p ng\u00e0y v\u00e0 gi\u1edd\u00a0\">Google Sheet: k\u1ebft h\u1ee3p ng\u00e0y v\u00e0 gi\u1edd\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Ket_hop_cac_cot_trong_Google_Sheet\" title=\"K\u1ebft h\u1ee3p c\u00e1c c\u1ed9t trong Google Sheet\u00a0\">K\u1ebft h\u1ee3p c\u00e1c c\u1ed9t trong Google Sheet\u00a0<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Vi_du_1_CONCAT_cua_Google_Sheet\" title=\"V\u00ed d\u1ee5 1: CONCAT c\u1ee7a Google Sheet\u00a0\">V\u00ed d\u1ee5 1: CONCAT c\u1ee7a Google Sheet\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Vi_du_2_Toan_tu_noi\" title=\"V\u00ed d\u1ee5 2. To\u00e1n t\u1eed n\u1ed1i\u00a0\">V\u00ed d\u1ee5 2. To\u00e1n t\u1eed n\u1ed1i\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-concatenate-cong-thuc-hop-nhat-cac-o-trong-google-sheet.html#Vi_du_3_Google_Sheets_QUERY\" title=\"V\u00ed d\u1ee5 3: Google Sheets QUERY\u00a0\">V\u00ed d\u1ee5 3: Google Sheets QUERY\u00a0<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_CONCAT_cua_Google_Sheet\"><\/span><b>H\u00e0m CONCAT c\u1ee7a Google Sheet<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1ec1 c\u01a1 b\u1ea3n th\u00ec c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m concatenate trong google sheet c\u0169ng g\u1ea7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\">h\u00e0m concatenate trong Excel<\/a>.<\/strong><br \/>\nH\u00e0m CONCAT l\u00e0 phi\u00ean b\u1ea3n \u0111\u01a1n gi\u1ea3n h\u00f3a c\u1ee7a h\u00e0m CONCATENATE:\u00a0<\/span><\/p>\n<p><b>=CONCAT(value1, value2)<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 n\u1ed1i c\u00e1c \u00f4, n\u00f3 y\u00eau c\u1ea7u:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">value1 \u2013 m\u1ed9t b\u1ea3n ghi m\u00e0 value2 ph\u1ea3i \u0111\u01b0\u1ee3c n\u1ed1i v\u00e0o.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">value2 \u2013 gi\u00e1 tr\u1ecb \u0111\u1ec3 tham gia.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 nh\u1eadn m\u1ed9t chu\u1ed7i t\u1eeb 2 \u0111\u01a1n v\u1ecb v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1, c\u00f4ng th\u1ee9c s\u1ebd gi\u1ed1ng nh\u01b0 b\u00ean d\u01b0\u1edbi, v\u1edbi m\u1ed7i b\u1ea3n ghi trong d\u1ea5u ngo\u1eb7c k\u00e9p:\u00a0<\/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-220.gif\" title=\"ex101_92019-nho-220\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><b>=CONCAT(\u201c2019:\u201d,\u201dThe Lion King\u201d)<\/b><\/p>\n<figure id=\"attachment_34711\" aria-describedby=\"caption-attachment-34711\" style=\"width: 296px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34711 size-full\" title=\"1-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-10.png\" alt=\"1-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"296\" height=\"71\"><figcaption id=\"caption-attachment-34711\" class=\"wp-caption-text\">1-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong th\u1ef1c t\u1ebf, d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n r\u1ea5t c\u00f3 th\u1ec3 \u0111\u00e3 n\u1eb1m trong c\u00e1c \u00f4. B\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu tr\u1ef1c ti\u1ebfp c\u00e1c \u00f4 \u0111\u00f3 thay v\u00ec \u0111\u1eb7t t\u1eebng s\u1ed1 ho\u1eb7c v\u0103n b\u1ea3n l\u00e0m \u0111\u1ed1i s\u1ed1. V\u00ec v\u1eady, c\u00f4ng th\u1ee9c d\u1eef li\u1ec7u th\u1ef1c s\u1ebd nh\u01b0 th\u1ebf n\u00e0y:\u00a0<\/span><\/p>\n<p><b>=CONCAT(A2,B2)<\/b><\/p>\n<figure id=\"attachment_34712\" aria-describedby=\"caption-attachment-34712\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34712 size-full\" title=\"2-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-9.png\" alt=\"2-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"314\" height=\"145\"><figcaption id=\"caption-attachment-34712\" class=\"wp-caption-text\">2-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1eb9o: \u0110\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0o to\u00e0n b\u1ed9 c\u1ed9t, h\u00e3y ch\u1ecdn \u00f4 c\u00f3 c\u00f4ng th\u1ee9c v\u00e0 b\u1ea5m \u0111\u00fap v\u00e0o h\u00ecnh vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4. To\u00e0n b\u1ed9 c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00e0o c\u00f4ng th\u1ee9c, cho \u0111\u1ebfn cu\u1ed1i b\u1ea3ng.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, h\u00e0m n\u00e0y si\u00eau \u0111\u01a1n gi\u1ea3n, nh\u01b0ng n\u00f3 c\u00f3 \u0111i\u1ec3m y\u1ebfu ch\u00ednh:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u00f3 ch\u1ec9 cho ph\u00e9p 2 gi\u00e1 tr\u1ecb c\u00f9ng m\u1ed9t l\u00fac.\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u00f3 kh\u00f4ng th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c v\u00f9ng d\u1eef li\u1ec7u, ch\u1ec9 c\u00e1c \u00f4 \u0111\u01a1n l\u1ebb.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng h\u1ee3p nh\u1ea5t nhi\u1ec1u \u00f4, b\u1ea1n s\u1ebd g\u1eb7p l\u1ed7i ho\u1eb7c ch\u1ec9 c\u00f3 hai gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p, nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><b>=CONCAT(A2:A11,B2:B11)<\/b><\/p>\n<figure id=\"attachment_34713\" aria-describedby=\"caption-attachment-34713\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34713 size-full\" title=\"3-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-9.png\" alt=\"3-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"314\" height=\"145\"><figcaption id=\"caption-attachment-34713\" class=\"wp-caption-text\">3-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"CONCAT_thay_the_toan_tu_ky_hieu_va\"><\/span><b>CONCAT thay th\u1ebf: to\u00e1n t\u1eed k\u00fd hi\u1ec7u v\u00e0 (&amp;)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Google Sheet ch\u1ee9a c\u00e1c to\u00e1n t\u1eed kh\u00e1c nhau cho c\u00e1c m\u1ee5c \u0111\u00edch kh\u00e1c nhau. Concatenation kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t ngo\u1ea1i l\u1ec7. S\u1eed d\u1ee5ng k\u00fd t\u1ef1 v\u00e0 (&amp;) trong c\u00f4ng th\u1ee9c thay v\u00ec h\u00e0m CONCAT s\u1ebd cung c\u1ea5p cho b\u1ea1n k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1:\u00a0<\/span><\/p>\n<p><b>=A2&amp;B2<\/b><\/p>\n<figure id=\"attachment_34714\" aria-describedby=\"caption-attachment-34714\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34714 size-full\" title=\"4-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-10.png\" alt=\"4-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"314\" height=\"145\"><figcaption id=\"caption-attachment-34714\" class=\"wp-caption-text\">4-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0ng b\u1ea1n \u00edt bi\u1ebft r\u1eb1ng to\u00e1n t\u1eed \u0441oncatenation n\u00e0y linh ho\u1ea1t h\u01a1n CONCAT. \u0110\u00e2y l\u00e0 nh\u1eefng g\u00ec n\u00f3 c\u00f3 th\u1ec3 l\u00e0m:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u1ee3p nh\u1ea5t nhi\u1ec1u h\u01a1n hai gi\u00e1 tr\u1ecb c\u00f9ng m\u1ed9t l\u00fac:\u00a0<\/span><\/li>\n<\/ol>\n<p><b>=A2&amp;B2&amp;C2<\/b><\/p>\n<figure id=\"attachment_34715\" aria-describedby=\"caption-attachment-34715\" style=\"width: 415px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34715 size-full\" title=\"5-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-10.png\" alt=\"5-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"415\" height=\"145\"><figcaption id=\"caption-attachment-34715\" class=\"wp-caption-text\">5-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Kh\u00f4ng ch\u1ec9 h\u1ee3p nh\u1ea5t m\u1ed9t s\u1ed1 \u00f4 trong Google Sheet m\u00e0 c\u00f2n t\u00e1ch ch\u00fang b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 kh\u00e1c nhau:\u00a0<\/span><\/li>\n<\/ol>\n<p><b>=A2&amp;\u201d \u201c&amp;B2&amp;\u201d; \u201c&amp;C2<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n v\u1eabn kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn n\u00e0y, c\u00f3 m\u1ed9t ch\u1ee9c n\u0103ng n\u1eefa b\u1ea1n n\u00ean th\u1eed.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_CONCATENATE_trong_Google_Sheet\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng CONCATENATE trong Google Sheet<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">T\u00f4i tin r\u1eb1ng h\u00e0m CONCATENATE c\u1ee7a Google Sheet l\u00e0 h\u00e0m \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi k\u1ebft h\u1ee3p nhi\u1ec1u b\u1ea3n ghi v\u1edbi nhau.<\/span><\/p>\n<p><b>CONCATENATE v\u0103n b\u1ea3n v\u00e0 s\u1ed1 trong Google Sheet\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400\">M\u1eabu c\u00f4ng th\u1ee9c bao g\u1ed3m nh\u1eefng th\u1ee9 sau:\u00a0<\/span><\/p>\n<p><b>=CONCATENATE(string1, [string2, \u2026])<\/b><b>\u00a0<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">string1 l\u00e0 chu\u1ed7i \u0111\u1ea7u ti\u00ean b\u1ea1n mu\u1ed1n n\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c v\u00e0o. Tham s\u1ed1 n\u00e0y l\u00e0 b\u1eaft bu\u1ed9c.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">string2,\u2026 l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n th\u00eam v\u00e0o chu\u1ed7i ban \u0111\u1ea7u. Tham s\u1ed1 n\u00e0y l\u00e0 t\u00f9y ch\u1ecdn.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: B\u1ea3n ghi k\u1ebft qu\u1ea3 s\u1ebd bao g\u1ed3m c\u00e1c chu\u1ed7i theo th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a ch\u00fang trong c\u00f4ng th\u1ee9c.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u00f4i \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c v\u1edbi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, t\u00f4i s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y:\u00a0<\/span><\/p>\n<p><b>=CONCATENATE(A2,B2,C2)<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c, v\u00ec h\u00e0m ch\u1ea5p nh\u1eadn v\u00f9ng:\u00a0<\/span><\/p>\n<p><b>= CONCATENATE (A2: D2)<\/b><\/p>\n<figure id=\"attachment_34716\" aria-describedby=\"caption-attachment-34716\" style=\"width: 456px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34716 size-full\" title=\"6-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-10.png\" alt=\"6-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"456\" height=\"217\"><figcaption id=\"caption-attachment-34716\" class=\"wp-caption-text\">6-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y ngay \u01b0u \u0111i\u1ec3m \u0111\u1ea7u ti\u00ean c\u1ee7a Google Sheets CONCATENATE: n\u00f3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng k\u1ebft h\u1ee3p tr\u00ean hai \u00f4 v\u1edbi c\u1ea3 v\u0103n b\u1ea3n v\u00e0 s\u1ed1.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bang_tinh_Google_noi_voi_dau_phan_cach\"><\/span><b>B\u1ea3ng t\u00ednh Google: n\u1ed1i v\u1edbi d\u1ea5u ph\u00e2n c\u00e1ch\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p c\u00e1c \u00f4 trong Google Sheet l\u00e0 m\u1ed9t n\u1eeda c\u00f4ng vi\u1ec7c. Nh\u01b0ng \u0111\u1ec3 l\u00e0m cho k\u1ebft qu\u1ea3 tr\u00f4ng \u0111\u1eb9p v\u00e0 d\u1ec5 \u0111\u1ecdc, b\u1ea1n n\u00ean th\u00eam m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 ph\u1ee5.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111\u1eb7t c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady, n\u00f3 s\u1ebd n\u1ed1i v\u0103n b\u1ea3n v\u00e0 g\u1eafn m\u1ecdi th\u1ee9 l\u1ea1i v\u1edbi nhau: BonnieJacksonCA, BonnieJacksonIN, v.v. Tin t\u1ed1t l\u00e0 Google Sheets CONCATENATE c\u0169ng l\u1ea5y c\u00e1c k\u00fd t\u1ef1 l\u00e0m tham s\u1ed1.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Do \u0111\u00f3, \u0111\u1ec3 chia c\u00e1c chu\u1ed7i k\u1ebft h\u1ee3p b\u1eb1ng d\u1ea5u ph\u00e2n c\u00e1ch, ch\u1ec9 c\u1ea7n \u0111\u1ec1 c\u1eadp \u0111\u1ebfn ch\u00fang trong c\u00f4ng th\u1ee9c trong d\u1ea5u ngo\u1eb7c k\u00e9p:\u00a0<\/span><\/p>\n<p><b>=CONCATENATE(A2,\u201d \u201c,B2,\u201d, \u201c,C2)<\/b><b>\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y t\u00f4i mu\u1ed1n t\u00e1ch A2 kh\u1ecfi B2 b\u1eb1ng d\u1ea5u c\u00e1ch v\u00e0 B2 t\u1eeb C2\u00a0 v\u1edbi d\u1ea5u ph\u1ea9y v\u00e0 d\u1ea5u c\u00e1ch:<\/span><\/p>\n<figure id=\"attachment_34717\" aria-describedby=\"caption-attachment-34717\" style=\"width: 380px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34717 size-full\" title=\"7-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-9.png\" alt=\"7-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"380\" height=\"217\"><figcaption id=\"caption-attachment-34717\" class=\"wp-caption-text\">7-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do s\u1eed d\u1ee5ng h\u1ea7u h\u1ebft m\u1ecdi k\u00fd t\u1ef1 trong h\u00e0m nh\u01b0 th\u1ebf n\u00e0y, nh\u01b0ng ng\u1eaft d\u00f2ng y\u00eau c\u1ea7u m\u1ed9t c\u00e1ch ti\u1ebfp c\u1eadn kh\u00e1c.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb9o: Trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 c\u00e1c \u00f4 tr\u1ed1ng trong m\u1ed9t s\u1ed1 c\u1ed9t b\u1ea1n \u0111ang h\u1ee3p nh\u1ea5t, c\u00f3 m\u1ed9t ch\u1ee9c n\u0103ng kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m. TEXTJOIN kh\u00f4ng ch\u1ec9 h\u1ee3p nh\u1ea5t c\u00e1c \u00f4 v\u1edbi v\u0103n b\u1ea3n m\u00e0 c\u00f2n b\u1ecf qua kho\u1ea3ng tr\u1ed1ng:\u00a0<\/span><\/p>\n<p><b>= TEXTJOIN (\u201c\u201d, TRUE, A2: C2)\u00a0\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 c\u00e1ch n\u00f3 ho\u1ea1t \u0111\u1ed9ng:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ec9 ra m\u1ed9t d\u1ea5u ph\u00e2n c\u00e1ch mong mu\u1ed1n l\u00e0m tham s\u1ed1 \u0111\u1ea7u ti\u00ean \u2013 d\u1ea5u c\u00e1ch (\u201c\u201d) cho t\u00f4i.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1eb7t TRUE l\u00e0m tham s\u1ed1 th\u1ee9 hai \u0111\u1ec3 b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng ho\u1eb7c FALSE \u0111\u1ec3 \u0111\u01b0a ch\u00fang v\u00e0o k\u1ebft qu\u1ea3.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eadp ph\u1ea1m vi \u0111\u1ec3 h\u1ee3p nh\u1ea5t.<\/span><\/span>\n<p><figure id=\"attachment_34718\" aria-describedby=\"caption-attachment-34718\" style=\"width: 453px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34718 size-full\" title=\"8-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-9.png\" alt=\"8-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"453\" height=\"289\"><figcaption id=\"caption-attachment-34718\" class=\"wp-caption-text\">8-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">N\u1ed1i v\u0103n b\u1ea3n b\u1eb1ng d\u1ea5u ng\u1eaft d\u00f2ng\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb7c d\u00f9 r\u00f5 r\u00e0ng c\u00e1ch nh\u1eadp h\u1ea7u h\u1ebft c\u00e1c d\u1ea5u ph\u00e2n c\u00e1ch v\u00e0o h\u00e0m, b\u1ea1n kh\u00f4ng th\u1ec3 nh\u1eadp d\u1ea5u ng\u1eaft d\u00f2ng theo c\u00f9ng m\u1ed9t c\u00e1ch \u1edf \u0111\u00f3. Nh\u01b0ng may m\u1eafn thay, Google cho ph\u00e9p b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u lo\u1ea1i th\u1ebb kh\u00e1c nhau.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 m\u1ed9t ch\u1ee9c n\u0103ng gi\u00fap l\u1ea5y c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u2013 n\u00f3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 CHAR. V\u00e0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ec1u c\u00f3 m\u1ed9t v\u1ecb tr\u00ed trong b\u1ea3ng Unicode. V\u00ec v\u1eady, ch\u1ec9 c\u1ea7n n\u1ea1p s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a k\u00fd t\u1ef1 t\u1eeb b\u1ea3ng \u0111\u00f3 v\u00e0o h\u00e0m v\u00e0 h\u00e0m sau s\u1ebd tr\u1ea3 v\u1ec1 ch\u00ednh k\u00fd t\u1ef1 \u0111\u00f3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u1ea5y d\u1ea5u ng\u1eaft d\u00f2ng:\u00a0<\/span><\/p>\n<p><b>= CHAR (10)\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400\">Th\u00eam n\u00f3 v\u00e0o c\u00f4ng th\u1ee9c n\u1ed1i \u0111\u1ec3 c\u00f3 c\u00e1c b\u1ea3n ghi \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ng\u1eaft d\u00f2ng:\u00a0<\/span><\/p>\n<p><b>=CONCATENATE(A2,CHAR(10),B2,CHAR(10),C2,CHAR(10),D2)<\/b><\/p>\n<figure id=\"attachment_34719\" aria-describedby=\"caption-attachment-34719\" style=\"width: 557px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34719 size-full\" title=\"9-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-8.png\" alt=\"9-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"557\" height=\"316\"><figcaption id=\"caption-attachment-34719\" class=\"wp-caption-text\">9-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Google_Sheet_ket_hop_ngay_va_gio\"><\/span><b>Google Sheet: k\u1ebft h\u1ee3p ng\u00e0y v\u00e0 gi\u1edd\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng k\u1ebft h\u1ee3p ng\u00e0y v\u00e0 gi\u1edd b\u1eb1ng m\u1ed9t trong c\u00e1c ph\u01b0\u01a1ng ph\u00e1p tr\u00ean, ch\u00fang s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng. B\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c b\u1ea3n ghi d\u01b0\u1edbi d\u1ea1ng s\u1ed1 \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n<figure id=\"attachment_34720\" aria-describedby=\"caption-attachment-34720\" style=\"width: 454px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34720 size-full\" title=\"10-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h19-5.png\" alt=\"10-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"454\" height=\"217\"><figcaption id=\"caption-attachment-34720\" class=\"wp-caption-text\">10-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c \u00f4 n\u00e0y m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c trong Google Sheet, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m\u00a0<\/span><\/p>\n<p><b>=TEXT(number, format)<\/b><b>\u00a0<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">trong \u0111\u00f3 number l\u00e0 b\u1ea5t k\u1ef3 s\u1ed1, ng\u00e0y ho\u1eb7c gi\u1edd n\u00e0o b\u1ea1n mu\u1ed1n l\u1ea5y \u1edf \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">v\u00e0 \u0111\u1ecbnh d\u1ea1ng l\u00e0 m\u1eabu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">M\u1eb9o: Trong v\u00ed d\u1ee5 c\u1ee7a t\u00f4i, t\u00f4i s\u1ebd s\u1eed d\u1ee5ng tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 c\u00f3 ng\u00e0y v\u00e0 gi\u1edd, m\u1eb7c d\u00f9 b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp c\u00e1c b\u1ea3n ghi trong c\u00f4ng th\u1ee9c ho\u1eb7c th\u1eadm ch\u00ed h\u00e0m nh\u01b0 DATE ho\u1eb7c TIME.\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u00f4i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c TEXT \u0111\u1ea7u ti\u00ean \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y t\u1eeb 7\/9\/2019 \u0111\u1ebfn 9\/7\/2019:\u00a0<\/span><\/li>\n<\/ol>\n<p><b>=TEXT(B2,\u201dD MMM YYYY\u201d)<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">th\u1ee9 hai tr\u1ea3 v\u1ec1 th\u1eddi gian:\u00a0<\/span><\/li>\n<\/ol>\n<p><b>=TEXT(C2,\u201dHH:MM:SS\u201d)<\/b><b>\u00a0<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng nh\u1eefng th\u1ee9 n\u00e0y trong CONCATENATE, Google Sheet cho ph\u00e9p t\u00f4i k\u1ebft h\u1ee3p ng\u00e0y v\u00e0 gi\u1edd \u1edf \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n v\u1edbi c\u00e1c k\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n kh\u00e1c:\u00a0<\/span><\/li>\n<\/ol>\n<p><b>=ARRAYFORMULA(A2:A11&amp;\u201d \u201c&amp;B2:B11&amp;\u201d; \u201c&amp;C2:C11)<\/b><\/p>\n<figure id=\"attachment_34721\" aria-describedby=\"caption-attachment-34721\" style=\"width: 479px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34721 size-full\" title=\"11-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h11-7.png\" alt=\"11-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"479\" height=\"217\"><figcaption id=\"caption-attachment-34721\" class=\"wp-caption-text\">11-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_cac_cot_trong_Google_Sheet\"><\/span><b>K\u1ebft h\u1ee3p c\u00e1c c\u1ed9t trong Google Sheet\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1edbi nh\u1eefng \u0111i\u1ec1u ch\u1ec9nh nh\u1ecf, t\u1ea5t c\u1ea3 c\u00e1c c\u00e1ch t\u00f4i \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c c\u1ed9t trong Google Sheet.\u00a0\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_1_CONCAT_cua_Google_Sheet\"><\/span><b>V\u00ed d\u1ee5 1: CONCAT c\u1ee7a Google Sheet\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 h\u1ee3p nh\u1ea5t to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t trong Google Sheet v\u1edbi CONCAT, h\u00e3y ch\u1ecdn to\u00e0n b\u1ed9 d\u1ea3i \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 (trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a t\u00f4i l\u00e0 C2: C11) v\u00e0 ch\u1ee9a h\u00e0m trong ARRAYFORMULA:\u00a0<\/span><\/p>\n<p><b>=ARRAYFORMULA(CONCAT(A2:A11,B2:B11))<\/b><\/p>\n<figure id=\"attachment_34722\" aria-describedby=\"caption-attachment-34722\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34722 size-full\" title=\"12-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h12-6.png\" alt=\"12-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"314\" height=\"145\"><figcaption id=\"caption-attachment-34722\" class=\"wp-caption-text\">12-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m CONCATENATE, n\u00f3 s\u1ebd k\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi trong m\u1ed9t \u00f4 v\u00ec n\u00f3 d\u1ec5 d\u00e0ng h\u1ee3p nh\u1ea5t nhi\u1ec1u \u00f4 v\u00e0 v\u00f9ng d\u1eef li\u1ec7u.\u00a0\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_2_Toan_tu_noi\"><\/span><b>V\u00ed d\u1ee5 2. To\u00e1n t\u1eed n\u1ed1i\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">T\u1ea1o c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 k\u1ebft h\u1ee3p to\u00e0n b\u1ed9 c\u1ed9t v\u1edbi d\u1ea5u v\u00e0 v\u00e0 th\u00eam d\u1ea5u ph\u00e2n t\u00e1ch c\u00f9ng l\u00fac:\u00a0<\/span><\/p>\n<p><b>=ARRAYFORMULA(A2:A11&amp;\u201d \u201c&amp;B2:B11&amp;\u201d; \u201c&amp;C2:C11)<\/b><\/p>\n<figure id=\"attachment_34723\" aria-describedby=\"caption-attachment-34723\" style=\"width: 384px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34723 size-full\" title=\"13-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h13-6.png\" alt=\"13-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"384\" height=\"217\"><figcaption id=\"caption-attachment-34723\" class=\"wp-caption-text\">13-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u00f3 qu\u00e1 nhi\u1ec1u c\u1ed9t, vi\u1ec7c li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 ch\u00fang c\u00f3 th\u1ec3 tr\u1edf n\u00ean kh\u00f3 ch\u1ecbu, \u0111\u1eb7c bi\u1ec7t l\u00e0 n\u1ebfu b\u1ea1n v\u00f4 t\u00ecnh b\u1ecf qua \/ sao ch\u00e9p \/ tr\u1ed9n l\u1eabn b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i ra, n\u1ebfu b\u1ea1n quy\u1ebft \u0111\u1ecbnh th\u00eam nhi\u1ec1u c\u1ed9t v\u00e0o c\u00f4ng th\u1ee9c sau \u0111\u00f3, b\u1ea1n s\u1ebd ph\u1ea3i ch\u1ec9nh s\u1eeda t\u1eebng ph\u1ea1m vi hi\u1ec7n c\u00f3 trong c\u00f4ng th\u1ee9c theo c\u00e1ch th\u1ee7 c\u00f4ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 ti\u1ebfp theo gi\u1ea3i quy\u1ebft nh\u1eefng v\u1ea5n \u0111\u1ec1 n\u00e0y.\u00a0\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_3_Google_Sheets_QUERY\"><\/span><b>V\u00ed d\u1ee5 3: Google Sheets QUERY\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m Google Sheets QUERY c\u0169ng th\u00edch h\u1ee3p \u0111\u1ec3 h\u1ee3p nh\u1ea5t m\u1ed9t s\u1ed1 c\u1ed9t trong Google Sheet. H\u00e3y xem:\u00a0<\/span><\/p>\n<p><b>=TRANSPOSE(QUERY(TRANSPOSE(A2:D10),,9^9))<\/b><\/p>\n<figure id=\"attachment_34724\" aria-describedby=\"caption-attachment-34724\" style=\"width: 577px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34724 size-full\" title=\"14-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h14-5.png\" alt=\"14-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i\" width=\"577\" height=\"289\"><figcaption id=\"caption-attachment-34724\" class=\"wp-caption-text\">14-CONCATENATE trong Google Sheet: K\u1ebft h\u1ee3p chu\u1ed7i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 ngh\u0129 r\u1eb1ng c\u00f4ng th\u1ee9c k\u1ef3 l\u1ea1 n\u00e0y n\u1eb1m ngo\u00e0i kh\u1ea3 n\u0103ng c\u1ee7a b\u1ea1n, nh\u01b0ng h\u00e3y \u0111\u1ec3 t\u00f4i tr\u00ecnh b\u00e0y t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n c\u1ee7a n\u00f3 cho b\u1ea1n:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><b>=TRANSPOSE(A2:D10)<\/b><span style=\"font-weight: 400\"> bi\u1ebfn c\u00e1c h\u00e0ng d\u1eef li\u1ec7u th\u00e0nh c\u1ed9t.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>=QUERY(TRANSPOSE(A2:D10),,9^9)<\/b><span style=\"font-weight: 400\"> h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3n ghi trong m\u1ed7i c\u1ed9t v\u1edbi c\u00e1c \u00f4 tr\u00ean c\u00f9ng.\u00a0\u00a0<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">M\u1eb9o: Khi t\u00f4i \u0111\u1eb7t 9^9 v\u00e0o c\u00f4ng th\u1ee9c, t\u00f4i \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c k\u00e9o v\u00e0o h\u00e0ng \u0111\u1ea7u ti\u00ean nh\u01b0 th\u1ec3 ch\u00fang l\u00e0 ti\u00eau \u0111\u1ec1. N\u00f3 l\u00e0 9^9 v\u00ec n\u00f3 bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 th\u1ec3 c\u00f3 trong b\u1ea3ng t\u00ednh (h\u00e3y nh\u1edb gi\u1edbi h\u1ea1n cho 5 tri\u1ec7u \u00f4?) V\u00e0 r\u1ea5t d\u1ec5 nh\u1edb.\u00a0 \ud83d\ude42\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><b>=TRANSPOSE(QUERY(TRANSPOSE(A2:D10),,9^9))<\/b><span style=\"font-weight: 400\"> l\u1ea5y h\u00e0ng ti\u00eau \u0111\u1ec1 \u0111\u00f3 t\u1eeb QUERY v\u00e0 bi\u1ebfn n\u00f3 th\u00e0nh m\u1ed9t c\u1ed9t gi\u1ed1ng nh\u01b0 c\u1ed9t m\u00e0 t\u00f4i \u0111\u00e3 c\u00f3.\u00a0<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">C\u00e1c \u0111\u1eb7c quy\u1ec1n c\u1ee7a Google Sheets QUERY \u0111\u1ed1i v\u1edbi vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c c\u1ed9t n\u1eb1m \u1edf nh\u1eefng \u0111i\u1ec1u sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t nh\u01b0 c\u00e1ch b\u1ea1n l\u00e0m \u0111\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u1ec1 c\u1eadp \u0111\u1ebfn t\u1eebng c\u1ed9t trong c\u00f4ng th\u1ee9c tr\u1eeb khi ch\u00fang kh\u00f4ng li\u1ec1n nhau. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u00e2y l\u00e0 c\u00e1ch c\u00f4ng th\u1ee9c s\u1ebd tr\u00f4ng nh\u01b0 sau:\u00a0<\/span><\/li>\n<\/ul>\n<p><b>=TRANSPOSE(QUERY(TRANSPOSE({A2:A10,C2:C10,E2:E10,G2:G10}),,9^9))<br \/>\n<\/b><\/p>\n<p><em>Qua c\u00e1c v\u00ed d\u1ee5 c\u00e1c b\u1ea1n \u0111\u00e3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a <strong>h\u00e0m concatenate trong google sheet<\/strong> ch\u01b0a? H\u1ecdc Excel Online xin ch\u00fac b\u1ea1n h\u1ecdc t\u1eadp t\u1ed1t!<\/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-220.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2881","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\/2881","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=2881"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2881\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2882"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}