{"id":289658,"date":"2023-11-29T20:32:05","date_gmt":"2023-11-29T13:32:05","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=289658"},"modified":"2023-11-29T20:32:05","modified_gmt":"2023-11-29T13:32:05","slug":"ham-trim","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-trim\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TRIM trong Excel c\u00f3 v\u00ed d\u1ee5 minh ho\u1ea1"},"content":{"rendered":"

H\u00e0m TRIM trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1eafng hi\u1ec7u qu\u1ea3, nhanh ch\u00f3ng. V\u1eady b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1ed1ng ch\u01b0a? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 th\u1ef1c h\u00e0nh th\u00f4ng qua c\u00e1c b\u00e0i t\u1eadp nh\u00e9!\u00a0<\/span><\/p>\n

H\u00e0m TRIM l\u00e0 g\u00ec?\u00a0<\/span><\/h2>\n

Trong Excel, TRIM l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb v\u0103n b\u1ea3n, s\u1ed1,..v\u00e0 ch\u1ec9 gi\u1eef l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1ed1ng duy nh\u1ea5t. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng cao b\u1edfi khi l\u00e0m vi\u1ec7c tr\u00ean Excel, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng tr\u00e1nh kh\u1ecfi l\u1ed7i kho\u1ea3ng tr\u1eafng. Nh\u1eefng kho\u1ea3ng tr\u1eafng n\u00e0y khi\u1ebfn file Excel c\u1ee7a b\u1ea1n kh\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 g\u00e2y kh\u00f3 kh\u0103n khi th\u1ef1c hi\u1ec7n gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u. Do \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng Excel c\u1ea7n bi\u1ebft c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1eafng \u0111\u1ec3 kh\u00f4ng t\u1ed1n th\u1eddi gian ch\u1ec9nh s\u1eeda v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c.\u00a0<\/span><\/p>\n

\"ham-trim-2\"<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TRIM c\u01a1 b\u1ea3n trong Excel\u00a0<\/span><\/h2>\n

Tr\u01b0\u1edbc khi bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng, m\u1ecdi ng\u01b0\u1eddi c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u1ee7a h\u00e0m xo\u00e1 kho\u1ea3ng tr\u1ed1ng n\u00e0y. Trong Excel, c\u00fa ph\u00e1p TRIM l\u00e0:\u00a0<\/span><\/p>\n

=TRIM(text) trong \u0111\u00f3, text l\u00e0 \u00f4 d\u1eef li\u1ec7u c\u1ea7n lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1ed1ng th\u1eeba.\u00a0<\/span><\/p>\n

\u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u v\u00e0 th\u1ef1c hi\u1ec7n \u0111\u00fang c\u00fa ph\u00e1p h\u00e0m, ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 qua t\u1eebng b\u01b0\u1edbc nh\u01b0 sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n t\u1ea1o m\u1ed9t c\u1ed9t ph\u1ee5 trong b\u1ea3ng t\u00ednh -> ti\u1ebfn h\u00e0nh nh\u1eadp c\u00fa ph\u00e1p h\u00e0m t\u1ea1i c\u1ed9t ph\u1ee5 \u0111\u00f3. Ch\u1eb3ng h\u1ea1n nh\u01b0 ng\u01b0\u1eddi d\u00f9ng s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c =TRIM(F8) v\u00e0 nh\u1ea5n Enter. Trong \u0111\u00f3, F8 ch\u00ednh l\u00e0 \u00f4 d\u1eef li\u1ec7u ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n xo\u00e1 kho\u1ea3ng tr\u1ed1ng trong<\/span> h\u00e0m TRIM<\/b>.\u00a0<\/span><\/p>\n

\"ham-trim-3\"<\/p>\n

Sau khi nh\u1ea5n Enter, k\u1ebft qu\u1ea3 \u00f4 d\u1eef li\u1ec7u xo\u00e1 kho\u1ea3ng tr\u1ed1ng hi\u1ec3n th\u1ecb \u1edf c\u1ed9t ph\u1ee5. H\u1ec7 th\u1ed1ng s\u1ebd kh\u00f4ng thay \u0111\u1ed5i ki\u1ec3u ch\u1eef, size ch\u1eef c\u1ee7a \u00f4 v\u0103n b\u1ea3n. \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng cho nh\u1eefng \u00f4 d\u1eef li\u1ec7u sau, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n ch\u1ecdn d\u1ea5u c\u1ed9ng \u1edf ph\u00eda d\u01b0\u1edbi k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean r\u1ed3i k\u00e9o th\u1ea3 h\u1ebft v\u00f9ng d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 2: L\u00fac n\u00e0y, khi \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng \u1edf c\u1ed9t ph\u1ee5 th\u00ec m\u1ecdi ng\u01b0\u1eddi ch\u1ec9 c\u1ea7n sao ch\u00e9p r\u1ed3i d\u00e1n v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u. Nh\u01b0 v\u1eady, ch\u1ec9 v\u1edbi hai b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n, ng\u01b0\u1eddi d\u00f9ng Excel \u0111\u00e3 xo\u00e1 \u0111\u01b0\u1ee3c kho\u1ea3ng tr\u1ed1ng th\u1eeba m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.\u00a0<\/span><\/p>\n

\"ham-trim-4\"<\/p>\n

L\u01b0u \u00fd, khi s\u1eed d\u1ee5ng c\u00fa ph\u00e1p TRIM th\u00ec m\u1ecdi ng\u01b0\u1eddi c\u1ea7n k\u00e9o th\u1ea3 chu\u1ed9t th\u1ee7 c\u00f4ng. B\u00ean c\u1ea1nh \u0111\u00f3, h\u00e0m c\u00f4ng th\u1ee9c n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng text v\u00e0 kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng cho c\u00e1c d\u1eef li\u1ec7u s\u1ed1 hay d\u1ea1ng \u0111\u1eb7c bi\u1ec7t.\u00a0<\/span><\/p>\n

K\u1ebft h\u1ee3p h\u00e0m TRIM v\u1edbi CONCATENATE<\/span><\/h2>\n

\u0110\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng th\u1eeba v\u00e0 n\u1ed1i chu\u1ed7i d\u1eef li\u1ec7u v\u1edbi nhau th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c TRIM v\u1edbi h\u00e0m CONCATENATE. N\u1ebfu b\u1ea1n l\u1ef1a ch\u1ecdn n\u1ed1i v\u0103n b\u1ea3n b\u1eb1ng c\u00e1ch n\u00e0y th\u00ec h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc h\u01b0\u1edbng d\u1eabn sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i \u00f4 c\u1ea7n xu\u1ea5t hi\u1ec7n k\u1ebft qu\u1ea3 b\u1ea1n h\u00e3y nh\u1eadp c\u00fa ph\u00e1p =CONCATENATE(TRIM(B2),” “,C2)<\/span><\/p>\n

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

C2 l\u00e0 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n k\u1ebft n\u1ed1i.\u00a0<\/span><\/p>\n

” ” \u0111\u1ec3 t\u00e1ch gi\u1eefa h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m b\u1eb1ng m\u1ed9t kho\u1ea3ng tr\u1ed1ng.\u00a0<\/span><\/p>\n

TRIM(B2) t\u1ee9c l\u00e0 xo\u00e1 kho\u1ea3ng tr\u1ed1ng kh\u00f4ng c\u1ea7n thi\u1ebft \u1edf \u00f4 B2 v\u00e0 gi\u1eefa c\u00e1c ch\u1eef ch\u1ec9 gi\u1eef l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1ed1ng.\u00a0<\/span><\/p>\n

\"ham-trim-5\"<\/p>\n

B\u01b0\u1edbc 2: L\u00fac n\u00e0y, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n nh\u1ea5n Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 <\/span>h\u00e0m TRIM<\/b>. \u0110\u1ec3 n\u1ed1i d\u1eef li\u1ec7u nh\u1eefng \u00f4 c\u00f2n l\u1ea1i, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n gi\u1eef v\u00e0 k\u00e9o \u00f4 vu\u00f4ng \u1edf k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean \u0111\u1ebfn h\u1ebft v\u00f9ng d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n

\"ham-trim-6\"<\/p>\n

K\u1ebft h\u1ee3p h\u00e0m TRIM v\u1edbi \u201c&\u201d\u00a0<\/span><\/h2>\n

Th\u00eam m\u1ed9t c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c TRIM h\u1eefu \u00edch trong Excel m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft \u0111\u00f3 l\u00e0 k\u1ebft h\u1ee3p v\u1edbi d\u1ea5u \u201c&\u201d. M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c k\u1ebft h\u1ee3p n\u00e0y l\u00e0 \u0111\u1ec3 n\u1ed1i d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \u0111\u1ec3 k\u1ebft n\u1ed1i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i \u00f4 c\u1ea7n xu\u1ea5t hi\u1ec7n k\u1ebft qu\u1ea3, b\u1ea1n h\u00e3y nh\u1eadp c\u00fa ph\u00e1p =TRIM(B2)&” “&C2. L\u01b0u \u00fd, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1eadp ” ” \u0111\u1ec3 t\u00e1ch h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m v\u1edbi t\u00ean. N\u1ebfu ng\u01b0\u1eddi d\u00f9ng qu\u00ean kh\u00f4ng \u0111\u1ec3 k\u00fd t\u1ef1 n\u00e0y trong <\/span>h\u00e0m TRIM<\/b> th\u00ec hai ch\u1eef s\u1ebd b\u1ecb d\u00ednh v\u1edbi nhau ch\u1eb3ng h\u1ea1n nh\u01b0 Tr\u1ea7n Ng\u1ecdc Tr\u00e2n Nam.\u00a0<\/span><\/p>\n

\"ham-trim-7\"<\/p>\n

B\u01b0\u1edbc 2: Cu\u1ed1i c\u00f9ng, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1ea5n Enter tr\u00ean b\u00e0n ph\u00edm -> d\u00f9ng \u00f4 vu\u00f4ng nh\u1ecf b\u00ean d\u01b0\u1edbi k\u1ebft qu\u1ea3 k\u00e9o xu\u1ed1ng v\u00f9ng d\u1eef li\u1ec7u c\u00f2n l\u1ea1i. Nh\u01b0 v\u1eady, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng nhanh ch\u00f3ng, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng c\u1ea7n nh\u1eadp h\u00e0m th\u1ee7 c\u00f4ng.\u00a0<\/span><\/p>\n

\"ham-trim-8\"<\/p>\n

M\u1ed9t s\u1ed1 c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng trong Excel hi\u1ec7u qu\u1ea3\u00a0<\/span><\/h2>\n

Ngo\u00e0i<\/span> h\u00e0m TRIM<\/b>, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00e1ch kh\u00e1c \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng trong Excel nhanh ch\u00f3ng. Nh\u00ecn chung, c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng kh\u00f4ng c\u1ea7n thi\u1ebft trong Excel c\u00f3 c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n. Ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn th\u00eam m\u1ed9t s\u1ed1 c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng cho c\u00e1c b\u1ea1n tham kh\u1ea3o:\u00a0<\/span><\/p>\n

D\u00f9ng Find & Replace \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng<\/span><\/h3>\n

Trong nh\u1eefng c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng Excel, s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Find & Replace\u00a0 \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh nh\u1ea5t. \u0110\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng b\u1eb1ng Find & Replace, ng\u01b0\u1eddi d\u00f9ng h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i b\u1ea3ng t\u00ednh Excel, b\u1ea1n h\u00e3y b\u00f4i \u0111en c\u00f9ng d\u1eef li\u1ec7u c\u1ea7n xo\u00e1 kho\u1ea3ng tr\u1ed1ng. Ti\u1ebfp theo, ng\u01b0\u1eddi d\u00f9ng h\u00e3y ch\u1ecdn Find & Replace t\u1ea1i thanh c\u00f4ng c\u1ee5 -> ch\u1ecdn Replace.\u00a0<\/span><\/p>\n

\"ham-trim-9\"<\/p>\n

B\u01b0\u1edbc 2: H\u1ed9p tho\u1ea1i Find and Replace xu\u1ea5t hi\u1ec7n, b\u1ea1n h\u00e3y ch\u1ecdn Tab Replace, t\u1ea1i m\u1ee5c Find what nh\u1eadp t\u1eeb 3 \u0111\u1ebfn 5 d\u1ea5u c\u00e1ch (s\u1ed1 l\u01b0\u1ee3ng d\u1ea5u c\u00e1ch ph\u1ee5 thu\u1ed9c v\u00e0o kho\u1ea3ng tr\u1ed1ng tr\u00ean b\u1ea3ng t\u00ednh). T\u1ea1i m\u1ee5c Replace, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t d\u1ea5u c\u00e1ch -> ch\u1ecdn Find All.\u00a0<\/span><\/p>\n

\"ham-trim-10\"<\/p>\n

B\u01b0\u1edbc 3: L\u00fac n\u00e0y, c\u1eeda s\u1ed5 s\u1ebd hi\u1ec3n th\u1ecb nh\u1eefng d\u1eef li\u1ec7u c\u1ea7n thay th\u1ebf, ng\u01b0\u1eddi d\u00f9ng h\u00e3y ch\u1ecdn Replace All \u0111\u1ec3 thay th\u1ebf t\u1ea5t c\u1ea3.\u00a0<\/span><\/p>\n

\"ham-trim-11\"<\/p>\n

Sau khi ho\u00e0n t\u1ea5t thao t\u00e1c, b\u1ea3ng t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c xo\u00e1 kho\u1ea3ng tr\u1ed1ng. Tuy nhi\u00ean, gi\u1eefa c\u00e1c t\u1eeb c\u00f3 th\u1ec3 v\u1eabn c\u00f2n xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n m\u1ed9t kho\u1ea3ng tr\u1ed1ng. V\u00ec v\u1eady, ng\u01b0\u1eddi d\u00f9ng n\u00ean th\u1ef1c hi\u1ec7n m\u1ed9t l\u1ea7n n\u1eefa nh\u1eefng thao t\u00e1c nh\u01b0 tr\u00ean nh\u01b0ng \u1edf m\u1ee5c Find what s\u1ebd gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng kho\u1ea3ng tr\u1ed1ng.\u00a0<\/span><\/p>\n

Nh\u00ecn chung, \u0111\u00e2y l\u00e0 c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng \u0111\u01a1n gi\u1ea3n h\u01a1n so v\u1edbi <\/span>h\u00e0m TRIM <\/b>nh\u01b0ng t\u1ed3n t\u1ea1i m\u1ed9t s\u1ed1 nh\u01b0\u1ee3c \u0111i\u1ec3m. Ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i th\u1ef1c hi\u1ec7n nhi\u1ec1u l\u1ea7n v\u00e0 kh\u00f4ng xo\u00e1 \u0111\u01b0\u1ee3c kho\u1ea3ng tr\u1ed1ng th\u1eeba m\u1ed9t c\u00e1ch tri\u1ec7t \u0111\u1ec3. Khi s\u1eed d\u1ee5ng c\u00e1ch xo\u00e1 kho\u1ea3ng tr\u1ed1ng b\u1eb1ng Find & Replace, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ki\u1ec3m tra k\u1ef9 \u0111\u1ec3 tr\u00e1nh h\u1ec7 th\u1ed1ng b\u00e1o l\u1ed7i.\u00a0<\/span><\/p>\n

S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE\u00a0<\/span><\/h3>\n

Trong Excel, SUBSTITUTE l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u1ec3 xo\u00e1 kho\u1ea3ng tr\u1ed1ng \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u v\u0103n b\u1ea3n v\u00e0 s\u1ed1. H\u00e0m SUBSTITUTE c\u00f3 c\u00fa ph\u00e1p:\u00a0<\/span><\/p>\n

\u00a0=SUBSTITUTE(text,old_text,new_text,[instance_num])<\/span><\/p>\n

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