View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lyn Lyn is offline
external usenet poster
 
Posts: 35
Default How do you Find and Replace the word "and" but not the and in "han

I thought there was a - match whole word - option with the Find and Replace
tool but I don't see it now. I'm trying to replace every "and" with "&" but
not affect any words that contain "and" such as "hand" or "bandit".