I want to do a search where I can look up the "street name" out of an address
column. For example, where it says 1708 Augusta Rd, I want to search for all
address on "Augusta" (in case it's Street instead of Road). Does anyone know
how to do this?

If your data is set up as a table you can use the DATA/AUTOFILTER from the
menu and this run a custom query in the address column using the 'contains'
operator.


--
Kevin Backmann


"T Perry" wrote:

I want to do a search where I can look up the "street name" out of an address
column. For example, where it says 1708 Augusta Rd, I want to search for all
address on "Augusta" (in case it's Street instead of Road). Does anyone know
how to do this?

Data Filter AutoFilter Custom Contains Augusta

Vaya con Dios,
Chuck, CABGx3



"T Perry" wrote:

I want to do a search where I can look up the "street name" out of an address
column. For example, where it says 1708 Augusta Rd, I want to search for all
address on "Augusta" (in case it's Street instead of Road). Does anyone know
how to do this?

You could have a helper column with -
=IF(ISNUMBER(SEARCH("Augusta",A1)),1,0)
This will return 1 in any row with the target text.

Regards.

Bill Ridgeway
Computer Solutions

"T Perry" wrote in message
...
I want to do a search where I can look up the "street name" out of an
address
column. For example, where it says 1708 Augusta Rd, I want to search for
all
address on "Augusta" (in case it's Street instead of Road). Does anyone
know
how to do this?