find multipule text strings within a cell

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?
 
G

Gary''s Student

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting a sumproduct formula within a sumif formula. 2
Find text 4
Find text within cell 3
Find text and enter in new cell 4
ISNUMBER 2
Identifying text within a cell 9
Problem searching cell text 3
Find the first cell to contain text in a column 7

Top