View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sebh007 sebh007 is offline
external usenet poster
 
Posts: 5
Default Find text - worksheet function or macro?

I have text in A2-A1500. All of the cells contain long strings of text. I
want to identify which cells contain "ItemA" or "ItemB". As I am weak in VB
I would prefer to use worksheet functions if possible. I tried using FIND
but that returns #VALUE! if the string does not exist. All suggestions
welcome!