Get Domain Name From Email In Excel. In the example shown the formula in E4 is. How To Extract Domain Name from EMail in Excel.
In the example we are using this formula. If want to extract the name part of an email address you can do so with a formula that uses the LEFT and FIND functions. Click on submit button to extract URLs.
Now copy this cell C2 and paste it to the other cells in column C.
LEFTC4FIND C4 - 1. Extract company names from a list of Email addresses with formula. Take the name from email address in Excel. With cell A1 being the one with the email address in cell C1 put this formula to extract the domain name.