Learn how to get the unique mail server domain name with this simple formula.
Essentially this is how you extract domain name from e-mail address in Excel. Or in other words, Split e-mail address in Excel? Some people like to ask how to extract e-mail address from excel column. Or extract domain from e-mail.
If you're using Microsoft 365, there are additional functions available that can further simplify the process of obtaining a unique mail server domain name. Alongside the CONCATENATE function, you can leverage the TEXTAFTER and UNIQUE functions to generate distinct domain names effortlessly.
The TEXTAFTER function allows you to extract specific text after a given delimiter, such as a dot or an underscore, from an existing domain name. This function is particularly useful when you have a list of domain names and want to extract the unique portions to create new combinations. By combining TEXTAFTER with the CONCATENATE function, you can easily merge these extracted elements with other desired prefixes or suffixes to generate unique domain names.
In addition to TEXTAFTER, the UNIQUE function plays a crucial role in ensuring the uniqueness of the domain names. This function eliminates any duplicates from a list of values, allowing you to work with only the unique entries. By applying the UNIQUE function to your list of domain names, you can avoid repetition and ensure that each generated domain name is distinct.
By combining the CONCATENATE function with TEXTAFTER and UNIQUE, Microsoft 365 users have access to a powerful set of tools within Excel. These functions enable the creation of unique mail server domain names swiftly and efficiently, providing a seamless solution for both personal and professional purposes.
Here's the formula that's being used in my video.
Get Mail Server Domain Name
=TEXTAFTER(A2:A205,"@")
Get Unique Mail Server Domain Name
=UNIQUE(TEXTAFTER(A2:A205,"@"))
