Download the featured file here: https://www.bluepecantraining.com/find-replace-multiple-words-or-characters-at-once-in-excel-3-methods-vlookup-substitute-vba-macro
In this video I demonstrate how to find and replace multiple words at once in Excel. I explore three methods that can be used to achieve this:
00:00 Introduction
00:44 METHOD 1: Use VLOOKUP or XLOOKUP for whole word find and replace
03:23 METHOD 2: Use the SUBSTITUTE function for partial match find and replace
05:36 METHOD 3: Use a VBA Macro for whole word or partial match find and replace (lots of replacements)
------------------------