You can use the following syntax to extract the domain name from an email address in Excel:

=TEXTAFTER(A2, "@")

This particular formula extracts the domain name from the email address in cell **A2**.

For example, suppose cell **A2** contains the following email address:

**zach@statology.org**

This formula will return just the domain name from this email address:

**statology.org**

The following example shows how to use this formula in practice.

**Example: Extract Domain from Email Address in Excel**

Suppose we have the following column of email addresses in Excel:

Suppose we would like to extract the domain name from each email address in column A.

We can type the following formula into cell **B2** to do so:

=TEXTAFTER(A2, "@")

We can then click and drag this formula down to each remaining cell in column B:

Column B now contains the domain name from each email address in column A.

For example:

- The formula extracts
**statology.org**from**zach@statology.org** - The formula extracts
**superemail.com**from**doug@superemail.com** - The formula extracts
**messengerflighter.com**from**cody@messengerflighter.com**

And so on.

**How This Formula Works**

The **TEXTAFTER **function in Excel extracts all text in a cell after a specific character or substring.

This function uses the following syntax:

**TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])**

where:

**text**: Text to search**delimiter**: Character or substring to extract text after**instance_num (optional)**: Instance of delimiter after which to extract text (default is 1)**match_mode (optional)**: 0 = case-sensitive (default), 1 = case-insensitive**match_end (optional)**: Treat end of text as delimiter (disabled by default)**if_not_found (optional)**: Value to return if delimiter is not found

Recall that we used the following syntax to extract the domain name from each email address:

=TEXTAFTER(A2, "@")

By using a value of **@ **for the delimiter, we were able to specify that we wanted to extract the text after the **@ **in each string.

This is equivalent to extracting just the domain name from each email address.

**Note**: You can find the complete documentation for the **TEXTAFTER **function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Remove Specific Text from Cells

Excel: How to Remove Special Characters

Excel: How to Insert a Character into a String