Hopefully, I can explain without too much complexity!

The worksheet that has the columns of data that I want to look up has 4
columns of data. In the 3rd column the data varies widely, but here's a
general example:
B650TBG CB 325X400 STD SET

In another worksheet (of the same workbook), I need a formula, which is
going to start in cell N1436, that will go look up the data in this 3rd
column, which I have named SALESTYPE, and will put in the cell N1436 only the
combination of letters and numbers up to the first space---in this case
B650TBG. This is not consistent, however. The first space could be after
just three digits, as in this example: C91 W 8.875 X6.750 X1.625, in
which case it would only put C91 in cell N1436.

Hope this can be done. Thank you. Connie Martin