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

Find specific words in a cell containing a conversation
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:9d308d030a02e@uwe...
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

Find specific words in a cell containing a conversation
 

On Wed, 07 Oct 2009 11:14:25 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe
wrote:

Worked a Treat - you are fantastic Ron !

Glad to help. Thanks for the feedback.
--ron