Remove Domain Name From Email Address In Excel. Extract company names from a list of Email addresses with formula. To extract company names from a list of Email addresses as following screenshot shown I will talk about a useful formula to deal with this job in this article.
In the Home ribbon click Sort Filter then Filter. In a blank cell next to your email address C2 for example enter this formula. To simply the formula you could create a named range domain to hold the domain name then rewrite the formula like this.
Then drag the fill handle down to your range cells that you want to contain this formula and all the user names in the cells have been extracted as follows.
T extract the domain from an email address you can use a formula based on the RIGHT LEN and FIND functions. Convert all letters to lower-case. Hi Please try this method. Column A contains the first name column B contains Last Name and column C contains Domain ie.