How do I locate cells that contain a certain text?

  • Thread starter Thread starter EZ-XLS
  • Start date Start date
E

EZ-XLS

I want to build a formula that locates the cells that CONTAIN a certain text
and either replace the WHOLE cell with something else or return a defined
result in another cell.

The first part is pretty much what autofilter does when a custom filter is
defined.
 
Depending on what your layout looks like, and without examples, sounds like
you want to use a combination of FIND/SEARCH, MATCH, or INDEX.
 
Back
Top