How to extract a domain name from an email address in Excel or Google Docs

Posted by Paul Helmick

I’m a Technology CEO and Experienced Entrepreneur. I love helping people use technology to grow their business. 

Given a list of email addresses, where you want the domain name in it’s own column, here is the formula:

This gives you a column that you can pivot on to get a frequency count of domain names within an email list. This helps you better understand what companies are on the list.  I remember a client once sending out an e-blast to their customers and sent out like 300 emails to every person in one large law firm.  Needless to say they made quite an impression…

Google Sheets

=RIGHT(A2,Len(A2)-FIND("@",A2))

stringdomain

Microsoft Excel

=RIGHT(A2,Len(A2)-FIND("@",A2))

stringexcel

You Might Like

New Year Notes

New Year Notes

In starting off the new year, I was making some notes and thought to share this process...