Function that searches cell for string?

[IanMcGreene]

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!

 

[PCLIVE]

The standard Find feature should accomplish this. Edit - Find. Be sure to
uncheck "Find entire cells only".


"IanMcGreene" <[email protected]>
wrote in message
news:[email protected]...

 

[IanMcGreene]

No, I need a funcion call. I'm not simply trying to find something in
the cell, I'm looking to find a string and then act on it at another
cell.

 

[Beege]

Ian,

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

Beege

"IanMcGreene" <[email protected]>
wrote in message
news:[email protected]...

 

[KePaHa]

There are FIND and SEARCH worksheet functions that do this.

 

[PCLIVE]

Yes, But the problem comes in when the text does not exist in the cell.
Then the result is an error. Sorry, though, I do not have the answer.

 

[asimpleman]

i could really use this equations also. thanks!

Yes, But the problem comes in when the text does not exist in the cell.
Then the result is an error. Sorry, though, I do not have the answer.

 

[KePaHa]

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.