Try this...

All on one line:

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

--
Biff
Microsoft Excel MVP


"AJexcelQuestions" wrote in
message ...
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 to contact us......
OR
Schedule an appointment for assistance, or email with your
questions...

Thank you