{"id":41856,"date":"2022-04-12T13:39:32","date_gmt":"2022-04-12T06:39:32","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=41856"},"modified":"2022-04-12T13:39:32","modified_gmt":"2022-04-12T06:39:32","slug":"top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/","title":{"rendered":"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9!<\/strong><\/p>\n<p>Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0 b\u1ea1n tr\u00ecnh b\u00e0y tr\u1edf n\u00ean tr\u1ef1c quan v\u00e0 r\u00f5 r\u00e0ng h\u01a1n. Trong \u0111\u00f3, d\u1eef li\u1ec7u \u1edf d\u1ea1ng h\u1ecd t\u00ean \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong b\u1ea3ng s\u1ebd d\u1ec5 quan s\u00e1t h\u01a1n n\u1ebfu \u0111\u01b0\u1ee3c t\u00e1ch ri\u00eang th\u00e0nh c\u1ed9t h\u1ecd v\u00e0 c\u1ed9t t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 Divine Shop \u0111\u00e3 t\u1ed5ng h\u1ee3p \u0111\u1ec3 chia \u0111\u1ebfn b\u1ea1n!<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532796 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d0301112.jpeg\" alt=\"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua \" width=\"1201\" height=\"740\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Cach_tach_ten_trong_Excel_bang_hop_thoai_Find_and_Replace\"><\/span><span id=\"Cach_tach_ten_trong_Excel_bang_hop_thoai_Find_and_Replace\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><strong>C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u1ed9p tho\u1ea1i Find and Replace<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tach_ho\"><\/span><span id=\"Tach_ho\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><strong>T\u00e1ch h\u1ecd<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>L\u01b0u \u00fd:<\/strong> B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>, b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 t\u00e1ch ri\u00eang h\u1ecd nh\u01b0ng kh\u00f4ng bao g\u1ed3m t\u00ean \u0111\u1ec7m.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n copy c\u1ed9t <strong>H\u1ecd v\u00e0 T\u00ean<\/strong> sang c\u1ed9t b\u00ean c\u1ea1nh v\u00e0 \u0111\u1eb7t t\u00ean c\u1ed9t l\u00e0 <strong>H\u1ecd<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532769 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d0490489.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u1ed9p tho\u1ea1i Find and Replace - t\u00e1ch h\u1ecd b\u01b0\u1edbc 1\" width=\"1920\" height=\"1015\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea1n nh\u1ea5n t\u1ed5 h\u1ee3p <strong>Ctrl + H<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p>T\u1ea1i \u00f4 tr\u1eafng <strong>Find what<\/strong>, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp nh\u01b0 sau: <strong>Space (kho\u1ea3ng tr\u1eafng) v\u00e0 * (Shift + 8)<\/strong> r\u1ed3i ch\u1ecdn <strong>Replace All.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532770 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d06f0c22.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u1ed9p tho\u1ea1i Find and Replace - t\u00e1ch h\u1ecd b\u01b0\u1edbc 2\" width=\"1920\" height=\"1018\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tach_ten\"><\/span><span id=\"Tach_ten\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">T\u00e1ch t\u00ean<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n copy c\u1ed9t <strong>H\u1ecd v\u00e0 T\u00ean<\/strong> sang b\u00ean c\u1ea1nh c\u1ed9t H\u1ecd v\u00e0 \u0111\u1eb7t t\u00ean c\u1ed9t l\u00e0 <strong>T\u00ean<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532771 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d09197ce.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u1ed9p tho\u1ea1i Find and Replace - t\u00e1ch t\u00ean b\u01b0\u1edbc 1\" width=\"1920\" height=\"988\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea1n nh\u1ea5n t\u1ed5 h\u1ee3p <strong>Ctrl + H<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p>T\u1ea1i \u00f4 tr\u1eafng <strong>Find what<\/strong>, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp nh\u01b0 sau: <strong>* (Shift + 8) v\u00e0 Space (kho\u1ea3ng tr\u1eafng)<\/strong> r\u1ed3i ch\u1ecdn <strong>Replace All<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532772 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d0b4795e.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u1ed9p tho\u1ea1i Find and Replace - t\u00e1ch t\u00ean b\u01b0\u1edbc 2\" width=\"1920\" height=\"1018\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tach_ten_trong_Excel_bang_ham_ket_hop\"><\/span><span id=\"Cach_tach_ten_trong_Excel_bang_ham_ket_hop\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><strong>C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u00e0m k\u1ebft h\u1ee3p<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tach_ten-2\"><\/span><span id=\"Tach_ten-2\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><strong>T\u00e1ch t\u00ean<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u1ede c\u00e1ch n\u00e0y, b\u1ea1n s\u1ebd ti\u1ebfn h\u00e0nh k\u1ebft h\u1ee3p 3 d\u1ea1ng h\u00e0m sau \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00e1ch \u0111\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean:<\/p>\n<ul>\n<li>H\u00e0m <strong>RIGHT<\/strong>: l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i.<\/li>\n<li>H\u00e0m <strong>LEN<\/strong>: l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1.<\/li>\n<li>H\u00e0m <strong>SUBSTITUTE<\/strong> l\u00e0 h\u00e0m gi\u00fap thay th\u1ebf chu\u1ed7i v\u0103n b\u1ea3n c\u0169 th\u00e0nh chu\u1ed7i v\u0103n b\u1ea3n m\u1edbi.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n nh\u1eadp v\u00e0o c\u1ed9t t\u00ean (t\u1ee9c c\u1ed9t <strong>C2<\/strong>) h\u00e0m sau:<\/p>\n<p><strong>=RIGHT(A2,LEN(A2)-FIND(\u201c@\u201d,SUBSTITUTE(A2,\u201d \u201c,\u201d@\u201d,LEN(A2)-LEN(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d)))))<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532774 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d0d76c54.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u00e0m k\u1ebft h\u1ee3p - t\u00e1ch t\u00ean b\u01b0\u1edbc 1\" width=\"1920\" height=\"1020\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau khi k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c hi\u1ec7n \u1edf \u00f4 <strong>C2<\/strong>, b\u1ea1n k\u00e9o h\u00ecnh d\u1ea5u c\u1ed9ng \u1edf g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi \u00f4 n\u00e0y \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00e1ch h\u1ecd cho c\u00e1c \u00f4 k\u1ebf ti\u1ebfp.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532775 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d0f750f3.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u00e0m k\u1ebft h\u1ee3p - t\u00e1ch t\u00ean b\u01b0\u1edbc 2\" width=\"1920\" height=\"1021\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tach_ho-2\"><\/span><span id=\"Tach_ho-2\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><strong>T\u00e1ch h\u1ecd<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00e1ch h\u1ecd, b\u1ea1n ch\u1ec9 c\u1ea7n k\u1ebft h\u1ee3p 2 h\u00e0m ch\u00ednh \u0111\u00f3 l\u00e0:<\/p>\n<ul>\n<li>H\u00e0m <strong>LEFT<\/strong>: l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i.<\/li>\n<li>H\u00e0m <strong>LEN<\/strong> l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n nh\u1eadp v\u00e0o c\u1ed9t h\u1ecd (t\u1ee9c c\u1ed9t <strong>B2<\/strong>) h\u00e0m sau:<\/p>\n<p><strong>=LEFT(A2,LEN(A2)-LEN(C2))<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532776 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d1150044.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u00e0m k\u1ebft h\u1ee3p - t\u00e1ch h\u1ecd b\u01b0\u1edbc 1\" width=\"1920\" height=\"1021\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau khi k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c hi\u1ec7n \u1edf \u00f4 <strong>B2<\/strong>, b\u1ea1n k\u00e9o h\u00ecnh d\u1ea5u c\u1ed9ng \u1edf g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi \u00f4 n\u00e0y \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00e1ch t\u00ean cho c\u00e1c \u00f4 k\u1ebf ti\u1ebfp.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532777 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d13bcf85.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng h\u00e0m k\u1ebft h\u1ee3p - t\u00e1ch h\u1ecd b\u01b0\u1edbc 2\" width=\"1920\" height=\"1023\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tach_ten_trong_Excel_bang_cong_cu_Text_to_Columns\"><\/span><span id=\"Cach_tach_ten_trong_Excel_bang_cong_cu_Text_to_Columns\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><strong>C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Text to Columns<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> B\u1ea1n b\u00f4i \u0111en c\u1ed9t <strong>H\u1ecd v\u00e0 T\u00ean<\/strong> c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u m\u00e0 m\u00ecnh mu\u1ed1n t\u00e1ch.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532779 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d162ccc9.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Text to Columns - b\u01b0\u1edbc 1\" width=\"1920\" height=\"1023\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn c\u00f4ng c\u1ee5 <strong>Text to Columns<\/strong> t\u1ea1i th\u1ebb <strong>Data<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532780 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d1865e31.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Text to Columns - b\u01b0\u1edbc 2\" width=\"1920\" height=\"1021\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Sau khi h\u1ed9p tho\u1ea1i \u0111\u01b0\u1ee3c m\u1edf ra, b\u1ea1n ch\u1ecdn <strong>Delimited<\/strong> v\u00e0 nh\u1ea5n <strong>Next<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532781 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d1a7b1a9.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Text to Columns - b\u01b0\u1edbc 3\" width=\"1920\" height=\"1023\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Trong <strong>Delimiters<\/strong>, b\u1ea1n ch\u1ecdn <strong>Space<\/strong> v\u00e0 nh\u1ea5n <strong>Next<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"wp-image-532788 size-full aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d1cf0f05.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Text to Columns - b\u01b0\u1edbc 4\" width=\"1920\" height=\"1024\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> T\u1ea1i h\u1ed9p tho\u1ea1i cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ecdn <strong>Text<\/strong> v\u00e0 nh\u1eadp \u00f4 s\u1ebd ch\u1ee9a d\u1eef li\u1ec7u sau khi t\u00e1ch t\u1ea1i \u00f4 tr\u1ed1ng <strong>Destination<\/strong> r\u1ed3i nh\u1ea5n <strong>Finish<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"wp-image-532782 size-full aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d1ef3e99.jpeg\" alt=\"C\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Text to Columns - b\u01b0\u1edbc 3\" width=\"1920\" height=\"1017\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tach_ho_bang_tinh_nang_Flash_Fill\"><\/span><span id=\"Cach_tach_ho_bang_tinh_nang_Flash_Fill\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><strong>C\u00e1ch t\u00e1ch h\u1ecd b\u1eb1ng t\u00ednh n\u0103ng Flash Fill<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi t\u00ednh n\u0103ng n\u00e0y, b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 t\u00e1ch \u0111\u01b0\u1ee3c h\u1ecd v\u1edbi c\u00e1c thao t\u00e1c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1i c\u1ed9t <strong>H\u1ecd<\/strong>, b\u1ea1n ti\u1ebfn h\u00e0nh g\u00f5 h\u1ecd t\u1ea1i 2 d\u00f2ng \u0111\u1ea7u ti\u00ean.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532789 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d211c665.jpeg\" alt=\"C\u00e1ch t\u00e1ch h\u1ecd b\u1eb1ng t\u00ednh n\u0103ng Flash Fill - b\u01b0\u1edbc 1\" width=\"1920\" height=\"1021\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea1n s\u1ebd th\u1ea5y b\u00ean d\u01b0\u1edbi 2 d\u00f2ng n\u00e0y c\u00f3 xu\u1ea5t hi\u1ec7n m\u1ed9t d\u00e3y h\u1ecd t\u01b0\u01a1ng \u1ee9ng v\u1edbi h\u1ecd trong c\u1ed9t <strong>H<\/strong><strong>\u1ecd v\u00e0 T\u00ean<\/strong>, sau khi ki\u1ec3m tra xem \u0111\u00e3 ch\u00ednh x\u00e1c hay ch\u01b0a, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n <strong>Enter<\/strong> l\u00e0 \u0111\u00e3 t\u00e1ch h\u1ecd th\u00e0nh c\u00f4ng r\u1ed3i.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-532791 aligncenter\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d2434cfb.jpeg\" alt=\"C\u00e1ch t\u00e1ch h\u1ecd b\u1eb1ng t\u00ednh n\u0103ng Flash Fill - b\u01b0\u1edbc 2\" width=\"1920\" height=\"1021\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><strong>T\u1ea1m k\u1ebft<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft t\u1ed5ng h\u1ee3p 3 c\u00e1ch t\u00e1ch h\u1ecd v\u00e0 t\u00ean trong Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n m\u00e0 Divine Shop mu\u1ed1n chia s\u1ebb \u0111\u1ebfn b\u1ea1n. N\u1ebfu c\u00f3 b\u1ea5t k\u00ec th\u1eafc m\u1eafc n\u00e0o, \u0111\u1eebng ng\u1ea7n ng\u1ea1i \u0111\u1ec3 l\u1ea1i c\u00e2u h\u1ecfi b\u00ean d\u01b0\u1edbi ph\u1ea7n b\u00ecnh lu\u1eadn nh\u00e9!<\/p>\n<p><strong><em>\u00a0<\/em><\/strong><\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?q=windows\" href=\"https:\/\/divineshop.vn\/search?q=windows\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?q=windows noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png\" alt=\"\" class=\"wp-image-256838\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=h%E1%BB%8Dc+t%E1%BA%ADp\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png\" alt=\"\" class=\"wp-image-285219\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<div class=\"wp-container-69d1d629c1725 wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0 b\u1ea1n tr\u00ecnh b\u00e0y tr\u1edf n\u00ean tr\u1ef1c quan v\u00e0 r\u00f5 r\u00e0ng h\u01a1n. Trong \u0111\u00f3, d\u1eef li\u1ec7u \u1edf d\u1ea1ng h\u1ecd t\u00ean \u0111\u01b0\u1ee3c li\u1ec7t [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":41857,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[255],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua\" \/>\n<meta property=\"og:description\" content=\"M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T06:39:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg\",\"width\":1600,\"height\":900},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/\",\"name\":\"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#primaryimage\"},\"datePublished\":\"2022-04-12T06:39:32+00:00\",\"dateModified\":\"2022-04-12T06:39:32+00:00\",\"description\":\"M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua\",\"datePublished\":\"2022-04-12T06:39:32+00:00\",\"dateModified\":\"2022-04-12T06:39:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#webpage\"},\"wordCount\":1042,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg\",\"keywords\":[\"Th\u1ee7 thu\u1eadt Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/","og_locale":"vi_VN","og_type":"article","og_title":"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua","og_description":"M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0","og_url":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T06:39:32+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg","width":1600,"height":900},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/","name":"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#primaryimage"},"datePublished":"2022-04-12T06:39:32+00:00","dateModified":"2022-04-12T06:39:32+00:00","description":"M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9! Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t h\u1eefu \u00edch gi\u00fap cho d\u1eef li\u1ec7u m\u00e0","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"Top 3 c\u00e1ch t\u00e1ch t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua","datePublished":"2022-04-12T06:39:32+00:00","dateModified":"2022-04-12T06:39:32+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#webpage"},"wordCount":1042,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/top-3-cach-tach-ten-trong-excel-don-gian-ma-ban-khong-nen-bo-qua_623d3d00df977.jpeg","keywords":["Th\u1ee7 thu\u1eadt Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/41856"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=41856"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/41856\/revisions"}],"predecessor-version":[{"id":71855,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/41856\/revisions\/71855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/41857"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=41856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=41856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=41856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}