{"id":9119,"date":"2025-01-01T17:50:07","date_gmt":"2025-01-01T17:50:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-lay-ten-tu-dia-chi-email-don-gian\/"},"modified":"2025-01-01T17:50:07","modified_gmt":"2025-01-01T17:50:07","slug":"huong-dan-lay-ten-tu-dia-chi-email-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-lay-ten-tu-dia-chi-email-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email \u0111\u01a1n gi\u1ea3n.<\/p>\n<p>\u0110\u1ecba ch\u1ec9 Email \u201c\u0111\u01a1n gi\u1ea3n\u201d trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 nh\u1eefng Email \u0111\u00fang c\u1ea5u tr\u00fac, kh\u00f4ng g\u1eb7p l\u1ed7i v\u00e0 c\u00e1c m\u00e1y t\u1ef1 \u0111\u1ed9ng c\u00f3 th\u1ec3 thao t\u00e1c d\u1ef1a tr\u00ean. \u0110\u1ed1i v\u1edbi nh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 h\u01a1n, H\u1ecdc Excel Online s\u1ebd cung c\u1ea5p c\u00e1c gi\u1ea3i ph\u00e1p s\u1eeda Email sao cho \u0111\u00fang.<\/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-6775804e60119\" 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-tu-dia-chi-email-don-gian.html#Cong_thuc_lay_ten_tu_dia_chi_Email_don_gian\" title=\"C\u00f4ng th\u1ee9c l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email \u0111\u01a1n gi\u1ea3n\">C\u00f4ng th\u1ee9c l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email \u0111\u01a1n gi\u1ea3n<\/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-tu-dia-chi-email-don-gian.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_tu_dia_chi_Email_don_gian\"><\/span><strong>C\u00f4ng th\u1ee9c l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email \u0111\u01a1n gi\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1ec1 t\u1ed5ng qu\u00e1t, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p><strong>=LEFT(\u201cEmail ban \u0111\u1ea7u\u201d,FIND(\u201c@\u201d,\u201dEmail ban \u0111\u1ea7u\u201d)-1)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\"><strong>H\u00e0m LEFT<\/strong><\/a> gi\u00fap l\u1ea5y ra m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 t\u1eeb chu\u1ed7i ban \u0111\u1ea7u.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\"><strong>H\u00e0m FIND<\/strong><\/a> gi\u00fap t\u00ecm ra v\u1ecb tr\u00ed k\u00ed t\u1ef1 trong chu\u1ed7i c\u00f3 s\u1eb5n.<\/p>\n<p>K\u1ebft h\u1ee3p 2 h\u00e0m, ta s\u1ebd l\u1ea5y nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ee9ng tr\u01b0\u1edbc d\u1ea5u \u201c<strong>@<\/strong>\u201c.<\/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-10.gif\" title=\"ex101_92019-nho-10\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25558\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tach-ten-tu-email-1.png\" width=\"754\" height=\"203\" title=\"tach-ten-tu-email-1\"><\/p>\n<p>T\u1ea1i \u00f4 B1 ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00e1ch t\u00ean t\u1eeb \u00f4 A1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25559\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tach-ten-tu-email-2.png\" width=\"753\" height=\"249\" title=\"tach-ten-tu-email-2\"><\/p>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html\">Autofill<\/a><\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 t\u1eeb B2 \u0111\u1ebfn B6:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25560\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tach-ten-tu-email-3.png\" width=\"1022\" height=\"224\" title=\"tach-ten-tu-email-3\"><\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\"><strong>H\u00e0m FIND v\u00e0 h\u00e0m SEARCH<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel.html\"><strong>H\u00e0m LEFT k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-va-su-dung-autofill-hieu-qua-mos-excel-2010.html\"><strong>Thi\u1ebft l\u1eadp v\u00e0 s\u1eed d\u1ee5ng\u00a0Autofill<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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<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-10.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9120,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9119","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\/9119","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=9119"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9119\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9120"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}