How to Separate street number from address

=IF(ISNUMBER( VALUE(LEFT(A1,1))), LEFT(A1,SEARCH(" ",A1)-1), "")