Separating Alpha from Numeric in Address Cell in Excel
 

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

Separating Alpha from Numeric in Address Cell in Excel
 

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
--
Gary''s Student - gsnu200843


"DBUTTER69" wrote:

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