Formula to extract emails when there is no spaces in the cell

Hi,

I just received a database of contacts which I would like to use in my company.

Melanie [email protected]
Loic [email protected]

Here are the first two cells. I found formulas to extract only the number and the first name. But I can not seem to find a Formula to only extract the email, as the characters before it always changes, but it will only be a number. ( I can not only extract the Last name too)

There is 80 000 rows so doing it rows by rows wouls take too much time!

Thanks in advanced

Wow thank you so much ! I have been on this for so much time!

Could you also help me extract only the second word (Last name), before the number? my goal is to extract: First Name, Last Name, Number and Email.

Thank you so much!

Edit: too slow

array formula
=REPLACE(A1,1,MAX(ISNUMBER(--MID(A1,ROW($1:$100),1))*ROW($1:$100)),)

This is Great!
Last question:

To extract only the number i found this formula

=SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$25),1))*ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

The issue is that if there are other numbers in the cell, such as in the email, it will also take it into account. Do you have a formula that would only take the phone number, between the last name and the email?

Thank you so much again and again!

Thank you So much!! You helped me save so much time!