Split excel data BEFORE and AFTER the first space.
Split excel data BEFORE and AFTER the first space.
In this example we have the part number, and the description in one cell using the formulas below:
Remove data after FIRST SPACE
=LEFT(A2,FIND(" ",A2)-1)
Remove data before FIRST SPACE
=MID(A2,FIND(" ",A2)+1,256)