Filtering a Text Column based on a particular word

S

shriil

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top