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…