Excel Find & Replace Multiple Words or Characters at Once | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

Описание к видео Excel Find & Replace Multiple Words or Characters at Once | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

Download the featured file here: https://www.bluepecantraining.com/fin...

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)
------------------------

Комментарии

Информация по комментариям в разработке