#Excel Excel – Divide column at space 03 Oct by Kevin 0 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))
Comments (0)