Trying to extract from a cell to a new cell

[stuartbrisgel]

Hello Y'all


How do I do this?


E2 = White - (Part ID: 4119500)
I want
D2 = White

Thanks

 

[hiker95]

stuartbrisgel,

How about?

Excel 2007
	D	E
1
2	White	White - (Part ID: 4119500)
3
Sheet1

Cell Formulas
Range	Formula
D2	=LEFT(E2,FIND(" ",E2)-1)

 

[stuartbrisgel]

but further down we have

Dark Stone Grey - (Part ID: 4210977)

Need Dark Stone Grey as well ?

 

[hiker95]

stuartbrisgel,

How about?

Excel 2007
	D	E
2	White	White - (Part ID: 4119500)
3	Dark Stone Grey	Dark Stone Grey - (Part ID: 4210977)
Sheet1

Cell Formulas
Range	Formula
D2	=LEFT(E2,FIND(" -",E2)-1)

The formula in cell D2, copied down:
=LEFT(E2,FIND(" -",E2)-1)