Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching for specific text
well, maybe you'll know how to do it with the bigger picture. I'll give you
an €Žexample: there is a textbox column that might contain the sentence "a box of €Žchocolate". I have another column that needs to say what kind of candy (from a €Žknown list of possibly candy) it is the first column. now I need a function that will €Žautomatically finds which of the keywords is in the textbox column and gives the €Žanswer in the second column.€Ž |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching for specific text
Hello,
If you do not get a reasonable response, please send the workbook to: Any confidential information received will not be shared with any persons, living or presumed dead. http://www.geocities.com/excelmarksway "clerk" wrote: well, maybe you'll know how to do it with the bigger picture. I'll give you an €Žexample: there is a textbox column that might contain the sentence "a box of €Žchocolate". I have another column that needs to say what kind of candy (from a €Žknown list of possibly candy) it is the first column. now I need a function that will €Žautomatically finds which of the keywords is in the textbox column and gives the €Žanswer in the second column.€Ž |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Searching text in a cell range | Excel Worksheet Functions |