Excel Hack 81: Find and replace several items at once in Microsoft Excel (VBA hack)
Here is a custom macro for finding and replacing several items in an Excel list. This macro loops (runs) through a list of items on a table with two columns – old text and new text – and runs a find and replace operation for each row in the table using the text in the