Without trying to sound stupid. I've used a formula to do this before.
Finding text is not a problem. But what I'm trying to achieve is, extract the
word finance any time it sees it and put it into another cell. If it doesn't
find it, it returns nothing. It's really more text in the cell, I just
created an example with some simple words.

"Doug" wrote:

I have a cell with multiple lines of text.
Example Cell "B" lists:
sales
finance
marketing
administration
etc.

I want to only pull the word finance. Some people may have it and others may
not. I'm looking to find who does.

Any help is appreciated. thanks in advance.