=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :(
Can you post some examples?
--
Biff
Microsoft Excel MVP
wrote in message
...
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?
|