Replace a long list of abbreviations with full words in Excel
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!
|