{"id":7676,"date":"2021-08-13T18:16:34","date_gmt":"2021-08-13T11:16:34","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7676"},"modified":"2021-08-18T11:08:28","modified_gmt":"2021-08-18T04:08:28","slug":"cach-gop-noi-dung-2-cot-trong-excel-thanh-noi-dung-hoan-chinh","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-gop-noi-dung-2-cot-trong-excel-thanh-noi-dung-hoan-chinh\/","title":{"rendered":"C\u00e1ch g\u1ed9p n\u1ed9i dung 2 c\u1ed9t trong Excel th\u00e0nh n\u1ed9i dung ho\u00e0n ch\u1ec9nh"},"content":{"rendered":"<p><strong>c\u00e1ch g\u1ed9p H\u1ecd v\u00e0 T\u00ean<\/strong>\u00a0\u1edf hai c\u1ed9t kh\u00e1c nhau t\u1ea1o th\u00e0nh n\u1ed9i dung H\u1ecd v\u00e0 T\u00ean \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<h1><span id=\"cach-1-su-dung-toan-tu-trong-excel\"><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng to\u00e1n t\u1eed &amp; trong Excel<\/strong><\/span><\/h1>\n<p>+ B\u01b0\u1edbc 1:\u00a0<strong><code>To\u00e1n t\u1eed &amp;<\/code><\/strong>\u00a0l\u00e0 c\u00e1ch t\u00ednh n\u1ed1i chu\u1ed7i, gh\u00e9p 2 ho\u1eb7c nhi\u1ec1u c\u1ed9t tr\u00ean file Excel nhanh nh\u1ea5t. \u0110\u1ea7u ti\u00ean b\u1ea1n click ch\u1ecdn \u00f4 v\u1ecb tr\u00ed n\u1ed9i dung m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7682\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/untitled-47.png\" alt=\"\" width=\"595\" height=\"342\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/untitled-47.png 595w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/untitled-47-400x230.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/untitled-47-510x293.png 510w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/p>\n<p>+ B\u01b0\u1edbc 2: Sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c\u00a0<code><strong>=gi\u00e1 tr\u1ecb h\u1ecd &amp;\u201d \u201c&amp;gi\u00e1 tr\u1ecb t\u00ean<\/strong><\/code>\u00a0=&gt; r\u1ed3i nh\u1ea5n\u00a0<code>Enter<\/code>\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<blockquote><p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0<strong>=<\/strong>B4&amp;\u201d \u201c&amp;C4<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7677\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1-3.png\" alt=\"\" width=\"598\" height=\"372\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1-3.png 598w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1-3-400x249.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1-3-510x317.png 510w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 ta s\u1ebd \u0111\u01b0\u1ee3c nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/p>\n<div id=\"blogc-2064736850\" class=\"blogc-qc_giua_post\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7678\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/2-2.png\" alt=\"\" width=\"598\" height=\"351\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/2-2.png 598w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/2-2-400x235.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/2-2-510x299.png 510w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<h1><span id=\"cach-2-su-dung-ham-noi-chuoi-concatenate\"><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m n\u1ed1i chu\u1ed7i CONCATENATE<\/strong><\/span><\/h1>\n<p><strong>+\u00a0<\/strong>B\u01b0\u1edbc 1: Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng\u00a0<code>to\u00e1n t\u1eed &amp;<\/code>\u00a0\u0111\u1ec3 g\u1ed9p H\u1ecd v\u00e0 T\u00ean, n\u1ed9i dung \u1edf hai c\u1ed9t ra th\u00ec b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i chu\u1ed7i\u00a0<code>CONCATENATE<\/code>\u00a0\u0111\u1ec3 g\u1ed9p 2 ho\u1eb7c nhi\u1ec1u n\u1ed9i dung c\u00e1c h\u00e0ng c\u1ed9t th\u00e0nh m\u1ed9t n\u1ed9i dung ho\u00e0n ch\u1ec9nh.<\/p>\n<p><strong>Th\u1ef1c hi\u1ec7n:<\/strong>\u00a0B\u1ea1n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t t\u1ea1i \u00f4 c\u1ea7n t\u1ea1o n\u1ed9i dung =&gt; r\u1ed3i nh\u1eadp c\u00f4ng th\u1ee9c:\u00a0<code><strong>=CONCATENATE(B4;\u201d \u201c;C4) =&gt;<\/strong><\/code>\u00a0r\u1ed3i nh\u1ea5n\u00a0<code>Enter<\/code>\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<p>T\u1ea1i \u0111\u1eady\u00a0<code>B4<\/code>\u00a0v\u00e0\u00a0<code>C4<\/code>\u00a0l\u00e0 hai \u0111\u1ed1i s\u1ed1 ch\u00fang ta c\u1ea7n g\u1ed9p.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7679\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/3-1.png\" alt=\"\" width=\"596\" height=\"370\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/3-1.png 596w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/3-1-400x248.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/3-1-510x317.png 510w\" sizes=\"auto, (max-width: 596px) 100vw, 596px\" \/><\/p>\n<p>Sau \u0111\u00f3 \u0111\u1ec3 Fill c\u00f4ng th\u1ee9c h\u00e0m, b\u1ea1n click chu\u1ed9t v\u00e0o \u00f4 \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 v\u00e0 d\u00ea chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, cho \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng m\u1ea3nh t\u1ea1i \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c =&gt; v\u00e0 k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i nh\u01b0 h\u00ecnh.<\/p>\n<div class=\"google-auto-placed ap_container\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7680\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/4-1.png\" alt=\"\" width=\"593\" height=\"364\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/4-1.png 593w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/4-1-400x246.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/4-1-510x313.png 510w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/p>\n<p>V\u00e0 ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7681\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/5.png\" alt=\"\" width=\"595\" height=\"366\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/5.png 595w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/5-400x246.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/5-510x314.png 510w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/p>\n<p><strong>L\u1eddi k\u1ebft<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 m\u00ecnh v\u1eeba h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n hai c\u00e1ch \u0111\u1ec3 <strong>g\u1ed9p n\u1ed9i dung c\u1ee7a c\u00e1c c\u1ed9t ch\u1ec9 \u0111\u1ecbnh v\u00e0o m\u1ed9t c\u1ed9t ho\u00e0n ch\u1ec9nh<\/strong>\u00a0duy nh\u1ea5t trong Excel r\u1ed3i nh\u00e9. Th\u1eadt \u0111\u01a1n gi\u1ea3n, v\u00e0 d\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng c\u00e1c b\u1ea1n ?<\/p>\n<p>Ph\u01b0\u01a1ng ph\u00e1p g\u1ed9p n\u1ed9i dung \u1edf c\u00e1c \u00f4, c\u1ed9t b\u1eb1ng c\u00e1ch d\u00f9ng\u00a0<strong>to\u00e1n t\u1eed &amp;<\/strong>, hay\u00a0<strong>d\u00f9ng h\u00e0m CONCATENATE<\/strong>\u00a0s\u1ebd tr\u1ea3 l\u1ea1i n\u1ed9i dung ho\u00e0n ch\u1ec9nh v\u00e0 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i nh\u01b0 \u00fd mu\u1ed1n c\u1ee7a b\u1ea1n.<\/p>\n<p>V\u00e0 \u0111\u1ebfn \u0111\u00e2y th\u00ec b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn c\u00e1ch g\u1ed9p 2 c\u1ed9t (H\u1ecd v\u00e0 T\u00ean), n\u1ed9i dung tr\u00ean 2 c\u1ed9t th\u00e0nh m\u1ed9t c\u1ed9t ho\u00e0n ch\u1ec9nh trong Excel c\u1ee7a m\u00ecnh c\u0169ng xin \u0111\u01b0\u1ee3c t\u1ea1m d\u1eebng r\u1ed3i. Hi v\u1ecdng th\u1ee7 thu\u1eadt n\u00e0y s\u1ebd h\u1eefu \u00edch trong qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp c\u0169ng nh\u01b0 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng !<\/p>\n<div id=\"blogc-751393794\" class=\"blogc-qc_truoc_post\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>c\u00e1ch g\u1ed9p H\u1ecd v\u00e0 T\u00ean\u00a0\u1edf hai c\u1ed9t kh\u00e1c nhau t\u1ea1o th\u00e0nh n\u1ed9i dung H\u1ecd v\u00e0 T\u00ean \u0111\u1ea7y \u0111\u1ee7. C\u00e1ch 1: S\u1eed d\u1ee5ng to\u00e1n t\u1eed &amp; trong Excel + B\u01b0\u1edbc 1:\u00a0To\u00e1n t\u1eed &amp;\u00a0l\u00e0 c\u00e1ch t\u00ednh n\u1ed1i chu\u1ed7i, gh\u00e9p 2 ho\u1eb7c nhi\u1ec1u c\u1ed9t tr\u00ean file Excel nhanh nh\u1ea5t. \u0110\u1ea7u ti\u00ean b\u1ea1n click ch\u1ecdn \u00f4 v\u1ecb tr\u00ed n\u1ed9i [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7682,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-7676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7676"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7682"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}