Using Left function to extract varying number of text

Hi,

I wish to use the =left function to extract the ID number from a Product description cell. However, the ID number varies in length and I want the function to do the following:

=left(A1, stop when first blank appears)

Can anybody help?

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

Assuming that by blank you mean space.