This should not be too difficult with the Edit-Replace function, but you can
do only one replacement at a time. In "Find what" type VAN; in "Replace
with" type VANILLA. Click Find Next, then Replace. If it works on two or
three cells, click Replace All. Then repeat this for each of the changes. If
you have trouble, click "Options" on the Replace menu for more parameters.
Also, you may have to widen some of the columns.

"jgundel" wrote in message
...
I am trying to replace about 1000 unique abreviations in about 4000 cells
in
Excel with their full word equivalent. I have a table of abbreviations
and
their longer versions. I want to find/replace without have to do 1000+
individual find/replace functions. The table looks like this.

LONG_NAME SHORT_NAME
VANILLA VAN
CITRUS CTRS
LAVENDER LVNDR
POTPOURRI POTPR
APPLE CINNAMON APLCN
ROSE RSE

How do I do a mass find/replace based on this table?

Thank you!