View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duncan Duncan is offline
external usenet poster
 
Posts: 26
Default Searching Cells in Excel

I need to set up a search function in Excel so that it can idetify a given
word in a sentence, which is written in one cell. For example,

If Cell A1 is the place where the word you are looking for is written.

Then in Cell B1 the following sentence is written: "I like playing
football".

If the user puts in "football" in cell A1, I need it to return a true for B1
because it regonises "football" in the sentence.

--
Duncan