{"id":3552,"date":"2023-10-22T02:10:07","date_gmt":"2023-10-22T02:10:07","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/"},"modified":"2023-12-03T11:14:01","modified_gmt":"2023-12-03T11:14:01","slug":"domain-bekommen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/","title":{"rendered":"Wie bekomme ich eine domain von einer e-mail-id?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1217173661\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Nehmen wir an, Sie haben eine Liste mit E-Mail-IDs und m\u00f6chten nun die Dom\u00e4ne jeder ID extrahieren. In Excel k\u00f6nnen Sie die Dom\u00e4nen mit einer einfachen Formel extrahieren. Und in diesem Tutorial lernen wir, wie man diese Formel schreibt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83660\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png\" sizes=\"auto, \" srcset=\"\" alt=\"get-domain-from-email-id\" width=\"595\" height=\"471\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RIGHT(A2,LEN(A2)-SEARCH(\"@\",A2))<\/code><\/pre><p> Die obige Formel hilft Ihnen, die Domain aus der E-Mail zu erhalten. Um diese Formel zu verstehen, m\u00fcssen Sie sie in drei Teile teilen.<\/p><h2 class=\"wp-block-heading\"> Erhalten Sie den Standort von @ per E-Mail<\/h2><p> Zuerst m\u00fcssen Sie die Position des \u201e@\u201c in der E-Mail-ID ermitteln. Wie Sie wissen, beginnt die Domain in einer E-Mail-ID nach dem \u201e@\u201c. Dazu m\u00fcssen Sie die SEARCH-Funktion verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83661\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-recherche-pour-obtenir-le-poste.png\" sizes=\"auto, \" srcset=\"\" alt=\"Suchen, um eine Position zu erhalten\" width=\"515\" height=\"209\"><\/figure><\/div><p> Im obigen Beispiel haben Sie 6 im Ergebnis, was bedeutet, dass die Position von \u201e@\u201c <sup>an 6. Stelle<\/sup> in der E-Mail steht.<\/p><h2 class=\"wp-block-heading\"> Z\u00e4hlen Sie die L\u00e4nge der Domain<\/h2><p> Ermitteln Sie als N\u00e4chstes die Zeichenanzahl des Dom\u00e4nenteils der E-Mail. Und dazu m\u00fcssen Sie die LEN-Funktion verwenden, um die Anzahl zu ermitteln. Und leiten Sie dann die Position des \u201e@\u201c ab. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-longueurs-de-domaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"count-length-of-domain\" width=\"549\" height=\"223\"><\/figure><\/div><p> Im Schnappschuss haben wir die Domain \u201eyahoo.ca\u201c, die 8 Zeichen hat, und das ist das Ergebnis.<\/p><h2 class=\"wp-block-heading\"> Dom\u00e4ne extrahieren<\/h2><p> Sie kennen die Domainl\u00e4nge in der E-Mail-ID. Sie k\u00f6nnen also die RIGHT-Funktion verwenden, um den Bereich der rechten Seite der Zelle abzurufen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83663\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-extrait-de-domaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"Extraktdom\u00e4ne\" width=\"524\" height=\"265\"><\/figure><\/div><p> RIGHT verwendet die Zeichenanzahl der Domain und ruft sie von der E-Mail-ID-Seite ab. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/de\/a\/\" rel=\"nofollow\">Herunterladen<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/formeln\/\">Liste der Excel-Formeln<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Verwandte Formeln <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/horizontaler-filter\/\">Erstellen Sie in Excel einen horizontalen Filter<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/bewertung-in-sternen\/\">Erstellen Sie eine Sternebewertungsvorlage in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/dateinamen-abrufen\/\">Dateinamen in Excel abrufen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/holen-sie-sich-den-blattnamen\/\">Blattnamen in Excel abrufen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/generiere-zufallige-buchstaben\/\">Generieren Sie schnell zuf\u00e4llige Buchstaben in Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3552","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wie bekomme ich eine Domain von einer E-Mail-ID?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine Domain aus einer E-Mail-ID zu erhalten. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie bekomme ich eine Domain von einer E-Mail-ID?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine Domain aus einer E-Mail-ID zu erhalten. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:14:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/\",\"name\":\"Wie bekomme ich eine Domain von einer E-Mail-ID?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png\",\"datePublished\":\"2023-10-22T02:10:07+00:00\",\"dateModified\":\"2023-12-03T11:14:01+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine Domain aus einer E-Mail-ID zu erhalten. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie bekomme ich eine domain von einer e-mail-id?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie bekomme ich eine Domain von einer E-Mail-ID?","description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine Domain aus einer E-Mail-ID zu erhalten. Lassen Sie uns das \u00fcberpr\u00fcfen ...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/","og_locale":"de_DE","og_type":"article","og_title":"Wie bekomme ich eine Domain von einer E-Mail-ID?","og_description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine Domain aus einer E-Mail-ID zu erhalten. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:14:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/","url":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/","name":"Wie bekomme ich eine Domain von einer E-Mail-ID?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png","datePublished":"2023-10-22T02:10:07+00:00","dateModified":"2023-12-03T11:14:01+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine Domain aus einer E-Mail-ID zu erhalten. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/domain-bekommen\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-le-domaine-a-partir-de-lidentifiant-de-messagerie.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/domain-bekommen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie bekomme ich eine domain von einer e-mail-id?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3552"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3552\/revisions"}],"predecessor-version":[{"id":3876,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3552\/revisions\/3876"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}