Excel Import

Separate two words from a cell in two cells

Tom Swift =RIGHT(A1,LEN(A1)-FIND(" ",A1)) =LEFT(A1,FIND(" ",A1)) By find space. Swift Tom =RIGHT(A2,LEN(A2)-FIND(" ",A2)) =LEFT(A2,FIND(" ",A2)) By find space. Peters, Willy =RIGHT(A3,LEN(A3)-FIND(",",A3)-1) =LEFT(A3,FIND(",",A3)-1) By find comma. Willy, Peters =RIGHT(A4,LEN(A4)-FIND(",",A4)-1) =LEFT(A4,FIND(",",A4)-1) By find comma.

If "name address" is in cell A1, in cell B1 type this formula : =MID(A1,1,SEARCH(" ",A1))
Then in cell C1 type this formula: =MID(A1,SEARCH(" ",A1)+1,20)