How to extract company name from email address in Excel?
Author: XiaoyangLast Modified: 2017-07-24
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.
The following formula can help you to extract the company names from the email addresses, please do as this:
Enter this formula into a blank cell beside your data: =LEFT(REPLACE(A2,1,FIND("@",A2),""),FIND(".",REPLACE(A2,1,FIND("@",A2),""))-1), and then drag the fill handle down to the cells which you want to apply this formula, all company names have been extracted from the email addresses, see screenshot:
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...