View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default cell B1 contains a word listed in cell A1

Case-sensitive:
=FIND(A1,B1)
Non-case-sensitive
=SEARCH(A1,B1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Stan" wrote:

Is there a formula to use in order to confirm the following?

If a sentence in cell B1 contains a word in cell A1, confirm it in cell C1.
Words in column A is changing cell-by-cell.

thanks for yoru help.