Separating Alpha from Numeric in Address Cell in Excel

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating alpha numeric vlue 23
Prevent alpha character in numeric cell 2
how do I column heading to alpha from Numeric? 1
VLookup in Excel 2007 - question on setup 2
Separating Numerical and Alpha Data in cells 6
Move selected Text/Numbers from Col D to Col A/B 17
Change the column designation from a numeric to an alpha 2
How do I change numeric column designations to alpha? 1

Top