{"id":9109,"date":"2025-01-01T16:06:32","date_gmt":"2025-01-01T16:06:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-lay-ten-mien-tu-dia-chi-email\/"},"modified":"2025-01-01T16:06:32","modified_gmt":"2025-01-01T16:06:32","slug":"huong-dan-lay-ten-mien-tu-dia-chi-email","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-lay-ten-mien-tu-dia-chi-email\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb \u0111\u1ecba ch\u1ec9 Email"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, H\u1ecdc Excel Online \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email. L\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb \u0111\u1ecba ch\u1ec9 Email c\u1ee5 th\u1ec3.<\/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-67756807990ae\" 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\/lay-ten-mien-tu-dia-chi-email.html#Cong_thuc_lay_ten_mien_tu_dia_chi_Email\" title=\"C\u00f4ng th\u1ee9c l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb \u0111\u1ecba ch\u1ec9 Email\">C\u00f4ng th\u1ee9c l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb \u0111\u1ecba ch\u1ec9 Email<\/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\/lay-ten-mien-tu-dia-chi-email.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_lay_ten_mien_tu_dia_chi_Email\"><\/span>C\u00f4ng th\u1ee9c l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb \u0111\u1ecba ch\u1ec9 Email<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb \u0111\u1ecba ch\u1ec9 Email ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p class=\"excel geshifilter-excel\"><strong><span class=\"sy1\">=<\/span><span class=\"kw4\">RIGHT<\/span><span class=\"sy0\">(\u0111\u1ecba ch\u1ec9\u00a0<\/span>email<span class=\"sy0\">,<\/span><span class=\"kw4\">LEN<\/span><span class=\"sy0\">(\u0111\u1ecba ch\u1ec9\u00a0<\/span>email<span class=\"sy0\">)<\/span><span class=\"sy1\">\u2013<\/span><span class=\"kw4\">FIND<\/span><span class=\"sy0\">(<\/span><span class=\"st0\">\u201c@\u201d<\/span><span class=\"sy0\">,\u0111\u1ecba ch\u1ec9\u00a0<\/span>email<span class=\"sy0\">))<\/span><\/strong><\/p>\n<\/blockquote>\n<p class=\"excel geshifilter-excel\">Trong \u0111\u00f3:<\/p>\n<p class=\"excel geshifilter-excel\"><a href=\"http:\/\/blog.ezworkapp.com\/17-%E2%97%8F-cach-su-dung-ham-find-va-replace-trong-excel.html\"><strong>H\u00e0m FIND\u00a0<\/strong><\/a>s\u1ebd t\u00ecm ra v\u1ecb tr\u00ed k\u00ed t\u1ef1 \u201c<strong>@<\/strong>\u201d trong chu\u1ed7i \u0111\u1ecba ch\u1ec9 email.<\/p>\n<p class=\"excel geshifilter-excel\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-ki-tu-trong-o-bang-ham-len.html\"><strong>H\u00e0m LEN<\/strong><\/a> tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 c\u1ee7a \u0111\u1ecba ch\u1ec9 email.<\/p>\n<p class=\"excel geshifilter-excel\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\"><strong>H\u00e0m RIGHT<\/strong><\/a> l\u1ea5y ra m\u1ed9t\u00a0s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 t\u1eeb chu\u1ed7i ban \u0111\u1ea7u.<\/p>\n<p class=\"excel geshifilter-excel\">K\u1ebft h\u1ee3p l\u1ea1i, c\u00e1c h\u00e0m ho\u1ea1t \u0111\u1ed9ng nh\u01b0 sau:<\/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\/2025\/01\/ex101_92019-nho-8.gif\" title=\"ex101_92019-nho-8\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p class=\"excel geshifilter-excel\">S\u1eed d\u1ee5ng\u00a0<strong>h\u00e0m FIND<\/strong> t\u00ecm ra v\u1ecb tr\u00ed c\u1ee7a k\u00ed t\u1ef1 \u201c<strong>@<\/strong>\u201d trong email. S\u1eed d\u1ee5ng\u00a0<strong>h\u00e0m LEN<\/strong> l\u1ea5y s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 email. Sau \u0111\u00f3 <strong>tr\u1eeb<\/strong> \u0111i k\u1ebft qu\u1ea3 c\u1ee7a\u00a0<strong>h\u00e0m FIND<\/strong> s\u1ebd ra \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1\u00a0<strong>\u0111\u1ee9ng sau\u00a0k\u00ed t\u1ef1\u00a0\u201c@\u201d<\/strong>. Cu\u1ed1i c\u00f9ng s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>RIGHT<\/strong> tr\u1ea3 v\u1ec1 t\u1eebng \u0111\u00f3 k\u00ed t\u1ef1 trong chu\u1ed7i.<\/p>\n<h3 class=\"excel geshifilter-excel\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25587\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tach-ten-mien-tu-email-1.png\" width=\"296\" height=\"123\" title=\"tach-ten-mien-tu-email-1\"><\/p>\n<p>Ta s\u1ebd ti\u1ebfn h\u00e0nh t\u00e1ch t\u00ean mi\u1ec1n kh\u1ecfi 4 email b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean. B\u1eaft \u0111\u1ea7u t\u1ea1i \u00f4 B1, nh\u1eadp c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi A1:<\/p>\n<blockquote>\n<p><strong><em>=RIGHT(A1,LEN(A1)-FIND(\u201c@\u201d,A1))<\/em><\/strong><\/p>\n<\/blockquote>\n<p>Sau \u0111\u00f3, s\u1eed d\u1ee5ng AutoFill \u0111\u01b0a\u00a0c\u00f4ng th\u1ee9c\u00a0xu\u1ed1ng nh\u1eefng \u00f4 c\u00f2n l\u1ea1i. Ta thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25588\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tach-ten-mien-tu-email-2.png\" width=\"483\" height=\"173\" title=\"tach-ten-mien-tu-email-2\"><\/p>\n<p>\u00a0<\/p>\n<p>Kh\u00f4ng kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/lay-ten-tu-dia-chi-email-don-gian.html\"><strong>H\u01b0\u1edbng d\u1eabn l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-email-tu-ten-don-gian.html\"><strong>H\u01b0\u1edbng d\u1eabn t\u1ea1o email t\u1eeb t\u00ean \u0111\u01a1n gi\u1ea3n<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p class=\"excel geshifilter-excel\">\n<p class=\"excel geshifilter-excel\">\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\/2025\/01\/ex101_92019-nho-8.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9110,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9109","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\/9109","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=9109"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9109\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9110"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}