{"id":12637,"date":"2025-01-15T10:38:14","date_gmt":"2025-01-15T10:38:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc\/"},"modified":"2025-01-15T10:38:14","modified_gmt":"2025-01-15T10:38:14","slug":"tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc\/","title":{"rendered":"T\u00e1ch h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m trong Excel kh\u00f4ng d\u00f9ng c\u00f4ng th\u1ee9c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>d\u00f9ng \u0111\u1ec3 <strong>t\u00e1ch h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m trong Excel<\/strong> m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c. \u0110\u00e2y l\u00e0 ki\u1ebfn th\u1ee9c \u0111\u01a1n gi\u1ea3n gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng x\u1eed l\u00fd d\u1eef li\u1ec7u khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh<\/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-678790140662d\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html#Buoc_1\" title=\"B\u01b0\u1edbc 1\">B\u01b0\u1edbc 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html#Buoc_2\" title=\"B\u01b0\u1edbc 2\">B\u01b0\u1edbc 2<\/a><\/li>\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\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html#Buoc_3\" title=\"B\u01b0\u1edbc 3\">B\u01b0\u1edbc 3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html#Buoc_4\" title=\"B\u01b0\u1edbc 4\">B\u01b0\u1edbc 4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tach-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html#Buoc_5\" title=\"B\u01b0\u1edbc 5\">B\u01b0\u1edbc 5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 id=\"bc-1\"><span class=\"ez-toc-section\" id=\"Buoc_1\"><\/span>B\u01b0\u1edbc 1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 b\u00e0i s\u1ed169 trong lo\u1ea1t videos <a href=\"https:\/\/www.youtube.com\/playlist?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz\"><strong>H\u01b0\u1edbng d\u1eabn Excel t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p<\/strong><\/a><\/p>\n<p>Copy t\u00ean t\u1eeb <code class=\"highlighter-rouge\">A2:A7<\/code> sang <code class=\"highlighter-rouge\">B2:B7<\/code> v\u00e0 <code class=\"highlighter-rouge\">C2:C7<\/code><\/p>\n<p style=\"text-align: center\"><\/p>\n<h2 id=\"bc-2\"><span class=\"ez-toc-section\" id=\"Buoc_2\"><\/span>B\u01b0\u1edbc 2<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>B\u00f4i \u0111en c\u1ed9t t\u00ean t\u1eeb <code class=\"highlighter-rouge\">B2:B7<\/code><\/li>\n<li>B\u1ea5m ph\u00edm t\u1eaft <code class=\"highlighter-rouge\">CTRL + H<\/code>. Trong h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>, m\u1ee5c <strong>Find What<\/strong> : \u0111\u00e1nh 1 k\u00ed t\u1ef1 d\u1ea5u sao v\u00e0 1 k\u00ed t\u1ef1 d\u00e2u c\u00e1ch <code class=\"highlighter-rouge\">* <\/code>r\u1ed3i b\u1ea5m ph\u00edm<strong>Replace All<\/strong>. Th\u1ebf l\u00e0 t\u00e1ch xong t\u00ean<\/li>\n<\/ul>\n<p><strong>D\u00e0nh cho ai th\u00edch hi\u1ec3u <code class=\"highlighter-rouge\">* <\/code><\/strong>: \u1edf \u0111\u00e2y, d\u1ea5u <code class=\"highlighter-rouge\">*<\/code> \u0111\u1ea1i di\u1ec7n cho b\u1ea5t c\u1ee9 k\u00ed t\u1ef1 n\u00e0o, d\u1ea5u ` ` (d\u1ea5u c\u00e1ch) t\u1ea5t nhi\u00ean l\u00e0 \u0111\u1ea1i di\u1ec7n cho k\u00ed t\u1ef1 d\u1ea5u c\u00e1ch. \u0110i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm <code class=\"highlighter-rouge\">* <\/code>ngh\u0129a l\u00e0 <strong>t\u00ecm t\u1ea5t c\u1ea3 c\u00e1c k\u00ed t\u1ef1 ph\u00eda tr\u01b0\u1edbc d\u1ea5u c\u00e1ch<\/strong>. N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta \u201cs\u1ea1ch s\u1ebd\u201d, kh\u00f4ng c\u00f3 d\u1ea5u c\u00e1ch n\u00e0o \u1edf cu\u1ed1i th\u00ec c\u00e1ch n\u00e0y ho\u1ea1t \u0111\u1ed9ng \u1ed5n c\u1ea3 kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1 g\u00ec. N\u1ebfu b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1ch n\u00e0y m\u00e0 kh\u00f4ng th\u1ea5y k\u1ebft qu\u1ea3 \u0111\u01b0a l\u1ea1i g\u00ec th\u00ec nhi\u1ec1u kh\u1ea3 n\u0103ng \u0111\u1eb1ng sau <strong>t\u00ean \u0111\u1ea7y \u0111\u1ee7<\/strong> \u0111\u00e3 c\u00f3 k\u00ed t\u1ef1 ` ` \u2013 d\u1ea5u c\u00e1ch. \u0110\u1ec3 lo\u1ea1i b\u1ecf k\u00ed t\u1ef1 d\u1ea5u c\u00e1ch \u1edf 2 \u0111\u1ea7u m\u1ed9t chu\u1ed7i, ta d\u00f9ng h\u00e0m <strong><code class=\"highlighter-rouge\">TRIM()<\/code><\/strong><\/p>\n<h2 id=\"bc-3\"><span class=\"ez-toc-section\" id=\"Buoc_3\"><\/span>B\u01b0\u1edbc 3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>B\u00f4i \u0111en c\u1ed9t h\u1ecd t\u1eeb <code class=\"highlighter-rouge\">C2:C7<\/code><\/li>\n<li>B\u1ea5m ph\u00edm t\u1eaft <code class=\"highlighter-rouge\">CTRL + H<\/code>. Trong h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>, m\u1ee5c <strong>Find What<\/strong> : \u0111\u00e1nh 1 k\u00ed t\u1ef1 d\u1ea5u c\u00e1ch v\u00e0 1 k\u00ed t\u1ef1 d\u00e2u sao ` *` r\u1ed3i b\u1ea5m ph\u00edm<strong>Replace All<\/strong>. Th\u1ebf l\u00e0 t\u00e1ch xong h\u1ecd<\/li>\n<\/ul>\n<h2 id=\"bc-4\"><span class=\"ez-toc-section\" id=\"Buoc_4\"><\/span>B\u01b0\u1edbc 4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>D\u00f9ng c\u00f4ng th\u1ee9c sau \u1edf <code class=\"highlighter-rouge\">D2<\/code> \u0111\u1ec3 t\u00e1ch ra <strong>H\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m<\/strong><\/li>\n<\/ul>\n<p><code class=\"highlighter-rouge\">=LEFT(A2,LEN(A2)-LEN(B2)-1)<\/code><\/p>\n<p>Ph\u1ea7n <code class=\"highlighter-rouge\">-1<\/code> \u1edf trong c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec3 lo\u1ea1i b\u1ecf 1 k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng sau chu\u1ed7i <strong>h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m<\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-81.gif\" title=\"vba101_92019-nho-81\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-417.gif\" title=\"ex101_92019-nho-417\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>Mu\u1ed1n th\u1eed ngay c\u00f4ng th\u1ee9c tr\u00ean?<\/strong> H\u00e3y \u0111i \u0111\u1ebfn \u00f4 <code class=\"highlighter-rouge\">D2<\/code> c\u1ee7a <code class=\"highlighter-rouge\">Sheet2<\/code> trong b\u1ea3ng t\u00ednh Excel \u1edf <strong>B\u01b0\u1edbc 1<\/strong>! N\u1ebfu c\u00f4ng th\u1ee9c l\u1ed7i, d\u1ea5u <code class=\"highlighter-rouge\">,<\/code> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thay b\u1eb1ng d\u1ea5u <code class=\"highlighter-rouge\">;<\/code> trong c\u00f4ng th\u1ee9c tr\u00ean.<\/p>\n<h2 id=\"bc-5\"><span class=\"ez-toc-section\" id=\"Buoc_5\"><\/span>B\u01b0\u1edbc 5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Theo d\u00f5i video v\u00e0 chia s\u1ebb n\u1ebfu th\u1ea5y c\u00f3 \u00edch!<\/strong><\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/5JPyFclFYic?wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<div class=\"videowrapper\" style=\"text-align: left\"><strong>Xem th\u00eam:<\/strong><\/div>\n<ul>\n<li class=\"videowrapper\" style=\"text-align: left\">T\u1ed5ng h\u1ee3p c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">h\u00e0m trong Excel<\/a><\/li>\n<li class=\"videowrapper\" style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel 2016 <\/a><\/li>\n<\/ul>\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-81.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12637","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\/12637","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=12637"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12638"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}