Use this array formula to extract Name assuming your data in A1
In B1 enter:
**Need to use Ctrl+Shift+Enter
=LEFT(A1,MAX((MID(A1,ROW($1:$100),1)=" ")*ROW($1:$100)))
For Email address use this (not an array) formula in C1
=RIGHT(A1,LEN(A1)-SEARCH("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
Bookmarks