Filter Partial string, send to "Filter Sheet"

I created a data based worksheet a few years ago, we are now approaching 10,000 rows and "Ctrl +f " is no longer feasible to find anything, mainly because of Identical street numbers and misspelled words over the years.

I am thinking of a filter to find items, but only from a partial criteria IE:
Filter for addresses that start with the number 100
or
Find addresses that start with the number 100 & street letter starts with c
ie:100 c
lower or upper caps
maybe to make the filter better use 100 ca if the 2nd letter is "a"
Here is a filter code, I don't know what to add to use partial criteria

Please Login or Register  to view this content.

It All works, thanks a lot.....