#Excel

Excel – Divide column at space

by Kevin 0
  1. Create two new columns
  2. One column will have everything before the space 
    =LEFT(A1,FIND(" ",A1,1)-1)
  3. The other column will have everything after the space 
    =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))