All journal entries
Excel

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))

  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))
    

Start a build

Tell me where work is getting stuck.

Share the process, bottleneck or idea. I'll reply with a practical first step—not a generic sales pitch.

Sent securely to my inbox. Your details are only used to reply.