{"id":24382,"date":"2021-05-11T16:08:53","date_gmt":"2021-05-11T09:08:53","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24382"},"modified":"2021-05-11T16:08:53","modified_gmt":"2021-05-11T09:08:53","slug":"ham-trim-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-trim-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Trim trong Excel qua b\u00e0i t\u1eadp v\u1eadn d\u1ee5ng"},"content":{"rendered":"

Trong qu\u00e1 tr\u00ecnh sao ch\u00e9p v\u0103n b\u1ea3n v\u00e0o Excel, \u0111\u00f4i khi ch\u00fang ta c\u00f3 th\u1ec3 sao ch\u00e9p c\u1ea3 c\u00e1c k\u00fd t\u1ef1 ch\u1eb3ng h\u1ea1n nh\u01b0 kho\u1ea3ng tr\u1eafng. Thay v\u00ec x\u00f3a c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng n\u00e0y theo c\u00e1ch th\u1ee7 c\u00f4ng v\u1eeba m\u1ea5t th\u1eddi gian v\u1eeba d\u1ec5 b\u1ecb nh\u1ea7m l\u1eabn, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u00e0 nhanh nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Trim trong Excel<\/strong>.<\/p>\n

H\u00e0m Trim trong Excel<\/strong><\/h2>\n

H\u00e0m Trim trong Excel<\/strong> ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 h\u00e0m x\u00f3a, lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba kh\u1ecfi chu\u1ed7i v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 ho\u1eb7c \u00f4 ch\u1ee9a v\u0103n b\u1ea3n, ch\u1ec9 \u0111\u1ec3 l\u1ea1i kho\u1ea3ng tr\u1eafng duy nh\u1ea5t gi\u1eefa c\u00e1c k\u00fd t\u1ef1. Ngo\u00e0i h\u00e0m TRIM, h\u00e0m SUBSTITUTE Excel c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00f3a kho\u1ea3ng tr\u1eafng. \u0110i\u1ec3m kh\u00e1c l\u00e0 l\u00e0 h\u00e0m TRIM x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba tr\u01b0\u1edbc, sau v\u00e0 gi\u1eefa d\u1eef li\u1ec7u c\u00f2n h\u00e0m SUBSTITUTE x\u00f3a h\u1ebft kho\u1ea3ng tr\u1eafng trong \u00f4.<\/p>\n

\"H\u00e0m
H\u00e0m Trim trong Excel<\/figcaption><\/figure>\n

Cho v\u00ed d\u1ee5, gi\u1ea3 s\u1eed m\u1ed9t \u00f4 trong b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

Mua m\u00e1y t\u00ednh Ben Computer<\/p>\n

Trong chu\u1ed7i tr\u00ean ch\u1ec9 ch\u1ee9a kho\u1ea3ng tr\u1eafng duy nh\u1ea5t gi\u1eefa c\u00e1c k\u00fd t\u1ef1. Tuy nhi\u00ean trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu xu\u1ea5t hi\u1ec7n kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n, v\u00ed d\u1ee5: \u201cMua m\u00e1y t\u00ednh Ben Computer\u201d ho\u1eb7c c\u00f3 nhi\u1ec1u kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb, ch\u1eb3ng h\u1ea1n nh\u01b0 \u201cMua m\u00e1y t\u00ednh Ben Computer.\u201d. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Trim trong Excel \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng n\u00e0y \u0111i thay v\u00ec th\u1ef1c hi\u1ec7n theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n

H\u00e0m Trim Excel nhanh ch\u00f3ng lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1ed1ng kh\u00f4ng c\u1ea7n thi\u1ebft kh\u1ecfi t\u1eadp h\u1ee3p d\u1eef li\u1ec7u l\u1edbn, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c kho\u1ea3ng th\u1eddi gian.<\/p>\n

H\u1ea1n ch\u1ebf duy nh\u1ea5t l\u00e0 h\u00e0m Trim ch\u1ec9 x\u00f3a k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng ASCII (gi\u00e1 tr\u1ecb th\u1eadp ph\u00e2n 32) kh\u1ecfi chu\u1ed7i v\u0103n b\u1ea3n, \u0111\u00e2y l\u00e0 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng ti\u00eau chu\u1ea9n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong h\u1ea7u h\u1ebft v\u0103n b\u1ea3n.<\/p>\n

S\u1eed d\u1ee5ng h\u00e0m Trim trong Excel<\/strong><\/h2>\n

H\u00e0m Trim trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00f3a, lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1ed1ng d\u01b0 th\u1eeba trong c\u00e1c \u00f4. Tuy nhi\u00ean h\u00e0m Excel n\u00e0y ch\u1ec9 lo\u1ea1i b\u1ecf c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1ed1ng ASCII 7-bit kh\u1ecfi chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 kho\u1ea3ng tr\u1ed1ng kh\u00f4ng ng\u1eaft.<\/p>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Trim trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, ch\u00fang ta c\u00f9ng xem qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

Trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Trim Excel<\/strong> \u0111\u1ec3 x\u00f3a c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng kh\u00f4ng c\u1ea7n thi\u1ebft trong \u00f4 A2.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Trim c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=TRIM(A2)<\/strong><\/p>\n

\"1<\/p>\n

Ngo\u00e0i ra \u0111\u1ec3 lo\u1ea1i b\u1ecf, x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba kh\u1ecfi chu\u1ed7i v\u0103n b\u1ea3n tr\u1ef1c ti\u1ebfp, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Trim Excel d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=TRIM(\u201d This is a text string \u201c)<\/strong><\/p>\n

Nh\u01b0 Ben Computer \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, h\u00e0m Trim trong Excel<\/strong> ch\u1ec9 x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba ASCII (gi\u00e1 tr\u1ecb th\u1eadp ph\u00e2n 32) kh\u1ecfi chu\u1ed7i v\u0103n b\u1ea3n. H\u00e0m kh\u00f4ng h\u1ed7 tr\u1ee3 x\u00f3a c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft, v\u00ec v\u1eady b\u1ea1n s\u1ebd ph\u1ea3i ki\u1ec3m tra v\u00e0 thao t\u00e1c theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n

L\u01b0u \u00fd, c\u00e1c kho\u1ea3ng tr\u1eafng n\u00e0y kh\u00f3 c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y b\u1eb1ng m\u1eaft. Kho\u1ea3ng tr\u1eafng th\u00f4ng th\u01b0\u1eddng m\u00e0 ch\u00fang ta nh\u1eadp khi ki\u1ec3m tra s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i 32, c\u00f2n kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft khi ch\u00fang ta ki\u1ec3m tra k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 m\u00e3 160.<\/p>\n

S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Trim v\u1edbi h\u00e0m SUBSTITUTE<\/strong><\/h2>\n

Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p n\u1ebfu ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Trim ho\u1eb7c h\u00e0m SUBSTITUTE m\u00e0 c\u00e1c h\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ed7i N\/A. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, c\u00e1ch \u0111\u01a1n gian nh\u1ea5t l\u00e0 k\u1ebft h\u1ee3p h\u00e0m Trim v\u1edbi h\u00e0m SUBSTITUTE.<\/p>\n

M\u1ed9t l\u01b0u \u00fd n\u1eefa l\u00e0 ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Trim v\u1edbi h\u00e0m CONCATENATE v\u00e0 m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c nh\u01b0 VLOOKUP, SUM, VALUE, \u2026. .<\/p>\n

Nh\u01b0 v\u1eady b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Trim trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o. Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/a> nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

Trong qu\u00e1 tr\u00ecnh sao ch\u00e9p v\u0103n b\u1ea3n v\u00e0o Excel, \u0111\u00f4i khi ch\u00fang ta c\u00f3 th\u1ec3 sao ch\u00e9p c\u1ea3 c\u00e1c k\u00fd t\u1ef1 ch\u1eb3ng h\u1ea1n nh\u01b0 kho\u1ea3ng tr\u1eafng. Thay v\u00ec x\u00f3a c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng n\u00e0y theo c\u00e1ch th\u1ee7 c\u00f4ng v\u1eeba m\u1ea5t th\u1eddi gian v\u1eeba d\u1ec5 b\u1ecb nh\u1ea7m l\u1eabn, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u00e0 nhanh nh\u1ea5t […]<\/p>\n","protected":false},"author":39,"featured_media":24383,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24382","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24382"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24382\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24383"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}