About Us

The Rook[_2_]

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

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

--
Gary''s Student - gsnu200817

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find common strings of text then copy those rows elsewhere?	energyzone	Excel Worksheet Functions	6	April 20th 08 06:54 PM
Splitting Text strings in one cell	Wardy1	Excel Discussion (Misc queries)	1	May 18th 06 01:05 PM
linking four cell with multipule colums with other worksheet	syed rafi ahmed	Excel Worksheet Functions	1	May 6th 06 08:58 AM
How to find number of pairs of strings from list of strings?	greg_overholt	Excel Worksheet Functions	5	January 27th 06 10:42 PM
How to make a cell recognize multiple text strings?	Tourcat	Excel Worksheet Functions	1	February 8th 05 08:29 PM

Menu

About Us