Thread: find multipule text strings within a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
  
Posts: 70
Default find multipule text strings within a cell
I have a column of cells that contain text. At present I am able to find
cels with a spcific text string using the following formula:

=IF(ISNUMBER(SEARCH("PREP",E1036)),"PREP","")

what I am now wanting to do is find cells containing 2 would for text "PREP"
as above "BORE"

Can this be done?
Reply With QuoteReply With Quote