Extract email addresses between words in a cell

Originally Posted by LeoTaxi

In E4

Formula:

=LEFT(D4,SEARCH(" ",D4,1)-1) & "." &  RIGHT(D4,LEN(D4)-SEARCH(".",D4,1))

and drag down

Kind regards
Leo

Thank you Leo for this. This one seems to most of what I asked initially, just the last letters on the end need to come off after the domain name. Thanks again for helping out!