Hi,

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

Melanie Yasfi9944885566melanie.yasfi@toboc.com
Loic Lecompte9966558844loic.lecomte@toboc.com

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