Searching For and Extracting Text From a Cell

[SeanBaird]

I have a search function which works perfectly for searching for Exact Numerical values, However I need to adapt it so it searches for text within a cell and only extracts that text. For example it searches column 7. In column 7 there may be a cell containing the words Interface - HPT, SAS, LPT Ideally I would like to search for the word Interface - HPT then extract Only this text from the cell. I also need the search function to be able to do this for multiple different values. So for example run a search for Interface - HPT Interface - SAS and Interface LPT separate from each other. Is this Possible ?

Here is the code I have at the moment:

Please Login or Register  to view this content.

I have also posted this question on stack overflow http://stackoverflow.com/questions/3...xt-from-a-cell

[SeanBaird]

I have since had assistance on this this is the answer incase anybody has the same issue

Please Login or Register  to view this content.