Extracting specific text from another cell.

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

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.
 
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.
 
James,

thanks for your help. I actually used the IF statement with a SEARCH
function and that worked. I won't lose my notes this time.

Thanks again!
Doug
 
Back
Top