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)),"")
Using Text to Columns with “@” as your delimiter is also another option.
…yes, assuming you did not want to keep the original list intact.
Thanks for following my blog.
If you set your destination as the cell adjacent to your list ($B$2) then the original list will remain intact.
Yep, very true. Actually I’d forgotten about that option; I usually just click Finish at Step 2. Thanks for the remider.
How is FIND different from SEARCH?
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.
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 🙂
Thank you, Andy!
Thank you