View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Find specific words in a cell containing a conversation

Hi
We have a spreadsheet which is basically a digital speech to text translation
from our phone system of a survey line.
We would like to try and find/pick out/highlight in one way or another
specific words such as Survey or transfer.

Is there a macro or a formula that can best achieve this.
Ideally the results would be flagged in the next available column saying the
word it found.

I have been bashing my head for a while on this. I found one formula but it
didnt work in my 2002 version i am using.

Many Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1