{"id":24492,"date":"2021-05-13T09:14:19","date_gmt":"2021-05-13T02:14:19","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24492"},"modified":"2021-05-13T09:14:19","modified_gmt":"2021-05-13T02:14:19","slug":"ham-concatenate-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-concatenate-trong-excel\/","title":{"rendered":"C\u00fa ph\u00e1p h\u00e0m Concatenate trong Excel v\u00e0 chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"

H\u00e0m Concatenate \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m text (h\u00e0m v\u0103n b\u1ea3n) trong Excel. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 n\u1ed1i c\u00e1c k\u00fd t\u1ef1 \u1edf t\u1eebng c\u1ed9t, t\u1ea1p th\u00e0nh chu\u1ed7i k\u00fd t\u1ef1, v\u0103n b\u1ea3n ho\u00e0n ch\u1ec9nh. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p h\u00e0m Concatenate trong Excel<\/strong> c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m Concatenate trong Excel<\/strong><\/h2>\n

H\u00e0m Concatenate trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=CONCATENATE(text1, [text2], \u2026)<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3:<\/p>\n

\u2013 Text1<\/strong>\u00a0l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c tham chi\u1ebfu \u00f4 ho\u1eb7c m\u1ed9t s\u1ed1.<\/p>\n

\u2013 Text2<\/strong>\u00a0c\u0169ng l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c. L\u00e0 chu\u1ed7i v\u0103n b\u1ea3n b\u1ed5 sung m\u00e0 ch\u00fang ta mu\u1ed1n n\u1ed1i. L\u01b0u \u00fd, ch\u00fang ta c\u00f3 th\u1ec3 n\u1ed1i, k\u1ebft h\u1ee3p t\u1ed1i \u0111a 255 chu\u1ed7i Text2.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Concatenate trong Excel<\/strong><\/h2>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Concatenate trong Excel<\/strong>, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

V\u00ed d\u1ee5 1<\/strong><\/h3>\n

Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Concatenate trong Excel<\/strong> \u0111\u1ec3 n\u1ed1i c\u00e1c chu\u1ed7i k\u00fd t\u1ef1, v\u0103n b\u1ea3n trong c\u00e1c \u00f4 A1 v\u00e0 B1.<\/p>\n

\"1<\/p>\n

V\u00ed d\u1ee5 2<\/strong><\/h3>\n

\u1ede v\u00ed d\u1ee5 n\u00e0y, thay v\u00ec s\u1eed d\u1ee5ng h\u00e0m Concatenate, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng to\u00e1n t\u1eed & \u0111\u1ec3 n\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

\"2<\/p>\n

V\u00ed d\u1ee5 3<\/strong><\/h2>\n

Trong v\u00ed d\u1ee5 n\u00e0y h\u00e0m Concatenate \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 n\u1ed1i chu\u1ed7i trong \u00f4 A1, chu\u1ed7i \u201cand\u201d (\u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p) v\u00e0 chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 B1.<\/p>\n

\"3<\/p>\n

T\u01b0\u01a1ng t\u1ef1, khi ch\u00fang ta s\u1eed d\u1ee5ng to\u00e1n t\u1eed & thay th\u1ebf h\u00e0m Concatenate, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng t\u1ef1.<\/p>\n

\"4<\/p>\n

V\u00ed d\u1ee5 4<\/strong><\/h3>\n

H\u00e0m Concatenate d\u01b0\u1edbi \u0111\u00e2y n\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 A1, d\u1ea5u c\u00e1ch v\u00e0 chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 B1.<\/p>\n

\"5<\/p>\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Concatenate trong Excel<\/strong><\/h2>\n