Separating information within the cell

How can I take out the house number to the address and put it into another cell? Example

1041 Meadows Ave .....in one cell

changed to

1041 in one cell and Meadows Ave in the original cell

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)