Function that searches cell for string?
 

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

Function that searches cell for string?
 

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


"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

Function that searches cell for string?
 

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.


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

Function that searches cell for string?
 

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

Function that searches cell for string?
 

There are FIND and SEARCH worksheet functions that do this.

"IanMcGreene" wrote:


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.


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

Function that searches cell for string?
 

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" wrote in message
...
There are FIND and SEARCH worksheet functions that do this.

"IanMcGreene" wrote:


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.


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

Function that searches cell for string?
 

i could really use this equations also. thanks!
PCLIVE wrote:
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" wrote in message
...
There are FIND and SEARCH worksheet functions that do this.

"IanMcGreene" wrote:


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.


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

Function that searches cell for string?
 

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