First 2 words without numeric

[makinmomb]

019 BEBE LADIES TOPS WITH BEADS-NAVY-L
019 BEBE LADIES TOPS WITH BEADS-NAVY-M
019 BEBE LADIES TOPS WITH BEADS-PINK-L
019 BEBE LADIES TOPS WITH BEADS-PINK-XL
020 JUST CAVALLI LADIES TOPS -LTBLUE-L
020 JUST CAVALLI LADIES TOPS -LTBLUE-M
025 JUST CAVALLI LADIES TOPS -GREEN-L
025 JUST CAVALLI LADIES TOPS -GREEN-M

Have this on A1 downwards

Need this on B1 downwards

BEBE LADIES
BEBE LADIES
BEBE LADIES
BEBE LADIES
JUST CAVALLI
JUST CAVALLI
JUST CAVALLI
JUST CAVALLI

[Phuocam]

try this...
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",250)),250,500))
copy down

[makinmomb]

Phuocam thanks

[makinmomb]

Does not work for

ARMANI GENTS CASUAL TROUSER Beige 34
ARMANI GENTS JEANS Blue 40
ARMANI GENTS JEANS Black 34
ARMANI GENTS JEANS Dark Grey 34

It does not give ARMANI GENTS

[makinmomb]

Some description have numeric as first word and some not

[makinmomb]

019 BEBE LADIES TOPS WITH BEADS-NAVY-L
019 BEBE LADIES TOPS WITH BEADS-NAVY-M
020 JUST CAVALLI LADIES TOPS -LTBLUE-L
020 JUST CAVALLI LADIES TOPS -LTBLUE-M
ARMANI GENTS JEANS Blue 40
ARMANI GENTS JEANS Black 34

[makinmomb]

BEBE LADIES
BEBE LADIES
JUST CAVALLI
JUST CAVALLI
ARMANI GENTS
ARMANI GENTS

expected results from above

[Phuocam]

try again...
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",250)),IF(ISNUMBER(--LEFT(A1,FIND(" ",A1))),250,1),500))

[JohnTopley]

Try

=IF(ISNUMBER(LEFT(A1,1)+0),TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",250)),250,500)),TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",250)),1,500)))

[makinmomb]

Thank you John , works

[JohnTopley]

@Phuocam : neat!

[JohnTopley]

Thanks for the feedback.

Phuocam's formula is "neater" than mine.

[Phuocam]

@JohnTopley.
Thank you!