If cell contains
 

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

--
-Sam

If cell contains
 

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

If cell contains
 

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

If cell contains
 

You are welcome.

--
Regards,

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

In article ,
says...
I figured a way with that function. Thank you very much Tushar!

{snip}