Filtering a Text Column based on a particular word
 

I have a worksheet with one "Remarks" Column. The "Remarks" column
fields may have the following text

may be awarded on manpower rates
can be awarded on general quotation Ref No. XXX
may be awarded on previous order basis
may be awarded via General quotation Ref No. YYY
has carried out the job on basis of general quotation Ref No. ABAB
may be awarded on approved rates


.... and so on and so forth

I would like to filter this column based on the text which has the
word "general" in it. As it can be observed, the word "general" does
not have a fixed location in the column and then again sometimes the
'g' of general may be in the upper case too.

Thanks for the help

Filtering a Text Column based on a particular word
 

Data Filter AutoFilter Custom Contains
--
Gary''s Student - gsnu200842