View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jgundel
 
Posts: n/a
Default 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!