To get the number portion: =LEFT(A1,FIND(" ",A1,1)-1)

To get the address: =MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1)+1)