Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find specific words and reference it | Excel Discussion (Misc queries) | |||
conditional formatting for specific words in cell | Excel Discussion (Misc queries) | |||
Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
how do I find an average number of specific words in a column | New Users to Excel |