I have a lot of string's like below in Column A

I need the left portion of the string (the Part#) put into column B

I thought of using the split function but I don't know how to deal with the varying length of the space.

A formula would be great if someone would be so kind as to supply me with that.

Thanks

(The underscore represents a space, as I posting here strips out extra spaces and I need them shown to demonstrate my requirement)

8-1677-101-NI _____ 100 PCS R.T.S

805-0872-1 __ 110 PCS R.T.S

8-2719-2-U

8-2188 _______ WE HAVE 480 PCS

8-2431-U NO STOCK

8-2624 ____________ 1,240 PCS R.T.S

8-2119-U WE HAVE 400 PCS

8-0853-102-NI WE HAVE 800 PCS