I figured a way with that function. Thank you very much Tushar!

"Tushar Mehta" wrote:

Check XL VBA help for the InStr function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
What is the function to check if cells(1,3) contains word "test"?
Cell may contain for example text "this is test" and I want to find if some
of those words is "test".

Thanks