Function that searches cell for string?

  • Thread starter Thread starter IanMcGreene
  • Start date Start date
I

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!
 
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.
 
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.
 
i could really use this equations also. thanks!
PCLIVE said:
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.
Click to expand...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Let me explain my problem... (Roommate Accounting) 2
How do I creat a macro to delete the first 20 cell characters 5
vba code help for multiple string searching 0
find and replace numeric strings in larger text strings 8
Formula Help 0
search for a particular string in cells 3
count no. of commas (,) in a string in a cell 3
Is there a function that will evaluate a text string in a cell? 2

Back
Top