{"id":3212,"date":"2024-12-03T01:26:14","date_gmt":"2024-12-03T01:26:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/tach-gmail-so-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online\/"},"modified":"2024-12-03T01:26:14","modified_gmt":"2024-12-03T01:26:14","slug":"tach-gmail-so-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/tach-gmail-so-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online\/","title":{"rendered":"T\u00e1ch Gmail, S\u1ed1, Ch\u1eef ra kh\u1ecfi chu\u1ed7i s\u1eed d\u1ee5ng Add ins HocExcel Online"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Khi b\u1ea1n ch\u1ecdn m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n(text) b\u1ea3o g\u1ed3m c\u1ea3 ch\u1eef, s\u1ed1 v\u00e0 Gmail b\u1ea1n c\u1ea7n t\u00e1ch n\u00f3 ra, Trong khi \u0111\u00f3 b\u1ea1n l\u1ea1i kh\u00f4ng r\u00e0nh v\u1ec1 VBA b\u1ea1n ph\u1ea3i l\u00e0m sao nh\u1ec9. \u0110\u1eebng lo l\u1eafng v\u00ec trong b\u00e0i vi\u1ebft n\u00e0y\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/\">HocExcelOnline<\/a>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 th\u00f4i.<\/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-674e5e35754cb\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tach-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tach-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html#Ham_dung_de_Tach_chuoi_ky_tu_gmail\" title=\"H\u00e0m d\u00f9ng \u0111\u1ec3 T\u00e1ch chu\u1ed7i, k\u00fd t\u1ef1, gmail\">H\u00e0m d\u00f9ng \u0111\u1ec3 T\u00e1ch chu\u1ed7i, k\u00fd t\u1ef1, gmail<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tach-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html#_1Ham_HeoRegex\" title=\"\u00a01.H\u00e0m\u00a0HeoRegex\">\u00a01.H\u00e0m\u00a0HeoRegex<\/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-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html#2Ham_HeoRegexArr\" title=\"2.H\u00e0m\u00a0HeoRegexArr\">2.H\u00e0m\u00a0HeoRegexArr<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tach-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html#Cach_su_dung\" title=\"C\u00e1ch s\u1eed d\u1ee5ng\">C\u00e1ch s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tach-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>B\u00e0i vi\u1ebft n\u00e0y\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/\">HocExcelOnline<\/a>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng Add ins HocExcel Online v\u00e0 Regular Expression \u0111\u1ec3 b\u1eaft m\u1ed7i chu\u1ed7i b\u1ea5t k\u1ef3 theo quy lu\u1eadt \u0111\u1ec3 t\u00e1ch ra theo y\u00eau c\u1ea7u tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n c\u00e0i<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"> Add ins HocExcel Online\u00a0t\u1ea1i \u0111\u00e2y nh\u00e9<\/a>(N\u1ebfu ai \u0111\u00e3 c\u00f3 Add ins HocExcel Online c\u00f3 th\u1ec3 b\u1ecf qua b\u01b0\u1edbc n\u00e0y)<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ham_dung_de_Tach_chuoi_ky_tu_gmail\"><\/span>H\u00e0m d\u00f9ng \u0111\u1ec3 T\u00e1ch chu\u1ed7i, k\u00fd t\u1ef1, gmail<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"_1Ham_HeoRegex\"><\/span>\u00a01.<span style=\"font-size: 18pt\">H\u00e0m\u00a0HeoRegex<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<\/strong><\/p>\n<blockquote>\n<p><strong>=HeoRegex(Nh\u1eadp chu\u1ed7i *,Nh\u1eadp chu\u1ed7i Regular Expression * )<\/strong><\/p>\n<\/blockquote>\n<p><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<\/strong><\/p>\n<ul>\n<li><strong>Nh\u1eadp chu\u1ed7i *: L\u00e0 \u00f4 b\u1ea1n mu\u1ed1n t\u00e1ch<\/strong><\/li>\n<li><strong>Nh\u1eadp chu\u1ed7i Regular Expression\u00a0*: L\u00e0\u00a0Matching c\u1ee7a Regular Expression\u00a0<\/strong><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"2Ham_HeoRegexArr\"><\/span><strong>2.H\u00e0m\u00a0HeoRegexArr<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<\/strong><\/p>\n<blockquote>\n<p><strong>=HeoRegexArr(Nh\u1eadp m\u1ea3ng *,Nh\u1eadp chu\u1ed7i Regular Expression *,[T\u00f9y ch\u1ecdn])<\/strong><\/p>\n<\/blockquote>\n<p><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<\/strong><\/p>\n<ul>\n<li><strong>Nh\u1eadp m\u1ea3ng * : L\u00e0 t\u1eadp h\u1ee3p c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i c\u1ea7n t\u00e1ch<\/strong><\/li>\n<li><strong>Nh\u1eadp chu\u1ed7i Regular Expression *: L\u00e0\u00a0Matching c\u1ee7a Regular Expression<\/strong><\/li>\n<li><strong>[T\u00f9y ch\u1ecdn] : Chen = y, ten =?, xoaname = ?, tudong = y, xoay = y<\/strong><\/li>\n<\/ul>\n<p>Chu\u1ed7i b\u1eaft l\u00e0 matching c\u1ee7a Regular Expression c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o<a href=\"https:\/\/regexr.com\/\">\u00a0t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-245.gif\" title=\"ex101_92019-nho-245\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/vba101_92019-nho-105.gif\" title=\"vba101_92019-nho-105\"><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\/2024\/12\/ex101_92019-nho-245.gif\" title=\"ex101_92019-nho-245\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Cach_su_dung\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>T\u00e1ch Gmail ra kh\u1ecfi chu\u1ed7i<\/p>\n<blockquote>\n<p><strong>(W|^)[w.+-]*@gmail.com(W|$)<\/strong><\/p>\n<\/blockquote>\n<p>Ki\u1ec3m tra Gmail c\u00f3 t\u1ed3n t\u1ea1i hay kh\u00f4ng?<\/p>\n<blockquote>\n<p><strong>^[a-z][a-z0-9_.]{5,32}@[a-z0-9]{2,}(.[a-z0-9]{2,4}){1,2}$<\/strong><\/p>\n<\/blockquote>\n<p>T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i<\/p>\n<blockquote>\n<p><b>[0-9]<\/b><\/p>\n<\/blockquote>\n<p>K\u00fd t\u1ef1 kh\u00e1c v\u1edbi b\u1ea3ng ch\u1eef Latinh(Ti\u1ebfng Anh)<\/p>\n<blockquote>\n<p><strong>W+<\/strong><\/p>\n<\/blockquote>\n<p>T\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 tr\u1eeb s\u1ed1<\/p>\n<blockquote>\n<p><strong>[^0-9]<\/strong><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30047\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gmail.gif\" width=\"745\" height=\"347\" title=\"gmail\"><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>HocExcelOnline<\/strong><\/a>\u00a0hi v\u1ecdng c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng Add ins HocExcel Online v\u00e0\u00a0 Regular Expression v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<p>H\u00e3y theo d\u00f5i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/\">HocExcelOnline<\/a>\u00a0<\/strong>\u0111\u1ec3 c\u00f3 nhi\u1ec1u b\u00e0i vi\u1ebft b\u1ed5 \u00edch h\u01a1n nh\u00e9, n\u1ebfu th\u1ea5y hay h\u00e3y chia s\u1ebb cho nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn h\u01a1n nh\u00e9<\/p>\n<p>C\u00e1c b\u00e0i vi\u1ebft li\u00ean quan.<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html\">T\u00e1ch k\u00fd t\u1ef1, t\u00e1ch s\u1ed1, t\u00e1ch gmail t\u1eeb m\u1ed9t chu\u1ed7i s\u1eed d\u1ee5ng Regular Expression<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-rang-buoc-voi-yeu-cau-nhap-thong-tin-voi-google-form-bieu-mau.html\">Thi\u1ebft l\u1eadp x\u00e1c th\u1ef1c ph\u1ea3n h\u1ed3i v\u1edbi Google Form (bi\u1ec3u m\u1eabu)<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-regular-expression-trong-vba.html\">C\u00e1ch s\u1eed d\u1ee5ng Regular Expression trong VBA<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-loc-lay-dia-chi-email-khach-hang-tu-danh-sach-co-chua-nhieu-chu-khong-mong-muon.html\">H\u01b0\u1edbng d\u1eabn l\u1ecdc l\u1ea5y \u0111\u1ecba ch\u1ec9 email kh\u00e1ch h\u00e0ng t\u1eeb danh s\u00e1ch c\u00f3 ch\u1ee9a nhi\u1ec1u ch\u1eef kh\u00f4ng mong mu\u1ed1n<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-245.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3212","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\/3212","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=3212"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3213"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}