{"id":2413,"date":"2024-12-02T07:40:45","date_gmt":"2024-12-02T07:40:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tach-ho-va-ten-tu-danh-sach-trong-excel-2007-2010-2013-2016\/"},"modified":"2024-12-02T07:40:45","modified_gmt":"2024-12-02T07:40:45","slug":"cach-tach-ho-va-ten-tu-danh-sach-trong-excel-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tach-ho-va-ten-tu-danh-sach-trong-excel-2007-2010-2013-2016\/","title":{"rendered":"C\u00e1ch t\u00e1ch h\u1ecd v\u00e0 t\u00ean t\u1eeb danh s\u00e1ch trong Excel 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>T\u00e1ch h\u1ecd v\u00e0 t\u00ean tr\u00ean excel l\u00e0 v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p nh\u1ea5t c\u1ee7a d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu l\u00e0m theo ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng th\u00ec s\u1ebd m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian. Do \u0111\u00f3, \u00a0\u0111\u1ec3 t\u00e1ch h\u1ecd v\u00e0 t\u00ean tr\u00ean excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng\u00a0m\u00ecnh xin \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch d\u01b0\u1edbi \u0111\u00e2y.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ch\u1eb3ng h\u1ea1n,\u00a0b\u1ea1n c\u1ea7n ph\u1ea3i t\u00e1ch h\u1ecd v\u00e0 t\u00ean c\u1ee7a m\u1ed9t danh s\u00e1ch g\u1ed3m 3 \u00a0ng\u01b0\u1eddi sau:<\/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-674d647c491ad\" 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\/cach-tach-ho-va-ten-tu-danh-sach-trong-excel-2007-2010-2013-2016.html#Tach_ten\" title=\"T\u00e1ch t\u00ean\">T\u00e1ch t\u00ean<\/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\/cach-tach-ho-va-ten-tu-danh-sach-trong-excel-2007-2010-2013-2016.html#Tach_ho\" title=\"T\u00e1ch h\u1ecd\">T\u00e1ch h\u1ecd<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tach_ten\"><\/span><strong>T\u00e1ch t\u00ean<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3161 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-18.png\" width=\"600\" height=\"383\" title=\"1-18\"><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3:<\/p>\n<ul>\n<li>Copy \u00a0n\u1ed9i dung t\u1eeb c\u1ed9t H\u1ecc V\u00c0 T\u00caN sang c\u1ed9t T\u00caN.<\/li>\n<li>Khoanh v\u00f9ng c\u00e1c t\u00ean c\u1ea7n t\u00e1ch h\u1ecd v\u00e0 t\u00ean \u1edf c\u1ed9t T\u00caN<\/li>\n<li>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf<\/li>\n<li>\u1ede h\u1ed9p tho\u1ea1i <strong>Find what<\/strong> trong c\u1eeda s\u1ed5 <strong>Replace<\/strong>, h\u00e3y nh\u1eadp: \u201c<strong>*<\/strong> \u201d (d\u1ea5u sao v\u00e0 kho\u1ea3ng tr\u1eafng).\u00a0Ch\u1ecdn <strong>Replace All<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3162 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-19.png\" width=\"600\" height=\"575\" title=\"1-19\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3163 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-20.png\" width=\"600\" height=\"559\" title=\"1-20\"><\/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\/2024\/12\/ex101_92019-nho-186.gif\" title=\"ex101_92019-nho-186\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tach_ho\"><\/span><strong>T\u00e1ch h\u1ecd<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Tr\u1ecf chu\u1ed9t qua c\u1ed9t\u00a0<strong>H\u1ecc<\/strong><\/li>\n<li>Nh\u1eadp c\u00f4ng th\u1ee9c sau: <strong>=LEFT(A2,LEN(A2)-LEN(C2))<\/strong><\/li>\n<li>Copy xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3165 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-ten.png\" width=\"600\" height=\"396\" title=\"tach-ten\"><\/p>\n<p>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3167 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-copy.png\" width=\"600\" height=\"411\" title=\"1-copy\"><\/p>\n<p>\u00a0<\/p>\n<p>V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 ngay m\u1ed9t danh s\u00e1ch h\u1ecd ri\u00eang, t\u00ean ri\u00eang ho\u00e0n ch\u1ec9nh b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p c\u1ef1c k\u00ec \u0111\u01a1n gi\u1ea3n. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i video \u0111\u1ec3 r\u00f5 h\u01a1n t\u1eebng b\u01b0\u1edbc l\u00e0m:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/5JPyFclFYic\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p><a href=\"https:\/\/www.hocexcel.online\/ex101\">https:\/\/www.hocexcel.online\/ex101<\/a><\/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\/2024\/12\/ex101_92019-nho-186.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2413","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\/2413","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=2413"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2414"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}