ExcelBanter - find multipule text strings within a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find multipule text strings within a cell (https://www.excelbanter.com/excel-discussion-misc-queries/212063-find-multipule-text-strings-within-cell.html)

The Rook[_2_]

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?

Gary''s Student

find multipule text strings within a cell

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

--
Gary''s Student - gsnu200817

All times are GMT +1. The time now is 10:26 PM.