Thread: Finding a text string w/in a Cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Finding a text string w/in a Cell
Will this do it for you?
=IF(ISNUMBER(SEARCH("disk",D9)),TRUE,FALSE)

SEARCH is not case sensitive, where FIND is case sensitive, and may
cause you to miss data. This is just an FYI to consider.

Reply With QuoteReply With Quote