{"id":9404,"date":"2025-01-02T05:31:52","date_gmt":"2025-01-02T05:31:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tim-hieu-ve-cac-thao-tac-voi-3-ki-tu-khoang-trong-dac-biet-thong-dung-trong-excel\/"},"modified":"2025-01-02T05:31:52","modified_gmt":"2025-01-02T05:31:52","slug":"tim-hieu-ve-cac-thao-tac-voi-3-ki-tu-khoang-trong-dac-biet-thong-dung-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tim-hieu-ve-cac-thao-tac-voi-3-ki-tu-khoang-trong-dac-biet-thong-dung-trong-excel\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c thao t\u00e1c v\u1edbi 3 k\u00ed t\u1ef1 kho\u1ea3ng tr\u1ed1ng \u0111\u1eb7c bi\u1ec7t th\u00f4ng d\u1ee5ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd c\u00f9ng b\u1ea1n \u0111i t\u00ecm hi\u1ec3u v\u1ec1 3 k\u00ed t\u1ef1 kho\u1ea3ng tr\u1ed1ng \u0111\u1eb7c bi\u1ec7t th\u00f4ng d\u1ee5ng trong Excel bao g\u1ed3m k\u00ed t\u1ef1 ng\u1eaft d\u00f2ng, d\u1ea5u c\u00e1ch v\u00e0 k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng.<\/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-677624c821429\" 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<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/3-ki-tu-khoang-trong-dac-bie-excel.html#Ki_tu_ngat_dong\" title=\"K\u00ed t\u1ef1 ng\u1eaft d\u00f2ng\">K\u00ed t\u1ef1 ng\u1eaft d\u00f2ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/3-ki-tu-khoang-trong-dac-bie-excel.html#Dau_cach\" title=\"D\u1ea5u c\u00e1ch\">D\u1ea5u c\u00e1ch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/3-ki-tu-khoang-trong-dac-bie-excel.html#Ki_tu_khoang_trang_dac_biet_160\" title=\"K\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t 160\">K\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t 160<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ki_tu_ngat_dong\"><\/span>K\u00ed t\u1ef1 ng\u1eaft d\u00f2ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Excel, \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong 1 \u00f4 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Alt + Enter. Khi ph\u00e2n t\u00edch k\u0129 b\u1eb1ng h\u00e0m CODE, ta nh\u1eadn \u0111\u01b0\u1ee3c con s\u1ed1 10.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tra c\u1ee9u con s\u1ed1 n\u00e0y trong b\u1ea3ng m\u00e3 ASCII. \u0110\u00e2y l\u00e0 s\u1ed1 bi\u1ec3u th\u1ecb cho k\u00ed t\u1ef1 ng\u1eaft d\u00f2ng. \u0110\u1ec3 chuy\u1ec3n t\u1eeb s\u1ed1 bi\u1ec3u th\u1ecb th\u00e0nh k\u00ed t\u1ef1 trong Excel ta s\u1eed d\u1ee5ng h\u00e0m CHAR, c\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 CHAR(10).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24617\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ki-tu-khoang-trong-1.png\" width=\"250\" height=\"53\" title=\"ki-tu-khoang-trong-1\"><\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p li\u00ean quan \u0111\u1ebfn k\u00ed t\u1ef1 ng\u1eaft d\u00f2ng n\u00e0y m\u00e0 ta c\u1ea7n nh\u1edb \u0111\u00f3 l\u00e0\u00a0<strong>t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng trong Excel<\/strong>, \u0111\u00e2y l\u00e0 k\u0129 thu\u1eadt c\u1ea7n bi\u1ebft trong tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c g\u1eedi \u0111\u1ebfn nh\u00e9t v\u00e0o m\u1ed9t d\u00f2ng g\u00e2y kh\u00f3 kh\u0103n cho vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 qu\u1ea3n l\u00fd.<\/p>\n<p>Tham kh\u1ea3o v\u1ec1 c\u00e1ch l\u00e0m t\u1ea1i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong.html\">\u0111\u00e2y<\/a>.<\/strong><\/p>\n<p>\u00a0<\/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-49.gif\" title=\"ex101_92019-nho-49\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dau_cach\"><\/span>D\u1ea5u c\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t k\u00ed t\u1ef1 r\u1ea5t quen thu\u1ed9c \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel. D\u1ea5u c\u00e1ch c\u00f3 s\u1ed1 bi\u1ec3u th\u1ecb trong b\u1ea3ng m\u00e3 ASCII l\u00e0 32, ngh\u0129a l\u00e0 khi ng\u01b0\u1eddi s\u1eed d\u1ee5ng d\u00f9ng h\u00e0m CODE cho d\u1ea5u c\u00e1ch s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb 32, hay c\u00f4ng th\u1ee9c =CHAR(32) s\u1ebd tr\u1ea3 v\u1ec1 d\u1ea5u c\u00e1ch.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24618\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ki-tu-khoang-trong-2.png\" width=\"251\" height=\"55\" title=\"ki-tu-khoang-trong-2\"><\/p>\n<p>C\u00e1c thao t\u00e1c li\u00ean quan t\u1edbi d\u1ea5u c\u00e1ch bao g\u1ed3m:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel.html\">X\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba trong Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html\">L\u00e0m s\u1ea1ch d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng<\/a><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ki_tu_khoang_trang_dac_biet_160\"><\/span>K\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t 160<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>K\u1ec3 \u0111\u1ebfn \u1edf \u0111\u00e2y l\u00e0 kho\u1ea3ng tr\u1eafng kh\u00f4ng ng\u1eaft k\u00ed t\u1ef1 (non-breaking space) c\u00f3 s\u1ed1 bi\u1ec3u th\u1ecb trong b\u1ea3ng m\u00e3 ASCII l\u00e0 160. N\u1ebfu kh\u00f4ng \u0111\u1ec3 \u00fd ta s\u1ebd nh\u1ea7m v\u1edbi kho\u1ea3ng tr\u1eafng th\u00f4ng th\u01b0\u1eddng, tuy nhi\u00ean h\u00e0m TRIM kh\u00f4ng th\u1ec3 x\u00f3a \u0111\u01b0\u1ee3c k\u00ed t\u1ef1 n\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24619\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ki-tu-khoang-trong-3.png\" width=\"250\" height=\"75\" title=\"ki-tu-khoang-trong-3\"><\/p>\n<p>V\u1edbi m\u1eaft th\u01b0\u1eddng quan s\u00e1t, hai \u00f4 kh\u00f4ng kh\u00e1c g\u00ec nhau, ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>\u0110\u1ec3 x\u1eed l\u00fd k\u00ed t\u1ef1 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u1eefng b\u00e0i vi\u1ebft sau:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-bo-khoang-trong-thua-trong-excel.html\">C\u00f4ng th\u1ee9c b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba trong Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html\">X\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00e1c k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html\">L\u00e0m s\u1ea1ch d\u1eef li\u1ec7u trong Excel<\/a><\/li>\n<\/ul>\n<hr>\n<p>R\u1ea5t \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online \u0111\u00e3 cung c\u1ea5p nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n thi\u1ebft v\u1ec1 m\u1ed9t s\u1ed1 k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong Excel. H\u00e3y ti\u1ebfp t\u1ee5c t\u00ecm hi\u1ec3u \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9!<\/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-49.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9405,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9404","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\/9404","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=9404"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9404\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9405"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}