Filter Address missing #'s

[ctackett6407]

I'm trying to sort about 50-60k rows of data and doing so by manually going through the lists and deleting the rows that do not have the #### part of the address.

Is there a way to filter down and see addresses that contain the

Main St

and not the 1234 Main St?

like 123 Dunn Rd are ones I want to keep but the cells that contain Dunn Rd I want to get rid of that row.

I have thousands and thousands of different roads and streets to go through.

I'm basically comparing to data files for matching addresses so I can associate a number to them to create a "primary key" and I'm using fuzzy lookup from microsoft which is helping a lot, but I still have to manually check 50-60k lines of data to make absolutely sure they match.

 

[kweaver]

Haven't tried it, but my thought is to put a column next to or somewhere in parallel to the street addresses.
Then, fill this formula down and filter keeping the 1s from that column if you want streets with numbers and keeping 0s if you want the ones without numbers.

=IF(ISNUMBER(1*LEFT(A2,1)),1,0)