If cell contains

[Guest]

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

 

[Tushar Mehta]

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

 

[Guest]

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

 

[Tushar Mehta]

You are welcome.

--
Regards,

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

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

{snip}