View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] lari.saukkonen@gmail.com is offline
external usenet poster
 
Posts: 3
Default =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :(

I'm having a problem while using excel 2002.
I have an estimated amount of 3500 cells containing text.

I also have 450 words and for all of them I have abbreviations.

What is the easiest way for me to manipulate those 3500
cells so that if they contained a word defined in this list of
450 words so that those words will be transformed into
each abbreviation?