View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T Perry
 
Posts: n/a
Default 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?