Very large data base and need to separate address from street name

**pick44** · 08-22-2017, 12:17 PM

Have about 200,000 rows of data and need to separate address number from street name. I can do a Text/columns but would rather have a formula. Thanks

**Glenn Kennedy** · 08-22-2017, 12:20 PM

Use this:

=LEFT(A1,SEARCH(" ",A1)-1)+0

**Glenn Kennedy** · 08-22-2017, 12:23 PM

If you can have addresses like 100A Mickey Mouse Avenue, then use:

=LEFT(A1,SEARCH(" ",A1)-1)

However all values will then be returned as TEXT. In this case, that is probably not an issue for you.

Very large data base and need to separate address from street name

LinkBack

Thread Tools

Rate This Thread

Display

Very large data base and need to separate address from street name

Re: Very large data base and need to separate address from street name

Re: Very large data base and need to separate address from street name

Thread Information

Users Browsing this Thread

Similar Threads

Matching Street Address to Separate File that Has Zip Codes

Large Excel Data Base With Street Names that might End in Dr or Blvd or St

How to Extract Street Numbers from an Address to Separate Columns

Look up specific street address within street address range

Need to pull address ranges with accompanying data for large data base

[SOLVED] Want to separate unique and duplicate data from large data base

separate street address and street number

Bookmarks

Bookmarks

Posting Permissions