Get domain from email address

To extract the domain from an email address, you can use a formula based on the TEXTAFTER function. In the example shown, the formula in E5 is: =TEXTAFTER(C5,"@") As the formula is copied down the table, it extracts the domain name from each email as shown. Notes: (1) TEXTAFTER is a newer function in Excel. In older versions of Excel, you can use a formula based on the RIGHT function as explained below. (2) All emails shown in the worksheet are fictional.

April 14, 2025 · 1 min · 97 words · Dustin Tran

Table of Contents

All three options are explained below.

TEXTAFTER function

TheTEXTAFTER functionreturns the text that occursaftera given delimiter.

For more information, seeHow to use the TEXTAFTER function.

Get domain from email with the TEXTSPLIT function

Note: you’re able to use theTEXTBEFORE functionto extract the name portion of the email.

For more details on TEXTSPLIT, seeHow to use the TEXTSPLIT function.

once you nail trimmed email addresses, apply the formula above.

Get domain from email with the TEXTSPLIT function

TEXTSPLIT can split text into rows or columns.

For example, =RIGHT(“apple”,3) returns “ple”.

LEN will also count characters in numbers, but number formatting is not included.

Get domain from email with the TEXTSPLIT function

When the text is not found, FIND returns a #VALUE error.

Get domain from email with the TEXTSPLIT function

Get domain from email with the TEXTSPLIT function

Excel formula: Get name from email address

Excel formula: Get domain name from URL

Excel formula: Get top level domain (TLD)

Excel formula: Create email address from name

Excel formula: Remove protocol from URL

Excel TEXTAFTER function

Excel TEXTSPLIT function

Excel RIGHT function

Excel LEN function

Excel FIND function