=LEFT(B1594,FIND(" ",B1594)-1)

Out Of Africa Pure Shea Butter Lip Balm Pomegranate plus Acai -- 0.15 oz (pack of 4)

Out Of Africa Pure Shea Butter Lip Balm Pomegranate plus Acai -- 0.15 oz (pack of 4)