{"id":8837,"date":"2024-12-29T05:43:59","date_gmt":"2024-12-29T05:43:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/tach-so-tu-du-lieu-text-cho-truoc\/"},"modified":"2024-12-29T05:43:59","modified_gmt":"2024-12-29T05:43:59","slug":"tach-so-tu-du-lieu-text-cho-truoc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/tach-so-tu-du-lieu-text-cho-truoc\/","title":{"rendered":"T\u00e1ch s\u1ed1 t\u1eeb d\u1eef li\u1ec7u text cho tr\u01b0\u1edbc"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<hr>\n<p class=\"post-img\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32285\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201440%20760'%3E%3C\/svg%3E\" alt=\"Excel t\u00e1ch s\u1ed1 t\u1eeb d\u1eef li\u1ec7u cho tr\u01b0\u1edbc\" width=\"1440\" height=\"760\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc.png 1440w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc-600x317.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc-300x158.png 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc-1024x540.png 1024w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc-768x405.png 768w\" data-lazy-sizes=\"(max-width: 1440px) 100vw, 1440px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32285\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc.png\" alt=\"Excel t\u00e1ch s\u1ed1 t\u1eeb d\u1eef li\u1ec7u cho tr\u01b0\u1edbc\" width=\"1440\" height=\"760\" title=\"2015-11-21-excel-tach-so-tu-du-lieu-cho-truoc\"><\/a><\/p>\n<p>Ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u sau \u0111\u00e2y, d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o \u0111\u1ec3 t\u00e1ch ra \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u nh\u01b0 \u1edf c\u1ed9t B? C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 comment c\u00f4ng th\u1ee9c v\u00e0o ph\u1ea7n comment ph\u00eda d\u01b0\u1edbi b\u00e0i vi\u1ebft.<\/p>\n<blockquote>\n<p>\u0110\u1ebfn ng\u00e0y <strong>28\/11\/2015<\/strong> b\u00e0i vi\u1ebft n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c t\u1ed5ng k\u1ebft v\u1edbi nh\u1eefng c\u00f4ng th\u1ee9c c\u00e1c b\u1ea1n g\u1eedi v\u1ec1.<\/p>\n<\/blockquote>\n<p>V\u00e0 ng\u00e0y <strong>28\/11\/2015<\/strong> \u2013 m\u1ed9t ng\u00e0y \u0111\u1eb7c bi\u1ec7t \u0111\u00e3 \u0111\u1ebfn, sau \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch r\u1ea5t nhi\u1ec1u b\u1ea1n \u0111\u00e3 g\u1eedi v\u1ec1 cho <em><a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a><\/em>, c\u00e1c b\u1ea1n tham kh\u1ea3o th\u00eam \u0111\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c nh\u00e9 (T\u00ean t\u00e1c gi\u1ea3 \u0111\u01b0\u1ee3c vi\u1ebft t\u1eaft ch\u1eef c\u00e1i \u0111\u1ea7u \u0111\u1ec3 kh\u00f4ng l\u1ed9 danh t\u00ednh)<\/p>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>LH\r\n=TRIM(SUBSTITUTE(MID(A2,FIND(\"(\",A2)+1,2),CHAR(160),\"\"))\r\n=SUBSTITUTE(LEFT(RIGHT(A2,8),2),\"(\",\"\")\r\n=SUBSTITUTE(LEFT(MID(A2,FIND(\"(\",A2)+1,20),2),CHAR(160),\"\")\r\n=MID(MID(A2,FIND(\"(\",A2)+1,20),1,FIND(CHAR(160),MID(A2,FIND(\"(\",A2)+1,20))-1)\r\n=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,\"(\",REPT(\" \",20)),CHAR(160),REPT(\" \",20)),20,20))\r\n=LEFT(REPLACE(A2,1,FIND(\"(\",A2),\"\"),LEN(REPLACE(A2,1,FIND(\"(\",A2),\"\"))-6)\r\n=MID(A2,FIND(\"(\",A2)+1,FIND(CHAR(160),A2)-FIND(\"(\",A2)-1)\r\n\r\nCCC\r\n=VALUE(LEFT(RIGHT(A2;LEN(A2)-FIND(\"(\";A2));LEN(RIGHT(A2;LEN(A2)-FIND(\"(\";A2)))-6))\r\n=LEFT(RIGHT(A2;LEN(A2)-FIND(\"(\";A2));LEN(RIGHT(A2;LEN(A2)-FIND(\"(\";A2)))-6)\r\n\r\n\u0110K\r\n=VALUE(TRIM(MID(A2;FIND(\"(\";A2)+1;LEN(A2)-FIND(\"(\";A2)-6)))\r\n\r\n\u0110B\r\n=TRIM(MID(a2;SEARCH(\"(\";a2;1)+1;SEARCH(\")\";a2;1)-SEARCH(\"(\";a2;1)-5))\r\n\r\nKTB\r\n=MID(A2;SEARCH(\"(\";A2;1) +1;SEARCH(\" \";A2;1) - SEARCH(\"(\";A2;1) -1)\r\n\r\nHL\r\n\u00f4 B2: go\u0303 23, sau \u0111o\u0301 va\u0300o the\u0309 Data\/Flash Fill\r\n\r\nBTN\r\n=MID(A2,FIND(\"(\",A2)+1,LEN(A2)-FIND(\"(\",A2)-6)*1\r\n\r\nDQ\r\n=VALUE(IF(LEFT(RIGHT(A2,8),1)=\"(\",MID(RIGHT(A2,8),2,1),LEFT(RIGHT(A2,8),2)))\r\n\r\nTG\r\n=VALUE(SUBSTITUTE(REPLACE(A1;1;FIND(\"(\";A1);\"\");\" days)\";\"\"))\r\n\r\nSND\r\n=LEFT(RIGHT(A2;LEN(A2)-FIND(\"(\";A2));LEN(RIGHT(A2;LEN(A2)-FIND(\"(\";A2)))-6)\r\n=VALUE(SUBSTITUTE(MID(A2;FIND(\"(\";A2)+1;20);\" days)\";\"\"))\r\n\r\nV PT\r\nflash fill (t\u1eeb Excel 2013)\r\n\r\nT\u0110T\r\n=MID(A2;FIND(\"(\";A2)+1;LEN(A2)-FIND(\"day\";A2)-2)\r\n\r\nMT\r\n=MID(A2,FIND(\"(\",A2,1)+1,LEN(A2)-FIND(\"(\",A2,1)-6)\r\n\r\nTVV\r\n=VALUE(MID(A2,FIND(\"(\",A2)+1,LEN(A2)-FIND(\"(\",A2)-6))\r\n\r\nBKD\r\n=VALUE(MID(A3;1+FIND(\"(\";A3;1);LEN(A3)-6-FIND(\"(\";A3;1)))\r\n\r\nNNL\r\n=TRIM(MID(A2,FIND(\"(\",A2,1)+1,FIND(\")\",A2,1)-(FIND(\"(\",A2,1)+5)))\r\n<\/code><\/pre>\n<\/div>\n\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-6770e19dc9248\" 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-tu-du-lieu-text-cho-truoc.html#Download_file_excel_kem_theo_bai\" title=\"Download file excel k\u00e8m theo b\u00e0i\">Download file excel k\u00e8m theo b\u00e0i<\/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-tu-du-lieu-text-cho-truoc.html#Co_the_ban_cung_quan_tam\" title=\"C\u00f3 th\u1ec3 b\u1ea1n c\u0169ng quan t\u00e2m\">C\u00f3 th\u1ec3 b\u1ea1n c\u0169ng quan t\u00e2m<\/a>\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-3\" href=\"https:\/\/blog.hocexcel.online\/tach-tu-du-lieu-text-cho-truoc.html#Co_the_ban_se_quan_tam_den_nhung_bai_viet_sau\" title=\"C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau\">C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 id=\"download-file-excel-km-theo-bi\"><span class=\"ez-toc-section\" id=\"Download_file_excel_kem_theo_bai\"><\/span>Download file excel k\u00e8m theo b\u00e0i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/gofile.me\/5yKFU\/SV9YWb36k\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Download \u1edf link n\u00e0y<\/strong><\/a><\/p>\n<h2 id=\"c-th-bn-cng-quan-tm\"><span class=\"ez-toc-section\" id=\"Co_the_ban_cung_quan_tam\"><\/span>C\u00f3 th\u1ec3 b\u1ea1n c\u0169ng quan t\u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li><a href=\"https:\/\/blog.hocexcel.online\/2015\/11\/14\/trick-dieu-chinh-do-rong-cua-cot-bang-phim-tat.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t trong Excel b\u1eb1ng ph\u00edm t\u1eaft<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/2015\/11\/10\/excel-chen-them-nhieu-dong-trong-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Ch\u00e8n nhi\u1ec1u d\u00f2ng tr\u1ed1ng c\u00f9ng l\u00fac ch\u1ec9 d\u00f9ng ph\u00edm t\u1eaft<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/2015\/11\/08\/b69-tach-ten-ho-ten-dem-trong-excel-khong-dung-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>T\u00e1ch t\u00ean, h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m trong Excel kh\u00f4ng d\u00f9ng c\u00f4ng th\u1ee9c?<\/strong><\/a><\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Co_the_ban_se_quan_tam_den_nhung_bai_viet_sau\"><\/span>C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li><a title=\"Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel, c\u00e1ch thi\u1ebft l\u1eadp d\u1eef li\u1ec7u\" href=\"https:\/\/blog.hocexcel.online\/2016\/06\/02\/bieu-do-dong-trong-excel.html\">Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel, c\u00e1ch thi\u1ebft l\u1eadp d\u1eef li\u1ec7u<\/a><\/li>\n<li><a title=\"\u0110\u0129a DVD Excel C\u01a1 b\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/31\/tai-lieu-excel-dvd-excel.html\">\u0110\u0129a DVD Excel C\u01a1 b\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p<\/a><\/li>\n<li><a title=\"\u0110i\u1ec1u khi\u1ec3n Word t\u1eeb Excel - thay cho Mail Merge\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/27\/dieu-khien-word-tu-excel.html\">\u0110i\u1ec1u khi\u1ec3n Word t\u1eeb Excel \u2013 thay cho Mail Merge<\/a><\/li>\n<li><a title=\"#89 S\u1eed d\u1ee5ng SUMIF v\u1edbi d\u1ea5u * v\u00e0 ? \u0111\u1ec3 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n \" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/23\/su-dung-sumif-voi-dieu-kien.html\">#89 S\u1eed d\u1ee5ng SUMIF v\u1edbi d\u1ea5u * v\u00e0 ? \u0111\u1ec3 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li><a title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Goal Seek trong Excel\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/23\/su-dung-goal-seek.html\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Goal Seek trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ol>\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":"<p>Ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u sau \u0111\u00e2y, d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o \u0111\u1ec3 t\u00e1ch ra \u0111\u01b0\u1ee3c..<\/p>\n","protected":false},"author":1,"featured_media":8838,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8837","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8837","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=8837"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8837\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8838"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}