Searching for text in a string

Hi All

Can anyone help, this one might be a bit of a challange...... i'm trying to find a formula that looks into a cell for certain text, so for instance in the example below there is a text range in cell B1 "OSNO NOTE OSTS NOPT INT" i want to search in this text range for the words "INT or EXT or INIT", then i want to display the text found in cell C, does anyone know if this is possible ?

Presentation1.jpg

Thanks

Jedski

With your sample data in B1:B3
AND...
This list in G1:G3
INT
EXT
INIT

This regular formula returns the last Col_G list word that is found in Col_B
C1: =IFERROR(LOOKUP(10^99,SEARCH($G$1:$G$3,B1),$G$1:$G$3),"No Match")

Copy thatformula down through C3

Is that something you can work with?

There's no native Excel formula that will highlight specific text within a cell.
What you're looking for could be done with VBA.

This appears to be the same question that you're asking here: http://www.excelforum.com/excel-form...ther-cell.html