search exact word

[sanju2323]

I want to find out the exact word.

[AB33]

What is your desired out put? Just followed what you have put in column D

[sanju2323]

AB33, vba code is good work, is that possible from formula

[AB33]

I have converted in to a function so, it works like a formula.

[TMS]

@AB33: wouldn't you make the search word a parameter to make it more general purpose?

Please Login or Register  to view this content.

Regards, TMS

[sanju2323]

Thank you, both of you.

[AB33]

Hi Trevor,
Yes, it is a good idea. I would probably use "Alternates" , i.e. "|"if there are over 2 options.

[TMS]

You're welcome.

[sanju2323]

I should answer column B.