Extract emails from cells with text

  • Thread starter AJexcelQuestions
  • Start date
A

AJexcelQuestions

I have a row in column A which includes an email address in the text that I'd
like to extract to column B. Is there a formula I can use to accomplish
extracting the email address only to column B?

Here's an example of different cells in column A:

Please email [email protected] to contact us......
OR
Schedule an appointment for assistance, or email [email protected] with your
questions...

Thank you
 
T

T. Valko

Try this...

All on one line:

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND
(" ",A1&" ",FIND("@",A1))-1)," ",
REPT(" ",LEN(A1))),LEN(A1)))
 
Top