Separating Alpha from Numeric in Address Cell in Excel

[DBUTTER69]

What formula should I enter if I want to create separate columns for the
alpha and numeric portions of a street address? HELP! Thanks.

 

[Gary''s Student]

If your street address is always a number followed by a single blank followed
by the street name like:

123 Maple Avenue

Then we will look for that first blank:

=LEFT(A1,FIND(" ",A1)) the numeric part
=MID(A1,FIND(" ",A1)+1,256) the street name