Indzara

Extract Domain Names from Email Address in Excel

This post shares the simplest way to extract only the domain name from email addresses. To do this, let us take some sample email addresses starting from cell C7.

For the domain name, we need to extract the text after “@” and the text before “.”, we’ll get this by using a combination of TEXTBEFORE and TEXTAFTER which has the syntax:

In our case the formula in cell F7 will be, 

With this simple formula, get domain names from email address easily:

To copy the formula to the cells below, just drag the end of cell F7

Note: The TEXTBEFORE AND TEXTAFTER functions are available only in Microsoft 365 subscriptions. Learn about Microsoft 365

We have a dedicated YouTube video that explains the extraction of Email addresses into its constituent parts, check it out here:

Leave a Reply

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

Boost Your Excel Skills!

Join our weekly newsletter for expert insights.