| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
| more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Threaded Mode
