find text string

S

soapydux

Hi

I need to identify rows of data that have a particular word in them

for example to find the word INCENTIVE from the following rows

Bonus incentive fund
Commercial pricing
advertising incentive
budgets
incentive for staff

so lines 1,3 and 5 contain the word incentive - need to mark these
true/false or whetever

Many Thanks for any help.
 
B

Bob Umlas, Excel MVP

You can mark them TRUE/FALSE with this formula:
=NOT(ISERROR(SEARCH("Incentive",A1))) and fill down.
If your data starts in A2 and has a header in A1, you can enter this in E2,
say, then use E1:E2 as a criteria for data/filter/advanved filter, and only
see those rows containing Incentive:
=NOT(ISERROR(SEARCH("Incentive",A2)))
 
D

Dave Peterson

Another option:

=COUNTIF(A1,"*incentive*")>0

(will mark it as true/false, also)

And I like this variation of Bob's suggestion:
instead of:
=NOT(ISERROR(SEARCH("Incentive",A1)))
just
=isnumber(search("incentive",a1))

(ps. =Find() is case sensitive. =search() is not case sensitive)
 
Top