if cell contains any of the entries in a column, insert specific text in neighboring cell

Hi robby,

Find the attached with some VBA code that will go down your list on sheet 2 and replace the Abbreviation with the Replace word.
Run the Macro while on Sheet1. This should give you an idea of how I'd do the problem.

Let me know if you understand any part of the VBA. If you do and need the stuff between the parins removed, I can do that too.