Find specific text in part of a cell

**woogster** · 03-15-2011, 10:42 AM

I am using the following formula to search for the referenced text in cell G2 within cell F3.

=IF(ISERROR(SEARCH(G$2,$F3)),"",G$2)

Is there a way to modify this formula so I only search part of the cell?

For example, I want to search only the portion of cell F3 that appears prior to the word "Interested" and ignore everything after. "Interested" may appear in any number of locations within cell F3.

Any help is greatly appreciated.

**arthurbr** · 03-15-2011, 10:51 AM

Perhaps

Please Login or Register  to view this content.

**6StringJazzer** · 03-15-2011, 11:06 AM

There is an error in the length calculation, I think you meant this:

Please Login or Register  to view this content.

**woogster** · 03-15-2011, 11:38 AM

Thank you both.

How do I manipulate the formula so that it searches cells that do not contain the word "interested" at all, while continuing to search those cells that do only up until the word appears?