Thread: How do you Find and Replace the word "and" but not the and in "han
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do you Find and Replace the word "and" but not the and in "han
Be sure to type a single space before and after the and
--
Gary''s Student - gsnu200764


"Lyn" wrote:

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".
Reply With QuoteReply With Quote