Separating Alpha from Numeric in Address Cell in Excel

  • Thread starter Thread starter DBUTTER69
  • Start date Start date
D

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.
 
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
 
Back
Top