After extracting first word from column, how do you delete what you've extracted for

After extracting first word in string from column A, using:

In B1 use:
=LEFT(A1,FIND(" ",A1)-1)

how do you delete what you've just extracted for C1, leaving everything else in string?

Thanks

This should work for you; it uses the MID function and the FIND function and the LEN function:

=MID(A1,(FIND(" ",A1,1)+1),LEN(A1)-FIND(" ",A1,1))

Regards,
theDude