How do I identify cells that contain part of phrase?
 

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?

How do I identify cells that contain part of phrase?
 

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?

How do I identify cells that contain part of phrase?
 

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?

How do I identify cells that contain part of phrase?
 

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?