Excel: How to Extract Email Address from Text String

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:

Excel extract email address from text

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.

Additional Resources

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

Excel: How to Extract URL from Hyperlink
Excel: How to Extract Date from Text String
Excel: How to Extract Text Between Two Commas
Excel: How to Extract Numbers from String

Leave a Reply

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