{"id":12287,"date":"2025-01-15T08:01:05","date_gmt":"2025-01-15T08:01:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-trim-trong-excel-huong-dan-su-dung-va-co-vi-du-cu-the\/"},"modified":"2025-01-15T08:01:05","modified_gmt":"2025-01-15T08:01:05","slug":"ham-trim-trong-excel-huong-dan-su-dung-va-co-vi-du-cu-the","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-trim-trong-excel-huong-dan-su-dung-va-co-vi-du-cu-the\/","title":{"rendered":"H\u00e0m TRIM trong Excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><strong>H\u00e0m TRIM trong Excel d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 nh\u1eefng kho\u1ea3ng tr\u1ed1ng kh\u00f4ng c\u1ea7n thi\u1ebft ra kh\u1ecfi v\u0103n b\u1ea3n, ch\u1ec9 \u0111\u1ec3 l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb. <\/strong><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67876b3e95587\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-trim-trong-excel.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-trim-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-trim-trong-excel.html#Su_dung_ham_TRIM_de_loai_bo_khoang_trang\" title=\"S\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng:\">S\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span><strong>C\u00fa ph\u00e1p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>=<strong>TRIM(text)<\/strong><\/p>\n<p><em>Trong \u0111\u00f3<\/em>: <em><strong>text <\/strong><\/em>l\u00e0 \u0111oan v\u0103n b\u1ea3n ch\u1ee9a kho\u1ea3ng tr\u1eafng c\u1ea7n lo\u1ea1i b\u1ecf.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>1<\/strong>\/ Lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng trong c\u1ed9t H\u1ecd v\u00e0 t\u00ean d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3559 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-trim.png\" width=\"600\" height=\"422\" title=\"ham-trim\"><\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:\u00a0<strong>=TRIM(C4)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3560 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-trim-1.png\" width=\"600\" height=\"421\" title=\"ham-trim-1\"><\/p>\n<ul>\n<li>Ta thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3562 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-trim-2.png\" width=\"600\" height=\"424\" title=\"ham-trim-2\"><\/p>\n<p><strong>2<\/strong>\/ K\u1ebft h\u1ee3p h\u00e0m <strong>TRIM<\/strong> v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\">h\u00e0m\u00a0<\/a><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\">CONCATENATE<\/a>\u00a0<\/strong>\u0111\u1ec3 n\u1ed1i c\u1ed9t H\u1ecd &amp; T\u00ean l\u00f3t v\u1edbi c\u1ed9t T\u00ean cho b\u1ea3ng s\u1ed1 li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3574 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-trim-3.png\" width=\"600\" height=\"420\" title=\"ham-trim-3\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-379.gif\" title=\"ex101_92019-nho-379\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>D\u00f9ng c\u00f4ng th\u1ee9c\u00a0<strong>=CONCATENATE(TRIM(C4);\u201d \u201c;D4) \u00a0<\/strong>n\u1ed1i 3 chu\u1ed7i g\u1ed3m, 1 chu\u1ed7i \u1edf c\u1ed9t H\u1ecd &amp; T\u00ean l\u00f3t, 1 kho\u1ea3ng tr\u1ed1ng v\u00e0 chu\u1ed7i \u1edf c\u1ed9t T\u00ean, ta c\u00f3 \u0111\u00e1p \u00e1n.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3575 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-trim-4.png\" width=\"600\" height=\"423\" title=\"ham-trim-4\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_TRIM_de_loai_bo_khoang_trang\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m TRIM trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00f3a nh\u1eefng kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba trong v\u0103n b\u1ea3n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 t\u1eebng b\u01b0\u1edbc \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u00e8n th\u00eam c\u1ed9t ph\u1ee5 v\u00e0o cu\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u1eb7t t\u00ean n\u00f3 l\u00e0 \u2018Trim\u2019<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Trong \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t ph\u1ee5 (C2), nh\u1eadp c\u00f4ng th\u1ee9c x\u00f3a kho\u1ea3ng tr\u1eafng <strong><em>=TRIM(A2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-trim-formula-delete-spaces.png\" title=\"excel-trim-formula-delete-spaces\"><\/em><\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Sao ch\u00e9p c\u00f4ng th\u1ee9c sang kh\u00e1c \u00f4 t\u00ednh kh\u00e1c trong c\u1ed9t.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Thay th\u1ebf c\u1ed9t g\u1ed1c b\u1eb1ng c\u1ed9t ph\u1ee5. Ch\u1ecdn t\u1ea5t c\u1ea3 \u00f4 t\u00ednh trong c\u1ed9t ph\u1ee5, nh\u1ea5n <code class=\"excel-formula-inline\"><strong><em>Ctrl + C <\/em><\/strong><\/code>\u0111\u1ec3 sao ch\u00e9p ch\u00fang v\u00e0o <strong><em>clipboard<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t g\u1ed1c, nh\u1ea5n <code class=\"excel-formula-inline\"><strong><em>Shift + F10 <\/em><\/strong><\/code>ho\u1eb7c n\u00fat <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5805\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/menu-button.png\" width=\"20\" height=\"18\" title=\"menu-button\"><strong><em>. <\/em><\/strong>Sau \u0111\u00f3 nh\u1ea5n <strong><em>V<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-spaces-between-words-to-1.png\" alt=\"Replace the original column with the one that has the extra spaces removed\" title=\"remove-spaces-between-words-to-1\"><\/p>\n<p>B\u01b0\u1edbc 6: X\u00f3a c\u1ed9t ph\u1ee5.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 x\u00f3a to\u00e0n b\u1ed9 c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba b\u1eb1ng h\u00e0m <strong><em>TRIM. <\/em><\/strong>Tuy nhi\u00ean, n\u1ebfu b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u1edbn, c\u00e1ch n\u00e0y s\u1ebd kh\u00e1 t\u1ed1n th\u1eddi gian.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excess-spaces-removed.png\" alt=\"Remove spaces between words to 1, remove leading and trailing spaces\" title=\"excess-spaces-removed\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu sau khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, b\u1ea1n v\u1eabn th\u1ea5y nh\u1eefng kho\u1ea3ng tr\u1eafng, h\u00e3y xem b\u00e0i <strong><em>N\u1ebfu h\u00e0m TRIM kh\u00f4ng l\u00e0m vi\u1ec7c<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam: T\u00f4\u0309ng h\u01a1\u0323p nh\u01b0\u0303ng ba\u0300i vi\u00ea\u0301t h\u01b0\u01a1\u0301ng d\u00e2\u0303n ho\u0323c <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a><\/p>\n<p><em><strong>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/strong><\/em><\/p>\n<p>Nh\u01b0 v\u00e2\u0323y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111a\u0303 gi\u1edbi thi\u1ec7u H\u00e0m TRIM trong Excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 \u0111\u1ebfn c\u00e1c b\u1ea1n ba\u0323n m\u00f4\u0323t ca\u0301c chi ti\u00ea\u0301t va\u0300 hi\u00ea\u0323u qua\u0309. N\u00ea\u0301u co\u0301 b\u00e2\u0301t ky\u0300 th\u0103\u0301c m\u0103\u0301c gi\u0300 ha\u0303y comment ngay d\u01b0\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y \u0111\u00ea\u0309 \u0111\u01b0\u01a1\u0323c \u0111\u00f4\u0323i ngu\u0303 nh\u00e2n vi\u00ean co\u0301 nhi\u00ea\u0300u n\u0103m kinh se\u0303 gia\u0309i quy\u00ea\u0301t th\u0103\u0301c m\u0103\u0301c cu\u0309a ba\u0323n trong th\u01a1\u0300i gian s\u01a1\u0301m nh\u00e2\u0301t.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-379.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12288,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12287","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12287"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12287\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12288"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}