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.

**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

It is exactly the formula I was looking for!

Much appreciated!