Try =IF(ISERR(FIND("mike", B4,1)), "Error", "No Error") - this does one thing
if the FIND results in an error an another if it finds a match.

"Beege" wrote:

Ian,

I think that would be the "=SEARCH()" feature. it won't matter what case it
finds, upper or lower...

Beege

"IanMcGreene"
wrote in message
...

Is there a function that can search a given cell to find a given
string?

For example, I'm hoping to find a function that can tell if the word
'Travis' is in a cell that may have a number of names seperated by
commas (Dan, Travis, Leo).

Thanks!


--
IanMcGreene
------------------------------------------------------------------------
IanMcGreene's Profile:
http://www.excelforum.com/member.php...o&userid=37247
View this thread: http://www.excelforum.com/showthread...hreadid=570075