As to the examples in post #1 try the following:
Formula: copy to clipboard
=MID(A1,FIND("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1))+1,255)

*This formula is credited to the linked article.