it will search in D2 cell that is there anywhere "Honda" word in cell D2. if
it is there result will get "Honda" or what is there in D2

ex: D2: "Hero Honda" or D2: "Hero Honda Two wheelers"
those words u can see "honda", in that case u will get result "Hond"



pls do rate

"F. Lawrence Kulchar" wrote:

What does:

IF(COUNTIF(D2,"*Honda*"),"Honda",D2)

this formula do??

i.e. what do the *______* accomplish??

Thanks,

FLKulchar