Hi,
If all your data starts with numbers and has a space between the number and
the text, as per your samples:

Assuming data in column A, starting in A2, try this in B2, copied down:
=LEFT(A2,FIND(" ",A2,1)-1)

Regards - Dave.