Create two new columns
One column will have everything before the space
=LEFT(A1,FIND(" ",A1,1)-1)The other column will have everything after the space
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Excel – Divide column at space
Create two new columns One column will have everything before the space =LEFT(A1,FIND(” “,A1,1)-1) The other column will have everything after the space =RIGHT(A1,LEN(A1)-FIND(” “,A1,1))
