{"id":12445,"date":"2025-01-15T08:43:46","date_gmt":"2025-01-15T08:43:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tach-so-dien-thoai-tach-email-dinh-dang-ngay-thang-bang-flashfill\/"},"modified":"2025-01-15T08:43:46","modified_gmt":"2025-01-15T08:43:46","slug":"tach-so-dien-thoai-tach-email-dinh-dang-ngay-thang-bang-flashfill","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tach-so-dien-thoai-tach-email-dinh-dang-ngay-thang-bang-flashfill\/","title":{"rendered":"T\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, t\u00e1ch email, \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng b\u1eb1ng Flashfill"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Flashfill l\u00e0 1 c\u00f4ng c\u1ee5 c\u1ef1c k\u00ec h\u1eefu d\u1ee5ng m\u00e0 nh\u1eefng ng\u01b0\u1eddi d\u00f9ng Excel 2013 tr\u1edf v\u1ec1 sau \u0111\u1ec1u c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 tr\u00e1nh xa kh\u1ecfi nh\u1eefng c\u00f4ng th\u1ee9c x\u1eed l\u00fd chu\u1ed7i ph\u1ee9c t\u1ea1p g\u00e2y \u0111au \u0111\u1ea7u ch\u00f3ng m\u1eb7t. C\u00e1ch s\u1eed d\u1ee5ng Flashfill c\u1ef1c k\u00ec \u0111\u01a1n gi\u1ea3n: ch\u1ec9 c\u1ea7n g\u00f5 k\u1ebft qu\u1ea3 \u0111\u1ea7u ra nh\u01b0 b\u1ea1n mu\u1ed1n, sau \u0111\u00f3 Flashfill s\u1ebd \u201ch\u1ecdc\u201d t\u1eeb nh\u1eefng d\u1eef li\u1ec7u b\u1ea1n nh\u1eadp v\u00e0o v\u00e0 t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng cho nh\u1eefng d\u1eef li\u1ec7u sau \u0111\u00f3. Ph\u00edm t\u1eaft \u0111\u1ec3 s\u1eed d\u1ee5ng Flashfill trong Excel l\u00e0 <strong>CTRL + E<\/strong>. Video sau \u0111\u00e2y tr\u00ecnh b\u00e0y c\u00e1ch \u00e1p d\u1ee5ng Flashfill v\u00e0o 1 s\u1ed1 ki\u1ec3u d\u1eef li\u1ec7u:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/2U_NTu4kbzg\" 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":"<p>Flashfill l\u00e0 1 c\u00f4ng c\u1ee5 c\u1ef1c k\u00ec h\u1eefu d\u1ee5ng m\u00e0 nh\u1eefng ng\u01b0\u1eddi d\u00f9ng Excel 2013..<\/p>\n","protected":false},"author":1,"featured_media":12446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12445","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\/12445","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=12445"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12445\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12446"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}