Table of Contents
An email address is a string of characters that identify a user on an email system. It enables an email message to be sent from one user to another.
An email address is composed of two parts: a username and a domain name. The username comes first, followed by the @ symbol, followed by the domain name.
For example, in the email address [email protected], “example” is the username and “example.com” is the domain name.
The domain name is the part of the email address that comes after the @ symbol. It identifies the email provider that is hosting the email account. In the example above, “example.com” is the domain name.
A domain name must be unique. That means that no two organizations can have the same domain name.
Domain names are registered with domain name registrars. These registrars are accredited by the Internet Corporation for Assigned Names and Numbers (ICANN), which is the organization that oversees the domain name system.
You can use the following formula to extract an email address from a text string in Excel:
=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))-1)," ",REPT(" ",LEN(A2))),LEN(A2))), "")
This particular formula extracts the email address from the text string in cell A2.
If no email address is found in cell A2, the formula simply returns a blank.
The following example shows how to use this formula in practice.
Example: How to Extract Email Address from Text String in Excel
Suppose we have the following column of text strings in Excel:
Suppose we would like to extract the email address from each text string.
To do so, we can type the following formula into cell B2:
=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))-1)," ",REPT(" ",LEN(A2))),LEN(A2))), "")
We can then click and drag this formula down to each remaining cell in column B:
Column B now contains the email address from each text string in column A.
Note that cell A5 didn’t contain an email address so the formula simply returned a blank value.
Note: If a cell contains more than one email address, this formula will only return the first email address.