Check out this link for a formula:
http://www.exceltip.com/st/Finding_a...tring/874.html

If you want to do this from VBA using a formula, see VBHelp on "Evaluate"

Mike F
"Vik" wrote in message
...
Hi All,

I am new in Excel programming.
I need to check if a cell contains a substring, something like "*excel*".

First, I tried

Set d = .Find(cdnName, LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False)

Only it looks like .Find cannot be used more than once. I have a nested
loop
and used .Find in a wrapper loop.

I need some alternative to .Find.

Thanks!