Tom’s Tutorials For Excel: Parsing an Email Address for Recipient and Domain Names

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:
=LEFT(A2,FIND("@",A2)-1)

This formula in cell C2 and copied down as needed will return the domain name:
=SUBSTITUTE(A2,LEFT(A2,FIND("@",A2)),"")

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
8 comments on “Tom’s Tutorials For Excel: Parsing an Email Address for Recipient and Domain Names
  1. Jared says:

    Using Text to Columns with “@” as your delimiter is also another option.

  2. Sandeep says:

    How is FIND different from SEARCH?

    • Tom Urtis says:

      They are similar, but FIND is case-sensitive and SEARCH is case insensitive. Another difference is that SEARCH provides for using wildcards but FIND does not. Lots of info on the web about this topic but that is what it boils down to.

  3. Andy Capaloff says:

    This was the perfect refresher. thank you! It had been a while since I’d needed to do any parsing and I’d forgotten how much fun it can be 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

*