Split Names and Emails in Excel

=TEXTSPLIT(A2," ")
=TEXTBEFORE(A2,"@")
=TEXTAFTER(A2,"@")
=LEFT(A2,FIND(" ",A2)-1)

TEXTSPLIT can #SPILL! if the output area is blocked — fix SPILL.

Also: Data → Text to Columns, or Flash Fill (Ctrl+E).