View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
clerk
 
Posts: n/a
Default 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.€Ž