Hi , Firstly my Engilish is not enaugh good. If you help me, I will be happy . I have a cloumn in excel and the column have the company names. I search some word (ltd, sti, oto .....ext.) in column and I want to put a cod across the cell . For example :

Ornek ltd 1
Bu sti 1
Yok ki 0
Buda yok 0
Oto var 1

First row contains my words (ltd, sti, oto ....ext.) then put 1 and third row doesn’t cointain (ltd, sti, oto ext.) then put 0. Btw I know excel have contains filters. But excel doensnt permission extra 2 . I hope I can explain what I want Thanks