excel if isnumber formula with wildcard

[STIRRELL]

Hi all, I am trying to look in cell E863 and see if the word deferred appears. I tried the formula below and I even added a wildcard before the D "*Def*", but for some reason sometimes excel was not seeing the word.
Sample in column E

off Deferred Aug20


=ISNUMBER(SEARCH("Def*",""&$E863&""))
Can you please help?
Sharon

 

[JimM]

Does this do what you want

=ISNUMBER(SEARCH("Deferred",E863))

 

[Fluff]

There is no need for wildcards when using Search.
That formula should work, what exactly is in E863?

 

[alansidman]

Use the Find function found on the Home Tab.