Tom’s Tutorials For Excel: Parsing an Email Address for Recipient and Domain Names
If you have a list of email addresses and you want to parse the recipient and domain names, you can do so with the following formulas as shown in the picture. Note that the formulas will take into account the varying lengths of recipient and domain names.
With the list of email addresses in column A starting in cell A2, this formula in cell B2 and copied down as needed will return the recipient name:
This formula in cell C2 and copied down as needed will return the domain name: