find multipule text strings within a cell

  • Thread starter Thread starter The Rook
  • Start date Start date
T

The Rook

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?
 
=IF(ISNUMBER(SEARCH("PREP",E1036)),"PREP","") &
IF(ISNUMBER(SEARCH("BORE",E1036)),"BORE","")
 
Back
Top