How many of these would there be?

If it's a one-off you could use editreplace.

I'm not good enough with formulas to build you something that would replace
multiple abbreviations in a cell from a lookup list of abrreviations and
words.

Hopefully someone has an idea for you.


Gord

On Thu, 21 May 2009 06:43:41 -0700 (PDT), wrote:

Thanks Gord. I am still having a problem because I have multiple words
in each cell and I want to keep the original surrounding text. I have
a description of 3/4 RD BASE NAIL GLIDE PLN that I need to make 3/4
ROUND BASE NAIL GLIDE PLAIN by having the cell refer to a list of
abbreviations, but as I said my problem is keeping the original text
intact while expanding the specific words. Is there any way to do
this?