Hi.

I have a list of product numbers all different in length & format followed by space, then "-" another space and the product name

for example:

123.678 - product1
182 - product2
81.70.2h.hy.60 - product 3
qwerty.78 - product 4

I'd like to know how to return the position of first occurance of space so I can apply a =left() function to end with list of product numbers alone.

Suggestions>?