Thread: Function that searches cell for string?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 168
Default 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



Reply With QuoteReply With Quote