Extracting an email address from a cell with multiple email addresses

[kmholm]

I have a string that contains text including two different email addresses. I need to extract only the email that comes last. I was able to use a function to get the email but it's the first email not the 2nd one. Any help would be appreciated. Thanks!

 

[AlphaFrog]

How are the emails separated? Examples would help.

 

[kmholm]

The text file includes information such as company address, anniversary date, manager email, manager location, employee email. All separated by spaces. Example: Company Name Company Rep Street Address Manager Name Manager Email Employee Name Employee Email Employee Address Anniversary Date

 

[István Hirsch]

Try this:

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",255)),FIND("ß",SUBSTITUTE(SUBSTITUTE(A1,"@","ß",2)," ",REPT(" ",255)))-255,500))