I have been trying to separate the first part of the text from each cell, but it will only return the part in all caps and the next word. I only need the part in all caps with numbers, or numbers only.

This is how it is formatted.

RSASS400
Chambray Stripe Travel Pant

The formula I am using is: =LEFT(A11,SEARCH(" ",A11)-1)

Unfortunately there is a space between The all caps/number "style" and the descriptions, and I don't know how to remove it. There are over 1000 lines, and I don't want to have to remove each space.