hi Harkirat. try:
=--LEFT(A1,FIND(" ",A1)-1)

you can just take the above result minus the other after copying the formula