View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Replace only abbrevations

Use the Spell Checker/Corrector instead:

Tools Options Spelling AtuoCorrect
--
Gary''s Student - gsnu200755


"Dano" wrote:

I am working with some very long lists and trying to match data. I would like
to use the replace function to change "Corp" to "Corporation". However, when
I do It changes all the "Corporation" to "Corporationoration".