Extract emails from cells with text

[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 (e-mail address removed) to contact us......
OR
Schedule an appointment for assistance, or email (e-mail address removed) with your
questions...

Thank you

 

[T. Valko]

Try this...

All on one line:

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