View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Extracting specific text from another cell.

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.