{"id":13510,"date":"2015-09-18T02:39:11","date_gmt":"2015-09-18T02:39:11","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13510"},"modified":"2015-09-29T09:22:51","modified_gmt":"2015-09-29T09:22:51","slug":"cach-dung-ham-noi-chuoi-ham-ghep-chuoi-trong-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13510","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m n\u1ed1i chu\u1ed7i, h\u00e0m gh\u00e9p chu\u1ed7i trong Excel"},"content":{"rendered":"

\"C\u00e1ch<\/p>\n

Trong Excel, khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a H\u1ecd, T\u00ean kh\u00e1ch h\u00e0ng th\u00ec th\u01b0\u1eddng \u0111i k\u00e8m v\u1edbi c\u1ed9t H\u1ecd v\u00e0 c\u1ed9t t\u00ean kh\u00e1ch h\u00e0ng. Trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p n\u00e0y Excel c\u00f3 c\u00e1c h\u00e0m d\u00f9ng \u0111\u1ec3 n\u1ed1i 2 chu\u1ed7i H\u1ecd, T\u00ean kh\u00e1ch h\u00e0ng v\u1edbi nhau thay v\u00ec ph\u1ea3i g\u00f5 l\u1ea1i h\u1ecd v\u00e0 t\u00ean d\u1ef1a tr\u00ean 2 c\u1ed9t \u0111\u00f3.<\/span><\/p>\n

\u0110\u1ec3 n\u1ed1i chu\u1ed7i trong Excel ta th\u01b0\u1eddng d\u00f9ng 2 c\u00e1ch sau: D\u00f9ng h\u00e0m to\u00e1n t\u1eed \u201c&<\/strong>\u201d ho\u1eb7c d\u00f9ng h\u00e0m \u201cCONCATENATE<\/strong>\u201d. \u0110\u1ec3 hi\u1ec3u r\u00f5 \u0111\u01b0\u1ee3c c\u00e1ch n\u1ed1i chu\u1ed7i trong Excel nh\u01b0 th\u1ebf n\u00e0o, k\u1ebf to\u00e1n Centax<\/a><\/strong> xin gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc c\u00e1ch d\u00f9ng h\u00e0m n\u1ed1i chu\u1ed7i, h\u00e0m gh\u00e9p chu\u1ed7i trong Excel.<\/span><\/p>\n

1. D\u00f9ng h\u00e0m to\u00e1n t\u1eed \u201c&\u201d \u0111\u1ec3 n\u1ed1i chu\u1ed7i, gh\u00e9p chu\u1ed7i trong Excel<\/span><\/h2>\n

C\u00fa ph\u00e1p: =Chu\u1ed7i1&Chu\u1ed7i2&\u2026<\/strong><\/span><\/p>\n

Trong \u0111\u00f3: chu\u1ed7i1, chu\u1ed7i2,\u2026 l\u00e0 c\u00e1c ph\u1ea7n t\u1eed r\u1eddi ra khi ta c\u1ea7n n\u1ed1i<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

2. D\u00f9ng h\u00e0m n\u1ed1i chu\u1ed7i CONCATENATE<\/span><\/h2>\n

C\u00fa ph\u00e1p: =CONCATENATE(text1,text2,\u2026)<\/strong><\/span><\/p>\n

Trong \u0111\u00f3: text1 l\u00e0 chu\u1ed7i th\u1ee9 1, text2 l\u00e0 chu\u1ed7i th\u1ee9 2,\u2026<\/span><\/p>\n

Vi\u1ec7c \u0111\u00e1nh d\u1ea5u \u201c,\u201d hay d\u1ea5u\u201d;\u201d trong h\u00e0m ph\u1ee5 thu\u1ed9c v\u00e0o c\u00e0i \u0111\u1eb7t trong m\u00e1y t\u00ednh c\u1ee7a t\u1eebng b\u1ea1n<\/span><\/em><\/p>\n

\"C\u00e1ch<\/p>\n

L\u01b0u \u00fd: Trong c\u1ea3 2 c\u00e1ch d\u00f9ng khi ta mu\u1ed1n gi\u1eefa c\u00e1c chu\u1ed7i\u00a0n\u1ed1i c\u00f3 kho\u1ea3ng tr\u1eafng th\u00ec gi\u1eefa 2 d\u1ea5u (\u201c\u201d) ta \u0111\u1ec3 kho\u1ea3ng tr\u1eafng, n\u1ebfu mu\u1ed1n c\u00e1c chu\u1ed7i n\u1ed1i li\u1ec1n d\u00ednh v\u00e0o nhau th\u00ec gi\u1eefa 2 d\u1ea5u (\u201c\u201d) ta vi\u1ebft li\u1ec1n.<\/span><\/p>\n

M\u1eddi b\u1ea1n tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft c\u00f3 li\u00ean quan kh\u00e1c:<\/span><\/p>\n

T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n

Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n Excel<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel<\/a><\/span><\/p>\n

C\u00e1ch \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong Excel 2003, 2007, 2010, 2013<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1ch d\u00f9ng h\u00e0m n\u1ed1i chu\u1ed7i, h\u00e0m gh\u00e9p chu\u1ed7i trong Excel. \u0110\u00e2y l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 n\u1ed1i c\u00e1c chu\u1ed7i khi b\u1ecb t\u00e1ch r\u1eddi. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1700,1701],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13510"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13510"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13510\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13777"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13510"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}