{"id":8676,"date":"2021-08-24T14:07:04","date_gmt":"2021-08-24T07:07:04","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8676"},"modified":"2021-08-24T14:37:18","modified_gmt":"2021-08-24T07:37:18","slug":"cach-gop-ho-va-ten-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-gop-ho-va-ten-trong-excel\/","title":{"rendered":"C\u00e1ch g\u1ed9p h\u1ecd v\u00e0 t\u00ean trong Excel"},"content":{"rendered":"

1. C\u00e1ch g\u1ed9p h\u1ecd v\u00e0 t\u00ean trong Excel b\u1eb1ng \u201cto\u00e1n t\u1eed &\u201d<\/strong><\/h3>\n

M\u1ed9t trong nh\u1eefng c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 ti\u1ebfn h\u00e0ng g\u1ed9p 1 c\u1ed9t \u201ch\u1ecd\u201d v\u00e0 \u201ct\u00ean\u201d th\u00e0nh \u201ch\u1ecd &t\u00ean\u201d l\u00e0 s\u1eed d\u1ee5ng \u201cto\u00e1n t\u1eed &\u201d. C\u00e1ch n\u00e0y cho ph\u00e9p ch\u00fang ta n\u1ed1i 2 hay nhi\u1ec1u n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 l\u1ea1i v\u1edbi nhau m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

T\u1ea1i \u00f4 C2 nh\u01b0 v\u00ed d\u1ee5 minh h\u1ecda, ch\u00fang ta ti\u1ebfn h\u00e0nh n\u1ed1i \u00f4 A2 c\u00f9ng m\u1ed9t kho\u1ea3ng tr\u1eafng v\u1edbi \u00f4 B2 theo c\u00f4ng th\u1ee9c nh\u01b0 sau:=A2&” “&B2<\/strong><\/p>\n

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

Sau khi \u0111\u00e3 ti\u1ebfn h\u00e0nh nh\u1eadp xong c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n \u1ea5n \u201cEnter\u201d l\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 t\u1ea1i \u00f4 C2 l\u00e0 n\u1ed9i dung \u201ch\u1ecd & t\u00ean\u201d \u0111\u01b0\u1ee3c g\u1ed9p th\u00ec \u00f4 A2 v\u00e0 B2. \u0110\u1ec3 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian trong khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c t\u01b0\u01a1ng t\u1ef1, b\u1ea1n ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c \u201c=A2&” “&B2\u201d v\u00e0 c\u00e1c \u00f4 ti\u1ebfp theo \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u1ed9t n\u1ed1i \u201ch\u1ecd & t\u00ean\u201d ho\u00e0n ch\u1ec9nh.<\/p>\n

\"\"<\/p>\n

2. C\u00e1ch g\u1ed9p h\u1ecd v\u00e0 t\u00ean trong excel b\u1eb1ng s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i chu\u1ed7i CONCATENATE<\/strong><\/h3>\n

Ngo\u00e0i s\u1eed d\u1ee5ng \u201cto\u00e1n t\u1eed &\u201d \u0111\u1ec3 g\u1ed9p \u201ch\u1ecd\u201d v\u00e0 \u201ct\u00ean\u201d b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i chu\u1ed7i CONCATENATE trong Excel.<\/p>\n

T\u1ea1i \u00f4 C2 nh\u01b0 v\u00ed d\u1ee5 minh h\u1ecda, ch\u00fang ta ti\u1ebfn h\u00e0nh n\u1ed1i \u00f4 A2 c\u00f9ng m\u1ed9t kho\u1ea3ng tr\u1eafng v\u1edbi \u00f4 B2 theo c\u00f4ng th\u1ee9c nh\u01b0 sau:\u00a0=CONCATENATE(A2,” “,B2)<\/strong>\u00a0sau \u0111\u00f3 \u1ea5n ch\u1ecdn\u00a0\u201cEnter\u201d<\/strong><\/p>\n

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

Sau khi \u0111\u00e3 ti\u1ebfn h\u00e0nh nh\u1eadp xong c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n \u1ea5n \u201cEnter\u201d l\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 t\u1ea1i \u00f4 C2 l\u00e0 n\u1ed9i dung \u201ch\u1ecd & t\u00ean\u201d \u0111\u01b0\u1ee3c g\u1ed9p th\u00ec \u00f4 A2 v\u00e0 B2. \u0110\u1ec3 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian trong khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c t\u01b0\u01a1ng t\u1ef1, b\u1ea1n ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c\u201c=CONCATENATE(A2,” “,B2)\u201d<\/strong>\u00a0v\u00e0 c\u00e1c \u00f4 ti\u1ebfp theo \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u1ed9t n\u1ed1i \u201ch\u1ecd & t\u00ean\u201d ho\u00e0n ch\u1ec9nh.<\/p>\n

\"\"<\/p>\n

Nh\u01b0 v\u1eady th\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y,\u00a0 b\u1ea1n t\u00ecm hi\u1ec3u 2 c\u00e1ch g\u1ed9p h\u1ecd v\u00e0 t\u00ean trong Excel b\u1eb1ng \u201cto\u00e1n t\u1eed &\u201d v\u00e0 \u201c=CONCATENATE(A2,” “,B2)\u201d<\/strong>v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n mu\u1ed1n n\u00e2ng cao kh\u1ea3 n\u0103ng\u00a0tin h\u1ecdc v\u0103n ph\u00f2ng c\u1ee7a m\u00ecnh v\u1edbi Excel .<\/p>\n","protected":false},"excerpt":{"rendered":"

1. C\u00e1ch g\u1ed9p h\u1ecd v\u00e0 t\u00ean trong Excel b\u1eb1ng \u201cto\u00e1n t\u1eed &\u201d M\u1ed9t trong nh\u1eefng c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 ti\u1ebfn h\u00e0ng g\u1ed9p 1 c\u1ed9t \u201ch\u1ecd\u201d v\u00e0 \u201ct\u00ean\u201d th\u00e0nh \u201ch\u1ecd &t\u00ean\u201d l\u00e0 s\u1eed d\u1ee5ng \u201cto\u00e1n t\u1eed &\u201d. C\u00e1ch n\u00e0y cho ph\u00e9p ch\u00fang ta n\u1ed1i 2 hay nhi\u1ec1u n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 l\u1ea1i v\u1edbi nhau […]<\/p>\n","protected":false},"author":3,"featured_media":8678,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-8676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8676","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=8676"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8678"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}