View Single Post
  #5   Report Post  
Teresa Robinson
 
Posts: n/a
Default Finding text within text

You won't *believe* what " said on
14 Oct 2005 13:06:58 -0700, in microsoft.public.excel.newusers...:

Teresa:

The formula that I gave you before to use in the conditional
formatting dialogue works for finding a string of text either solo or
within another string. I use it myself frequently. It will
find"smith" as "Smith","smith" or "Mr Smith" OR "Dave smith ate a
porkchop". Lemme know how things are going... Mark
'


Will do. Had to spend the weekend putting in a new hard drive and
re-installing everything, and getting all my files off of my web
hosts. I haven't been able to put this to use yet, but I hope to this
evening.

Thanks!
--
Teresa Robinson
Staff Programmer Analyst
Anteon Corporation
trobinson at anteon dot com